By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
2
Posts
2
Users
1
Reactions
1,292
Views
September 7, 2022 10:57 pm
Does anyone have a good way to calculate the weeks of supply based on the current available inventory? I’m trying to add this to a GI and my thought was to base it on the qty sold over the past 60 days; taking that qty divided by 8.57 (the approximate # of weeks that are in 60 days) would give me the qty sold per week. Then I’d need to divide the qty available by the qty sold per week to get the # of weeks supply. But I can’t figure out how to make that work in a formula.
1 Reply
September 11, 2022 6:44 pm
I doubt you can do it in GI as it requires calculations to be applied to aggregates and GI isn't good for that.
You might need to migrate the GI to Report Designer and do it there with variables.