3.3.5.3 Check Your Work - I don´t understand were I´m wrong.

OscarSalazar · 2023-06-29T15:27:23+00:00

There was an error rendering this rich post.

I have done all formulas and checked my work against the course examples and everything was good until I review the Nutzo Bar_En selecting the Submit Purchase Order Request? I get the following:

The example given in the course says that the confirmed Purchase Order Receipt for Jan20 should be 8,194 but I get 8,396 (same as in week 5), I double checked my formulas and I don´t know what I´m missing, my formulas are set as following:

I kept going a couple of lessons further, but I don´t want to keep going having that error and not getting the correct amounts.

Thanks.

Accepted answers

All comments

Venki9902

Hi @OscarSalazar ,

There seems to be a problem final shipping time weeks lineitem.

Can you share the formula for the same?

Regards,
Venkatesh

OscarSalazar

Hi @Venki9902,

Thanks for your answer, my formula for "Final Shipping Time Weeks " is:

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

But I made a change in the "Confirmed Purchase Order Receipt" Line Item that was creating my issue, the new formula for this line item is:

IF Confirmed PO Delivery <> 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

With these changes and some others I Think I got everything on spot now.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…