Finance | Project Operations, Human Resources, ...

Inventory counting journal

(0) Share

Report

Posted on by Michael agostini

When I do an inventory counting journal I find that if I increase the quantity I do not see a Financial Voucher against the transaction when I go to the item and look at transaction details.

But when I do a reduction on the counting journal I do see the Financial voucher.

I know when I do an adjusting journal when you increase the value you need to add a cost apposed to when you do a decrease adjustment the cost is defaulted.

Any ideas on this behavior for the counting journal.

Thanks Mike A,

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

P.k.Kaushik 1,031 on at

Like (0)

Report

Hello,

When we do a counting journal with "-ve" quantity the cost price is posted as per the cost price mentioned in On-hand screen.

When we do a counting journal "+ve" quantity we will have the ability to specify the cost price before posting.

We will not have the ability to mention cost price when the quantity is -ve.

Thanks, Kaushik

This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.

P.S:- Please mark the answer as verified if it helps you in resolving the issue.

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

Kaushik, thank you for your response.

I know what the cost price is.

I have tested this multiple times and what you are saying is not the out of the box behavior of D365 to my understanding.

I am asking if someone can confirm this.

Thanks Mike A

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Mike A,

Is it possible that the voucher is still pending and not transferred to GL? Have you checked that?

Also, can you confirm that you use the same voucher in the counting journal and in the adjustment journal?

What D365FO version do you operate?

Best regards,

Ludwig

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

Hi Ludwig,

I can confirm the counting journal was posted. I am assuming once posted it will hit the GL.

I am using a different voucher for counting vs adjustment.

We are on the latest D3656.

The issue as mentioned is when I do a decrease counting or adjustment journal the value is populated with the cost price from the item. When I do an increase I need to populate a cost price or the journal ends up being for zero value.

One of my colleagues suggested I enable this setting to resolve the issue. I was going to test it.

Thoughts...

Mike A

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Mike A,

I see.

The latest cost price might help if you have one.

Otherwise, you might run an inventory recalculation. Running this process should fix the issue.

By the way, why don't you have a cost price setup for your items?

Best regards,

Ludwig

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

Ludwig,

Thanks for getting back to me.

We are not using cost price right now as we have developed numerous mods.

What I am trying to determine here is why when we do a counting or adjustment journal we get no values the financial voucher. I believe this is the D365 out of the box behavior and it can be changed by:

1) Populate the cost price on the journal for Increase adjustments

2) Turn on the price update on the item master.

But I have not been able to get it to wok for point 2.

Thanks Mike A

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

To get the latest cost price populated you might need a cost transaction for example from a purchase. There is an additional parameter related to this in the purchase section which relates to the latest purchase price. Can you activate this parameter as well, then post a PO, invoice update it and then do a new counting journal.

Best regards,

Ludwig

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

I know those features. I can try.

Thanks Mike A

Was this reply helpful? Yes No