Skip to main content

ERP transaction limits vs commercial limits

  • May 13, 2025
  • 4 replies
  • 149 views

As a commercial importer of lighting products from all over the world, we also distribute in all of North America. In the past uploading Price lists and modifying our prices was once or twice a year during the beginning of the year. We only used to upload current inventory or requested inventory items into Acumatica. This was a 6 transaction event for each product due to currencies, landing factors, shipping and duties. 

However as we have grown we need to upload all our vendor price lists. This did not seem to be an issue: until the world changed this January and pricing needs to be updated monthly.  I cannot express the frustration of having to update prices and as a result  we are being choked and asked to upgrade to large enterprise level “no Limits” licenses.

We are a small/medium size business and ave spent over 500k getting Acumatica to work for our business. I want to see if others are having the same issue, there should be allowed a scheduled server downtime to upload, update or add items into the database that does not choke our allocated ERP transactions. I have no issue paying a reasonable fee, but we are beeing asked to upgrade by 20% to accommodate this situation.

How do other small businesses with large item lists operate? We have almost 200K items that when we update x6 transactions it can be 300k ERP transactions a month due to current market changes. 

4 replies

Forum|alt.badge.img+1
  • Semi-Pro I
  • May 13, 2025

We’re in a different world, but I absolutely understand the pain.  I know a lot of customers (us included) bought into the Acumatica idea of paying based on our business transactions and then got slammed with the notion of being out of compliance because (in our case) we have 280,000 SKUs and have to do quarterly price changes, and that’s in addition to other activities that don’t touch Business Transactions, but increase our ERP transactions considerably.

We did wind up biting the bullet and going to Enterprise licensing, but we weren’t happy about it.  


Adding to this, we also Import and have a large EDI Base. In looking at ERP Transactions Updating Statuses in SPS Commerce all the lines count as ERP transactions. This is ridiculous - Charge for going out then charge for confirming the status. On top pf which the SPS/Mapadoc Screens are not accurate, so you end up running a couple of times to get accurate information. Now they count as ERP transactions.


Dana Moffat
Community Manager
Forum|alt.badge.img+2
  • Community Manager
  • September 2, 2025

Hi ​@johnkasprzyk30,

I have reached out to your VAR/partner to let them know about your comment. Your VAR will be reaching out soon to you.

Thanks,
Dana


Chris Montini
Freshman I

We have the exact same complaint.  We need to update pricing once a month for our top 20 vendors and it is pushing us over the ERP Transaction threshold.  It’s frustrating that a simple price update counts as an ERP Transaction.