Hello,

We are on Sage X3 2019 R4 (12.0.19).

We are importing raw materials and when the stocks are arrived, we need to issue those into production as we are in a tight planning schedule. Received materials will be issued to production with the average cost at that time.

Once the additional invoices such as shipping line charges, custom tax duties, clearing agent handling charges are available (probably after one or two weeks) we create them as additional invoices to the main supplier invoice. These additional costs cannot be predefined to exact amount.

At that time per unit cost gets changed to a higher/lower amount.

As we already issued those materials into production, there is a variance (under/over value) cost which we believe should be absorbed by cost of production account.

Sample scenario:

PO - net unit price                                : $ 10

With landed cost stock unit cost           : $ 12 (Landed cost coefficient = 1.2)

Purchase receipting                             : 10000 units

Stock unit cost                                     : $ 12

Qty issued to production                      : 2000 units (by material tracking)

With actual landing cost stock unit cost : $ 15 (with additional costs)

Variance cost of the issued material     : 2000 * $(15-12) = $ 6000

We need the above variance to be absorbed by our cost of production account.

Hope someone can help us on this.