Excise Tax Report

Overview

• AATC needs to collect Excise Tax for items over a certain size.

• The tax is 12% of the total invoice before the Sales Tax.

  • On the invoice, there could be other items that are not over a certain size.

• The Excise Tax must be paid in one week after cash collection.

Setups

• On the Item page, add one check box field: Done

  • Collect Excise Tax

• On the Company Setup page, add 2 fields: Done

  • Excise Tax Rate (percentage)

  • Excise Tax Service Item, an item lookup field.

    • Must point to a Liability GL Account on APS for the item (ask AATC)

Saving Sales Order

• System will automatically create a Sales Line for the Excise Tax.

Sales Order and Sales Invoice Process

• When creating Sales Invoices from Sales Orders, test to make sure the Excise Tax Sales Line is added with the right amount when conditions are met. Done

• When posting Sales Invoices, test to make sure the Excise Tax Sales Line is added with the right amount when conditions are met. Done

Notifications

• Write a flow to notify users when the Excise Liability GL Account is changed and the new Amount is not 0.

• Where do they define the Excise Liability GL Account? APS? if APS, which field?