3.3.5.4 Update INV01 Inventory Ordering to Allow Override of Order Amount

GAPER · 2023-09-25T05:42:28+00:00

There was an error rendering this rich post.

I got a circular reference for the below action.

Redirect the formula for this line item that currently references the Suggested Order Amount for the Month line item to the Final Shipment Amount line item instead.)

This is the original formula for Confirmed Purchase Order Receipt

IF
	Confirmed PO Delivery > 0
THEN
	OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0)
ELSE
	0

Since final shipment amount is a function of starting function - demand + confirmed purchase order receipt. I do not understand how could we replace this offset with final shipment amount.

Here are the formula for other calculations

Thank you.

Accepted answers

gaurav

yeah check your final shipment amount.

All comments

gaurav

Hi @GAPER use POST function in Confirmed Purchase Order Receipt.

your formula will look like POST(Final Shipment Amount, Final Shipping Time Weeks).

Cheers

GAPER

Master Kumar, it still show circular reference so i wonder if there are anything wrong in other lines….

Thanks

GAPER

I think i have fixed the issue - I used a wrong if case for the final shippment amount

gaurav

yeah check your final shipment amount.

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
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…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…