Inventory configuration AX2009

(0) Share

Report

Posted on by Community Member

Hi.

I need guidance in how to configure the Inventory.

We have the issue that we receive items to our stock and starts to sell them before the PO has arrived. As our setting is right now we don't have any cost of the items in our bookkeeping, only revenue.

What are the possibilities to, when updating the Delivery note, get a "preliminary cost" of the items to our books and when the PO arrives adjust this "preliminary cost" with the actual cost

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

Verified answer

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Daniel,

Can you elaborate? Does start selling also mean you deliver and invoice the goods prior to the product receipt? Depending on the inventory costing model you can have a Standard cost or you can use other models and the cost will be recalculated periodically with the Inventory closing job.

You can read more about the costing and recalculation in the next whitepaper: www.microsoft.com/.../details.aspx

Was this reply helpful? Yes No
Suggested answer

Prashant Singh 8,802 on at

Like (0)

Report

Dear Daniel,

You can receive the item and sell it but you need to update the cost of the item through closing and adjustment. It will update your COGS as well.

Inventory Management --> Periodic --> Closing and Adjustment

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Daniel,

If I understand right, you are receiving items on Purchase orders, and selling them before the PO Invoice arrives? Are you posting the PO Packing Slip before you sell them, or are you using the 'Registered' status?

Can you tell us the following settings on the Inventory Model Group(s) you use for these items?

Post physical inventory (tick box)

Inventory model

Include physical value (tick box)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André.

Thanks for the whitepaper. This will be very helpful. I will maybe come back with some additional questions.

Regards

Daniel

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Prashant.

Thanks for your respond. Is this the journal to use? I have also tested to use the Physical posting journal.

Thanks

Daniel

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Guy.

Post physical inventory is selected but not Include physical value. Shouls that one be selected?

Thanks

Daniel

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Daniel,

It depends on the Inventory model (you didn't say which you use), but if you have 'Include physical value' ticked, AX can use the price from the Purchase order in its calculation of the value of On-hand inventory (but only after the PO Packing slip is posted).

I would only not tick it if I didn't want my PO prices to be used (e.g. if they were wildly inaccurate compared to the price on the PO Invoice).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi.

Sorry, we use FIFO.

The first step I would like to achieve is to have a financial posting when posting the PO packing slip. Can you guide me to these settings?

Thanks for taking your time.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

You have 'Post physical inventory' ticked. That is half the solution! Also check Accounts payable -> Setup -> Parameters -> 'Update' tab -> 'Post packing slip in ledger' tick box.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Should then my General Ledger be updated with the corresponding booking?

Was this reply helpful? Yes No