Change in Inventory on Product Receipt

(0) Share

Report

Posted on by Apix

307

Hi Everybody,

I can't figure out how to sep up an accounting entries when i receipt my purchase order. Actually, I have an entries for my purchase :

Cost of purchased materials received

Accrued sales tax on receipt

Purchase, accrual

But i also need an accounting entrie for my change in inventory.

Thanks you for helping me !

Regards,

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

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

Like (1)

Report

Hi Piccin,

You have to check the next options:

- Is your inventory model set to post financial transactions in the ledger?

- Has the item a cost price?

- Are the transactions pending in the form General ledger > Inquiries > Subledger journal entries not yet transferred?

If it is in the subledger inquiry form, the batch job for transferring is not running.

Was this reply helpful? Yes No
Apix 307 on at

Like (0)

Report

Hi André,

Thank you for your quick reply. I checked these points and everything is ok.

Actually you can see below my accounting entries :

Cost of purchases materials received + Accrued Sales tax on receipt = Purchase, accrual.

These entries are ok, but i'm wondering if there is way to add some with the inventory change.

Kind regards,

Aymeric.

Was this reply helpful? Yes No
Grzegorz Skrzypczyk 225 on at

Like (1)

Report

Have you tried looking at your inventory summary account and verifying that there is in fact no entry? I recall AX posts the event you are referring to using two vouchers.

Was this reply helpful? Yes No
Apix 307 on at

Like (0)

Report

Hi Grzegorz,

Thank you for your reply but Microsoft updated the system with Dynamics AX 2012 R3 to avoid it.

[View:https://www.microsoft.com/en-us/download/details.aspx?id=28019:750:50]

[View:https://blogs.msdn.microsoft.com/axsupport/2014/08/04/ax-content-accounting-for-stocked-items-on-product-receipts-and-vendor-invoices/:750:50]

Regards,

AP

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

Like (0)

Report

Hi Piccin,

I don't think I'm on the same page now. Can you elaborate what you mean with an inventory change?

Was this reply helpful? Yes No
Suggested answer

Apix 307 on at

Like (0)

Report

Hello André,

I tried to explain it through a model.

Do you see what I mean by my inventory change now?

Regards,

Aymeric.

Was this reply helpful? Yes No
Daxer Persson 3,005 on at

Like (0)

Report

Why do you want two more lines?

The Cost of goods received represent you inventory increase and purchase, accrual your liability to the vendor (invoice soon to come).

Both of these two types are offset by Purchase expenditure, un-invoiced. But if this value is zero (and same currency) then transactions here.

MS has changed this functionality nunber of times during last years after going for the "two voucher framework". But to me it should be ok with just two entries (if your main account posted upon are correct).

NB: For returns to vendor you may see posting on purchase expenditure, uninvoiced.

Was this reply helpful? Yes No
Apix 307 on at

Like (0)

Report

Hi Daxer,

It's a customer request, no more. My first entries record the accrual account and the cost of goods. But if I want to record the change in my inventory I need to create two more entries. Usually this kind of entries appears at the period's end and the inventory change is the difference between the inventory at the beginning of my period and the end. Here i need to set those entries at my product receipt.

Thank for your reply,

Kind regards,

Aymeric.

Was this reply helpful? Yes No
Apix 307 on at

Like (0)

Report

Hi André,

Eventually I need to have accounting entries to record the receipt of my item in my stock. When i generate my product receipt I have those entries :

Cost of purchased materials received : Debit

Purchase expenditure, un-invoiced : Credit

Purchase expenditure, un-invoiced : Debit

Purchase, accrual : Debit

And when i generate my invoice :

Sales tax Debit

Vendor balance Credit

Purchase expenditure for product Debit

Purchase expenditure for product Credit

Cost of purchased materials received Credit

Purchase expenditure, un-invoiced Debit

Purchase expenditure, un-invoiced Credit

Cost of purchased materials invoiced Debit

Purchase, accrual Debit

I need to set up accounting entries, either on my product receipt or invoice , to record the value of my stock following the receipt of my purchase order.

Thank for you help ;)

Aymeric

Was this reply helpful? Yes No
Verified answer

Daxer Persson 3,005 on at

Like (0)

Report

do you have cost of goods during product receipt? Is it possibly some French requirement? Normally one would "just" make product receipt to balance through cost of materials received and purchase accrual for liabibility.

Possibly look into using purchase posting types Charge and Stock variation (these are created for some French functionality):

community.dynamics.com/.../kb3023131-accounting-for-purchase-charge-and-stock-variation

Was this reply helpful? Yes No