Cost update item from landed cost

(0) Share

Report

Posted on by godoprod

I am looking for a way to allocate landed cost (typically freight, customs, administrations fee) directly to items to update the item cost prize. I have not found a way to do this in AX 2012.

This is the scenario:

The company creates a purchase order for the items, and posts the related invoice from the vendor when it arrives. There might however be some other costs related to the item. For example a freight cost that is invoiced from another vendor that arrives later. The company then wants to post the freight costs in a way that the cost updates the item cost originally posted in the purchase order.

Is there some way of doing this without 3.rd party modules?

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Weaveriski 23,620 Moderator on at

Like (0)

Report

As standard you can attach miscellaneous charges to the purchase order and process purchase invoice for the service directly as an invoice. Only issue is if the expected does not match the invoice (and that they are technically disconnected but it updates your item cost with any misc cost).

Was this reply helpful? Yes No
godoprod 35 on at

Like (0)

Report

Thank you for the reply Weaveriski, but I don't think this solution will solve my problem, since what I need is for multiple invoices from different vendors to be added to the item prize AFTER the purchase order is settled from the original invoice.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

Yes that is no problem in standard AX. What I would suggest is you go to the procurement parameters, updates tab and set the "safety level of invoiced orders" to "Warning" from "locked".

Was this reply helpful? Yes No
godoprod 35 on at

Like (0)

Report

I'm sorry, but I don't get the whole process flow. Could you please describe how I can link all these invoices to a purchase order to update the actual item cost?

I've checked the parameter, and changed it to "Warning".

Thank you!

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

You need to add a miscellaneous charge that is unrelated to the service. The misc charge must be configured to update inventory and post to an expense, the service item on the invoice should hit creditors and the other side to the same expense. The invoice is NOT linked to the charge in anyway, but you are reflecting the cost of the invoice into the inventory of the item.

Was this reply helpful? Yes No
godoprod 35 on at

Like (0)

Report

But if you are going this way, then you have to know the exact amount of the charge.?

So the process will then be to add charges to the invoice journal when the extra invoice arrives. But the charges will not update the item prize until the period closing is run?

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

No not really, you can add expected charges and update later. The inventory calculation would need to be rerun I believe to push the cost through to inventory but it has been a long time since I looked at it. This depends then whether you put an estimate on or nothing but post actual at arrival of the invoice.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You can also have a look at the functionalities of the new Transportation features in AX 2012 R3.

In all other versions without add-ons it is like Weaveriski mentions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

When the landed cost have a standard pattern, You can also consider to use the costsheet in combination with standard costprice and define surcharges to the cost of purchases.

In the standard costprice you make a reservation for the different types of landed costs and lead them to a special mainaccount. The actuals you can post to different mainaccounts and compare later the actuals against the standard costprice reservation.

When you see that some landed costs are structural different, you can change the surcharge, and recalculate the standard costprice.

Kind Regards,

Ube Murre

Was this reply helpful? Yes No
Corey Warawa on at

Like (0)

Report
The only way I see this can be handled is as follows:

Create and invoice PO to vendor (include an estimate of the charges)

When the 3rd party invoice arrives, go to the Invoice Journal that was created on the PO and select Charges > Adjustment

You now have the ability to adjust the charges that were, initially, estimated on the PO with the actual charges that came via the 3rd party invoice. The new charges will carry to the landed cost of the inventory.

Regards,

Corey

Was this reply helpful? Yes No