3.3.6 Activity: Test the Shipping Cost Formulas

MikeCrippen · 2023-06-09T23:07:34+00:00

There was an error rendering this rich post.

I am stuck! My Confirmed PO Delivery and Confirmed Purchase Order Receipt are not updating correctly. This also seems to be part because when I Override the shipping Method, the Final Shipping Time in Weeks is not updating. I have attached screen shots of my module and formulas. Any guidance is much appreciated!

Lesson Example

My Module and Formulas:

Accepted answers

All comments

Relanto

Hi @MikeCrippen

I think you should try this formula "IF NOT Submit Purchase Order Request? THEN 0 ELSE IF Override Suggested Order Amount? THEN Override Amount ELSE Suggested Order Amount for the Month" in the Final Shipment Amount.

Hope this helps you

MikeCrippen

@Hrutuja Dalvi Thanks for your response! That updated the amounts. For some reason my Final Shipping Weeks are not updating when I override the Shipping Method?

Relanto

Hi @MikeCrippen Can you please share the "TRA01 Shipping Metrics by Week "module view and also the formula which you have applied to the Final Shipping Time Weeks

MikeCrippen

Hi @Hrutuja Dalvi thanks for the quick response. I have attached screen shots of how I have the module pivoted and the blueprint.

Relanto

@MikeCrippen This module seems to be fine, In Final Shipping Time Weeks formula are you looking up to the Final Shipping method..?

Because to get the value we should lookup the Product Product and Final SHipping method

MikeCrippen

Hi @Hrutuja Dalvi this is my formula for INV01 Final Shipping Time Weeks: 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

Relanto

HI @MikeCrippen please try this "'TRA01 Shipping Metrics by Week'.Shipping Time[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]".

The formula should refer to the Final shipping method.

Hope this helps:)

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…