Small and medium business | Business Central, N...

How to reverse item related entries?

(7) Share

Report

Posted on by SC666

266

Hi,

My team forgot to set up the item tracking code before all the warehouse activities in BC. They posted the item purchase receipt. When consumption team need to do adjustment in the system they failed because the item received without a lot number. I tried to reverse the posted purchase receipt line. One was reversed. The other once cannot be reversed because it was invoiced. What shall I do now to close all the open entries to enable user change the item tracking code under item card?

How to prevent user forget setting the item tracking code moving forward?

Thanks!

Categories:

Dynamics 365 Business Central migration

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

You can resolve the current issue by posting a negative adjustment for the quantity received without lot numbers and then a positive adjustment with the correct lot numbers, or use the Item Reclassification Journal to assign lot numbers to existing stock; once all old entries are adjusted out, you can change the item tracking code on the Item Card.

To prevent this in the future, make item tracking mandatory on the Item Card, use item templates with predefined tracking codes, enable posting restrictions, and consider workflows or alerts to ensure users cannot post receipts without lot or serial numbers.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,766 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You can’t reverse an invoiced purchase receipt. Instead:

Post negative and positive item journal adjustments to correct stock and add the right lot/serial numbers.

Set the Item Tracking Code on the Item Card to make tracking mandatory before posting.

This fixes current entries and prevents users from missing tracking setup next time.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Change item tracking code

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,152 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

To reverse the item entries you'll need to either create a credit memo for the invoice or use an item journal to do a negative adjustment.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
SC666 266 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The inventory is already zero out but because there is still open entries. The item tracking code cannot be done.

How shall I close all the related entries?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

Close open item ledger entries resulting from fixed application in the item journal

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-how-to-close-open-item-ledger-entries-resulting-from-fixed-application-in-the-item-journal?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

If you get hint from this https://community.dynamics.com/forums/thread/details/?threadid=baf2d9ae-2900-45a8-a287-17cd820e5b87

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You cannot change the Item Tracking Code because historical entries exist. To resolve:

> Post negative adjustments for any remaining quantities and ensure cost is settled.
> If inventory is already zero, you still cannot edit tracking code; either purge historical entries via a custom tool (not standard) or block the item and create a new one with correct tracking.
> To prevent future issues, enforce tracking code on Item Card and use validation or dimension rules before posting.

Best practice: Block old item, create new item with correct tracking, and implement mandatory tracking validation.

Thanks

Rishabh

Was this reply helpful? Yes No