3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs

Hi all,

I'm having difficulties with the Shipping Cost line item. I am getting an error on the formula below…Can someone kindly point me in the right direction

Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: Shipping Methods]

Accepted answers

HimanshuRaj

Hi @EJamr

Try this formula: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

Hope, this resloves your issue. If not, then can you share the screenshot of what specific error are you facing?

All comments

HimanshuRaj

Hi @EJamr

Try this formula: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

Hope, this resloves your issue. If not, then can you share the screenshot of what specific error are you facing?

EJamr

Thank you.. I missed out the lookup piece…

dpong8898

Sorry, I think you made a mistake here!

I believe the formula should be as follows,

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…