...
In Configurator (SIGACFG), access Database/Dictionaries/Database and configure/create the following fields:
Table SB1 – Product Register
Table | SB1 |
Field | <customer criterion> |
Example | B1_PPSSTCG |
Type | Numeric |
Size | 8 |
Decimals | 4 |
Format | @E 999.9999 |
Help | Enter the PIS coefficient for use in Tax Substitution calculation |
Table | SB1 |
Field | <customer criterion> |
Example | B1_PCFSTCG |
Type | Numeric |
Size | 8 |
Decimals | 4 |
Format | @E 999.9999 |
Help | Enter the COFINS coefficient for use in Tax Substitution calculation |
Table | SB1 |
Field | <customer criterion> |
Example | B1_PUPCCST |
Type | Numeric |
Size | 8 |
Decimals | 4 |
Format | @E 999.9999 |
Help | Unit Price of retail sales for PIS COFINS calculation by Tax Substitution. |
The fields created in table SB1 must also be created in table SS4, to record the Tax History considering these fields as well. You must create them with the same properties, changing only the prefix of the name; that is, instead of B1_ create it with a S4_.
...
Below, the layout of the file with the data sources when processing products (SB1):
CNPJ (EIN) | SIGAMAT Register |
COD | Product Code |
GTIN | Not generated |
DESCR | Products Register Description |
STATE | Content of parameter MV_ESTADO |
PRICE | Content of SB1 field entered in parameter MV_PUPCCST |
INIC_TAB | Date of Tax History, table SS4 |
INIC_TAB ANTERIOR | Date of Tax History, table SS4 |
Tax Exception Configuration:
...
Below, the file layout with data sources when processing products linked to the taxation group of Tax Exception (SF7):
CNPJ (EIN) | SIGAMAT Register |
COD | Product Code |
GTIN | Not generated |
DESCR | Products Register Description |
STATE | Content of field F7_EST |
PRICE | Content of field F7_PRCUNIC |
INIC_TAB | Date of Tax History, table SS1 |
INIC_TAB ANTERIOR | Date of Tax History, table SS1 |
When a tax exception has a valid rule for all States; that is, field F7_EST is equal to “**”, data are generated for all States (one line for each state).
...
If the value of a product is entered in SB1 and also in the Tax Exception, to avoid duplicating records, a filter is created using the product code, start date and state.
...
Tables | SFT – Tax Records per Invoice Item SB1 – Product Register SF7 – Tax Exceptions Register SS1 – Taxation Group SS4 – Generic Product Description |
Related Features | MATXFIS SPEDPISCOF - SPED PIS COFINS |
Operating Systems | Windows®/Linux® |