This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.


How to distribute cost to a product or a purchase order

Dear all,

I want to add extra cost other than the product cost, such as transportation, freight, loading, or even customs.
I want to add these costs together, and then distributed to the products or POs i choosed, in order to recalculate the price in the PO itself, and update it in inventory.
I tried to use Landed Cost but i couldn't perform such calculation, I also tried to perform it using Purchase Cost Distribution but when click on Update i got that error:

Integrity Error

The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set

[object with reference: journal_id -]

Can any one help me with this please.

1 Answer
David Tran
Best Answer

Landed cost should help. But remember that your product type must be Stockable and Costing method must be Real Cost for landed cost to work properlly.


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!