Purchase Order Tax Intacct Integration

Users now have the ability to calculate tax on a purchase order.  The same tax jurisdiction can be applied across the entire purchase order, or each line item can be given a unique jurisdiction.  This feature has to be enabled on the accounting tab of Parameters.

Allow PO Line Item Tax - Turn on ability to assign tax jurisdictions to purchase orders/purchase order line items and map to Intacct.

Split PO Line Item Tax - Turns on the passing of the jurisdiction breakout in the tax jurisdiction to Intacct.

Use AP Intacct Bill - With this enabled, purchase orders get passed to Intacct as AP Bills instead of Purchasing Transactions.

When enabled, a new field will appear on the Tax Jurisdiction screen labeled ‘Linked AP Tax ID’.  This must match the corresponding tax ids entered into Intacct.  The tax percent to be charged will be entered in the Tier 1 column in the ‘Sales Tax’ field.  This percentage will apply to any item on a purchase order, whether it is rental or sale.  The other fields/tiers are not applicable.  Tax jurisdictions used on purchase orders should not be used on contracts and vice versa.  Tax jurisdictions are created from Configurations>Accounting Configurations>Tax Tables.

If desired, the tax can also be allocated by jurisdiction.  Each jurisdiction can be mapped to its own AP Tax ID.

After these have been set up, the user is ready to write a new purchase order.  The purchase order will initially either use the default tax jurisdiction of the vendor or use the store default tax jurisdiction if the vendor does not have a specific default jurisdiction.

This will flip all items on the purchase order to the new jurisdiction if the user answers the below question in the affirmative.  If the user says ‘no’, the existing items on the contract will stay with the original jurisdiction and only new items added to the purchase order will use the new jurisdiction.

The tax jurisdiction can also be assigned on a per line basis, by double clicking on the tax jurisdiction name in the line. This will bring up a selection screen of all of the tax jurisdictions in the system and the user can select the appropriate one.

Due to rounding differences (usually a penny one way or the other), the user may sometimes need to override the tax.  This cannot be done in the totals section, but it is done online.  Simply double-click on the tax amount and enter the new amount so that the purchase order matches the invoice sent from the vendor.

Once the purchase order is closed and verified, it will post to intacct.  The tax of each item will come over as an individual`line item on the purchase order in intacct with the proper tax id label.  Reporting can then be run against the tax ids.