Landed Cost Func. Total calculation

(0) Share

Report

Posted on by JBS ERP

1,175

Hello,

I have a question regarding the landed cost set up. I have set up a landed cost ID for CIF. I set "Cost Calculation Method" as Percent of Extended Cost. The percent was set as 8.961%.

When I tried to test this setup, landed cost func. total didn't match with the amount I expected.

Example:

Receive Type: Shipment/Invoice

Receive items without PO

Do not set up landed cost group ID for each line

Extended Cost = subtotal = $60,518.16

With above record, the landed cost func. total displayed was $5376.60. I expected the landed cost should be $5423.03 ( = $60,518.16*8.961%). There was $46.43 discrepancy of what I expected. We don't use multicurrency exchange either, so I am not sure why the landed cost total came up with that amount.

Could someone please advise or let me know if I miss setting somewhere or why the landed cost func. total came up short?

I appreciate any of your help.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

I tested this scenario in my system and it calculated the correct amount - $5423.03. I would go back and look very carefully (maybe even get another set of eyes on it) at every setting in the L/C ID and L/C Group setups. I'm running GP2010 R2, SP2.

Hope this helps,

Was this reply helpful? Yes No
JBS ERP 1,175 on at

Like (0)

Report

Thank you Frank. I think the difference was occurred because we set up currency decimal for 2. When we change the currency decimal to 5, the amount matched.

Was this reply helpful? Yes No