If a sales order item only has a single price and not a calculation procedure used to determine the net price, how would you calculate sales tax on an alternate amount? One of our companies sells products at wholesale to independent contractors who in turn sell those products at retail to end customers. The company is responsible for calculating, reporting, and remitting sales tax on the order item that was sold to the contractor, BUT that sales tax is calculated on the retail price of the item, not the wholesale price. That’s a very easy task in our current ERP, which can have any number of “statistical” pricing conditions on the order item pricing procedure. I’m not able to picture how that would work in Acumatica. Thanks.
Answer
Calculate Sales Tax on Alternate Price
Best answer by bbohn
The workaround for this requirement was to use a tax assist rule in Vertex as it was not solvable in Acumatica without code customization. It appears that the Tax ID settings are ignored for external calculation: the Cash Discount setting “Does not Affect Taxable Amount” did not work for sending the correct amount to Vertex in the request. So, to set the correct amount for tax calculation, a tax assist rule was necessary to adjust the Extended price as the pre-discount unit price multiplied by the item quantity:
+1I recommend testing out the Sales Prices and Sales Price Worksheet functionality to differentiate varying prices by customer and then reviewing the taxes applied when processing orders.
https://help.acumatica.com/(W(7))/Help?ScreenId=ShowWiki&pageid=d63d6b6c-15ee-4576-bf27-8de69f8f5da6
VANESSA AFONSO :: Product Support Specialist | Acumatica | Columbus, OH.
Thanks for the response. I’m aware of how customer pricing works. My question is about calculating sales tax on one price while actually charging another price to the “customer”. This procedure is common in direct sales where a 3rd party (independent) sales rep is purchasing products and then selling them to an end customer. The corporation providing the wholesale distribution (us) is responsible for sales tax at retail, not at the price that the sales rep paid. Acumatica’s sales order pricing approach isn’t as robust or flexible as other ERP systems, but I was hoping that there’s something obvious that I’m missing. Hopefully, there’s a solution involving discounts. I haven’t investigated the sales tax connector setup yet. At worst, we may have to combine an order with a tax adjustment, but that seems messy.
The workaround for this requirement was to use a tax assist rule in Vertex as it was not solvable in Acumatica without code customization. It appears that the Tax ID settings are ignored for external calculation: the Cash Discount setting “Does not Affect Taxable Amount” did not work for sending the correct amount to Vertex in the request. So, to set the correct amount for tax calculation, a tax assist rule was necessary to adjust the Extended price as the pre-discount unit price multiplied by the item quantity:
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.