Object Specifications
Sales Tax Calculator
Purpose of Application
Split Tax calculator program in two: Sales and Purchasing are now separated objects.
Tax Calculator for Sales Order Entry adjustments.
Add Advanced Pricing functionalities.
Apply changes made for World software:
2. Advanced Pricing - Repasse logic.
3. Advanced Pricing - Discounts calculation.
4. Advanced Pricing - Free Port Discount.
5. Modify how the tax calculator populates Discounts Field FDBDES.
6. Modify ICMS Substituiton Decision Routine.
7. Modify formula for applying reduction to ICMS substitution basis and move the logic.
8. Add freight, insurance and additional expenses logic.
9. Check new small functionalities added up to Cum 9
Enhancement Type: New
Purpose of Application
BDES (Trade Discount) and BDIZ (Free Port Zone Discount) are now being updated to F7611B after the Tax Calculations.
Data Structure D7600850 (Brazilian Tax Calculator) changed to return the two new discount fields.
Enhancement Type: Changed.
X76TAXBS - Sales Tax Calculator Brazil
Business Function Summary
Design Changes
DateDesign ChangeCompleted Date
August 1998Advanced PricingAugust 1998
August 1998World sortware Cum 9 changes
Issues for Review Session
DateDescription of IssueDate Resolved
Type of Business Function (Logic Class)
Business Function Origin
C
Sources in this Business Function
No.TypeSource DescriptionData Structure
1b4100210Get Item Branch Informationd4100210
2b4000460Free Pointerd4000460
3b4200140Get Ship To Billing Instructionsd4200140
Related Tables by Source
Source Table DescriptionPrimary / SecondaryModeKey Fields or Notes
F0101Address Book Read
F0150Address Organizat.Read
F4074Price AdjustmentRead
F4201SO HeaderRead
F4211SO DetailRead
F7601BNF HeaderRead
F7611BNF DetailRead
F7608BICMS Tax RatesRead
F7615BTransact. NatureRead
F7617BTax SummaryRead
F76B18IPI Tax RatesRead
Performance Impact
Required if changed or new
Business Function
D7600850 - Tax Calculator for Brazil - 00
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
idNFHeaderRecord | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
idNFDetailRecord | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
szTaxArea1 | TXA1 | char | NONE | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szTaxExplanationCode1 | EXR1 | char | NONE | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
mnAmountTaxableIPI | BBTP | MATH_NUMERIC | NONE | NONE |
The amount on which IPI taxes are assessed. | ||||
mnAmountIPITax | BIPI | MATH_NUMERIC | NONE | NONE |
The IPI tax amount that is printed on the nota fiscal. | ||||
mnAmountIPITaxRecoverable | BIPR | MATH_NUMERIC | NONE | NONE |
The IPI tax amount that is eligible for recovery. | ||||
mnIPITaxRate | TXR2 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnAmountICMSTaxableAmount | BBCL | MATH_NUMERIC | NONE | NONE |
The amount on which ICMS taxes are assessed. | ||||
cFlagICMSTaxSubstitutionMarkUp | BIST | char | NONE | NONE |
A code that specifies whether a client or product is subject to tax substitution. Valid values are: Y Use list price. Z Use net price. N No. | ||||
szCodeICMSTaxStatus | BSTT | char | NONE | NONE |
Enter a two-character code to indicate the ICMS tax eligibility of a product. The value you enter for the first character of the code indicates
| ||||
mnAmountICMSReducedTaxable | BBIR | MATH_NUMERIC | NONE | NONE |
The amount on which ICMS taxes are assessed. In this case, the ICMS taxable amount is reduced due to the sale of given products. | ||||
mnAmountICMSRepassDiscount | BREP | MATH_NUMERIC | NONE | NONE |
An additional discount granted to the client on interstate sales. It is based on the tax rate difference among states. | ||||
mnAmountICMSTax | BICM | MATH_NUMERIC | NONE | NONE |
The ICMS tax amount that is printed on the nota fiscal. | ||||
mnICMSTaxRate | TXR1 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnAmountICMStobePaid | BICP | MATH_NUMERIC | NONE | NONE |
The ICMS tax amount that is to be paid. | ||||
mnAmountICMSSubstitute | BVIS | MATH_NUMERIC | NONE | NONE |
The ICMS Substitute amount that your customer must remit in advance if they are subject to Tax Substitution Mark-up. | ||||
mnAmountTaxableICMSSubstiT | BBIS | MATH_NUMERIC | NONE | NONE |
The amount on which ICMS Substitute tax is assessed. Products that are eligible for ICMS Substitute tax are listed in ICMS government
| ||||
cCodeIPIReportingColumn | BFIP | char | NONE | NONE |
A code that indicates how IPI tax is assessed. This code determines in which column of the Inbound/Outbound Fiscal Book the system
| ||||
cCodeICMSReportingColumn | BFII | char | NONE | NONE |
A code that indicates how ICMS tax is applied. You set up the codes that you need in the ICMS Code - Fiscal Value UDC (76/II). The system
| ||||
mnAmountFreePortZoneDiscou | BDIZ | MATH_NUMERIC | OPT | NONE |
The amount of the discount available to a free port zone customer. | ||||
mnAmountNotaFiscalTotalDis | BDES | MATH_NUMERIC | OPT | NONE |
The amount of the discount amount available for the Nota Fiscal. | ||||
szCodeICMSTaxStatus_BST1 | BST1 | char | OPT | NONE |
Enter a three-character code to indicate the ICMS tax eligibility of a product. The value you enter for the first character of the code indicates
| ||||
cTagRecevrFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
None |
None |