topic Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109937#M26508 < P >你好,< / P > < P >, < / P > < P >之后的工作formulae in this section , the expected result is not as shown is section 3.3.5.3.

Please find attached the screenshots of the "my output", "expected output" and the "Sys01 time setting". Request you to guide me where am I committing the mistake so that I can proceed.

 

Thank you,

Har**bleep**ha.

 Mon, 31 May 2021 03:30:38 GMT harshitha.narayan@sony.com 2021-05-31T03:30:38Z Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109937#M26508 < P >你好,< / P > < P >, < / P > < P >之后的工作formulae in this section , the expected result is not as shown is section 3.3.5.3.

Please find attached the screenshots of the "my output", "expected output" and the "Sys01 time setting". Request you to guide me where am I committing the mistake so that I can proceed.

 

Thank you,

Har**bleep**ha.

 Mon, 31 May 2021 03:30:38 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109937#M26508 harshitha.narayan@sony.com 2021-05-31T03:30:38Z Re: Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109938#M26509

harshitha.narayan@sony.com 

Please check the 'Ending Inventory' Formula because of this Reorder Flag is set. This might be the reason for numbers not matching.

 Mon, 31 May 2021 04:26:51 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109938#M26509 rajuvendra01 2021-05-31T04:26:51Z Re: Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109940#M26510

@rajuvendra01 Thank you for your reply.

 

I will again check on this and get back to you.

 

Regards,

Har**bleep**ha

 Mon, 31 May 2021 06:41:50 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109940#M26510 harshitha.narayan@sony.com 2021-05-31T06:41:50Z Re: Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109946#M26513

Hi @rajuvendra01 

 

I had committed two errors:

  • First is that the ROUNDing to be applied for the line item Initial Demand forecast (DEM03 Demand Forecast module) was wrong. I corrected this first. Because of this, the line items like Forecast demand, Suggested Order Amount for the Month were all getting calculated incorrectly.
  • Secondly, as suggested I revisited the formula for "ending inventory" and noticed that the sequence I was trying to subtract the Sum of Beginning Inventory  and Confirm Purchase Order Receipt with Forecast demand was wrong.

Thank you for providing the hint.

 

Regards,

Har**bleep**ha 

 Mon, 31 May 2021 08:38:47 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-3-3-5-2-Inventory-Ordering-Module-Formulas/m-p/109946#M26513 harshitha.narayan@sony.com 2021-05-31T08:38:47Z