0

Tax reporting – Refundable Tax Delivered to Customer

  • 10 February 2012
  • cre8
  • 0 Comment

Some states and countries have refundable taxes collected, and these need to be reported. One reporting requirement is system calculated tax where a manually calculated tax was applied. This comparison allows errors to be defined more readily, and assists in the reconciliation process.

A new report was generated to show taxes in both forms- system calculated, and the actual manual tax applied. A customization was required to support reporting, though no change to the User Interface was made.

Taxes by  Invoice date range

  • Columns:
    • Supplier
    • Invoice number (where Open Payable = false)
    • Invoice Date
    • PO
    • PO Line
    • Part Number
    • Supplier qty
    • Unit price
    • Taxable flag
    • Tax Type (UD Field)
    • Initial tax amount
    • Applied tax amount
    • Tax Code
    • Misc Charge Code
    • Type (A/P)
    • Misc Charge Amount
  • Filters
    • Tax type (UD field)
    • Invoice date range

Example report format:

Tax_Reporting_1-1024x643

 

Leave a Reply

Your email address will not be published.