Skip to main content

I have a client currently who does Vendor Pricing and they need to update sometimes over 100,000 records. I know this isn’t feasible with the Price Worksheets as they have a limitation. I am looking to see what others have done to get around the limitation in Acumatica. Obviously using the Vendor Prices is not ideal because it would take too long to update. 

 

Thank you!

@kbeatty21 I think Vendor Price Worksheets are your best option. On the Customer Pricing side, we have a client that has >60k parts and >seven pricing levels with frequent updates. Here are the tips I’ve learned along the way. Keep the commits in the import scenario to the bare minimum (end of each row?) - as the worksheet gets larger, it is the save that takes the time. Break up the vendor price sheets using some logical division, vendor, classes,... Keep the number of rows as low as feasible, but you can see we pushed 80k a number of times. Run the load after-hours if possible :)

 

 


HI @DConcannon 

I figured that was my only route unfortunately. I have an import scenario as well that I was testing but it didn’t like a few of my fields, so I will retry with that. 

Thanks for the tips! I have already stressed with them the importance of running these after hours as that is when they have the best chance to have it go faster. 

I appreciate your help :)


Were you able to create an import scenario for this? I’m struggling to do the same.


Reply