Inventory Concern issue.

(0) Share

Report

Posted on by Beginner Dynamics 3...

Hello Dynamics Community.

I have a stock concern issue.

I checked the general balance of my shop stock at 30 June 2022, it was 2437236.68.

Now, during inventory valuation on 30 June 2022 itself, it is now 2435167.02.

That is, I'm getting a difference of 2069.66.

Will be grateful if someone can explain to me why such huge difference has occurred?

Thanks to let me know.

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (1)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

The first thing i would check is your routine for cost adjustment.

Do you run automatic cost adjustment or do you run it manually?

And was the cost adjustment processed between your first report and your second report?
Beginner Dynamics 3... 95 on at

Like (0)

Report
Copy link

Link copied!

Hello Mr Inge

Yes, the cost adjustment is automatic. It is setup as always.

Why such difference has occurred?

Grateful to let me know your opinion.
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Beginner Dynamics 365 Business Central ,

There can be several reasons for that. So it is really hard to be certain about this without looking into your data.

But Kim Dallefeld have published an excellent series of blog articles that you can use for reconciling your inventory against your General ledger. You will find that here: kimdandnavbc.com/.../ and you should go through that to see if that can help you identify the differences.
Verified answer

YUN ZHU 103,227 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, I don't know what your Costing Method is. For example, if your Costing Method is average cost, and the purchase amount is different, the cost amount will be changed. And I'm guessing that this may be caused by you posting into the June period after June 30th.

Some details about Cost:

https://docs.microsoft.com/en-us/dynamics365/business-central/design-details-costing-methods

https://docs.microsoft.com/en-us/dynamics365/business-central/design-details-cost-adjustment

Hope this helps.

Thanks.

ZHU
Suggested answer

Dallefeld 235 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

You could have invoiced a purchase(s) that was only received and not invoiced. You can keep from happening by managing your general ledger setup's allow posting from and to dates. I recommend changing your dates at the end of the last day of the month or very beginning of the first day of the month. With expected cost there is no reason to leave these dates open. For accounting users, yes they need a wider range of dates but adjust cost uses the general ledger posting date range.