Thursday, August 20, 2020

NAV / BC - How to setup US Tax of Multiple taxes to apply to a single sales transaction

 Example: Sale of 100 requires 2% GST and 15% VAT = 100 + 2 + 15

Both need to be tracked and reported in separate tax statements.


Solution:

  • Use NA Localization
  • General Ledger Setup
    • Vat In Use = False
  • Tax Posting Setup
    • No entries, blank combination must be set to vat calculation type "Sales Tax"
    • Products must have blank tax product posting group
    • Customers must have blank tax bus. posting group
  • Setup Tax Areas
    • Zone1
    • Setup and assign Jurisdiction codes and report Jurisdiction to allow Collected Sales Tax report to work
      • GST
      • VAT
      • Setup and assign Tax group Codes to each jurisdiction
        • MFGGOODS (GST and VAT)
        • SLSGOODS (Vat Only)
          • Set Tax details on each combination
            • set Max Amt Qty to 0
            • Set tax above max to 15 and 2 respectively
  • On Company
    • Set Tax Area code
  • On Location
    • Set Tax Area Code
  • On Item
    • Set Tax Group code
  • On customer
    • Set Tax Liable
    • Assign Tax area code
  • Create Sales Order>See tax calculate in total
  • View Tax Entries for summary tax information by transaction
  • Run Sales Taxes Collected Report to view taxes


No comments:

Post a Comment