Skip to main content
Question

Calculate Sales Tax on Alternate Price

  • December 13, 2024
  • 2 replies
  • 26 views

Forum|alt.badge.img
  • Jr Varsity III
  • 21 replies

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.

2 replies

vanessaafonso02
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Support Team
  • 25 replies
  • December 19, 2024

I 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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 21 replies
  • December 19, 2024

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings