Stock Open Balances - Goods received but not yet invoiced

(1) Share

Report

Posted on by CF-22040757-0

Hi all,

What is the best approach to deal with open documents to import on Opening balances, where the goods are received and but not yet invoiced.

How should i bring the Invoice to BC?

and how it would affect the cost of the items?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

As far as I know, you should import to Sales Order (Sales header and Sales line table), then post receive in BC, (not post invoice). And because no invoice was posted, these costs are expected.

It is recommended that you test it in the Sandbox environment.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

CF-22040757-0 75 on at

Like (0)

Report
Hi Yun,

I can not do that, because the stock is going to be imported using Item Journals. So the value will be already in the Inventory Account.
But at the same time i will have also value in the "Accrual Account".
I could do an Invoice in BC clearing the value of the accrual account (reverse the receipt), but then it would be very messy, if the price of the Item has changed (would need to do a item revaluation).

The best solution that i can see is:

Posting the Invoice and make a Credit Memo in the Old System. (this way we would not have stock received and not invoiced)

Then post the purchase Order with the stock received (to recover the expected costs), and when invoice arrives then post the invoice in BC. (or post directly the Invoice)

Thanks.

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (0)

Report

You have 2 options:
1) Import item journal with quantities, then when You know the values, do a Revaluation Journal entries to add value to all the quantities in inventory (could be done also as Purchase Invoice from specific Vendor and add line as Item Charge and assign this charge to the Item - but this could be posted in wrong G/L account so test the setup/Preview Posting )

2) create a Purchase Order, do a receiving of items then You can add the cost and post the invoice. This only allows to create invoice for one vendor, so if You have them from several Vendors, You will need to create several Purchase Orders.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Yes, it's best if you can adjust in the old system.

Thanks

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

Stock Open Balances - Goods received but not yet invoiced

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Stock Open Balances - Goods received but not yet invoiced

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates