Is it normal to have small discrepancies in numbers, between my results and what's in Review the INV01 Line Item Formulas and Summary Method settings. In the attached screen shot, I have not accounted for the different summary methods yet.
Example (Submit Purchase Order Receipt check box is selected):
- Beginning Inventory - Week 3 FY 20, I have 8,947 whereas the results are indicating 8,902
- Forecast Demand - Week 2 FY 20, I have 2,005 whereas the results are indicating 2,050 - however our totals for Jan 20 are the same.
- Suggested Order Amount for the Month - we have the exact same values for Weeks 1 -4 however for Jan 20 i have 32,596, and the results are showing 32,776.
I don’t think there should be any discrepancy in the numbers as long as you submit your purchase order in the same week what is to be expcted. Summary methods should also be kept appropriately as you don’t want some weekly numbers to be added into months. For example week 3 beg inv should not have that much diff - that might be due to incorrect calcs or purchase order submitted in diff week.