I am wondering if anyone has a nice way of getting rate tables to populate pricing on a project quote. Currently the pricing that pulls through is on the inventory item - which isn't super helpful when you're trying to quote out to many different customers who have their own rate tables. It's weird because even when you make a project template with a rate table Acumatica doesn't care - it just pulls the pricing from the item.
My initial solution would be to build an inquiry for rate tables, allow it to be refreshed in Excel, and then when my sales team fills out their estimates in Excel and loads them into Acumatica the pricing would push from Excel and the known rates in the file.
I don't WANT to do that, as the whole reason for an ERP is your information is all in there, and I would prefer we don't change pricing and leave that to the system to make sure it's all correct!
Anyone else have a nicer work around?