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

Return of material purchase at 0 cost

(3) Share

Report

Posted on by CU07021921-0

Good afternoon everyone,

I have a case in which I need your advice. It's a bit quirky and requires advanced knowledge of Business Central.

In my company we accept a certain amount of supplier shrink since we have no alternative. Once the raw material has been verified, we count the Ok units and we write off the rest through stock regularization in the “product journal”.

The question is: Is there a “cleaner” way to get this NOT OK amount out of the system? I have tried making a purchase return valuing the product at 0 cost, but the system does not allow it.

Thank you very much, and a hug to all!

Greetings

Jose Rodriguez

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mustafa Omerbegović 1,477 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello Jose,

I doubt there is standard functionality for this case, but you could try Item Journal.

You can make a negative adjustment and link the line with the appropriate application entry no. from the Item ledger entry to reduce the quantity of these items.

I am sure that you can post an item journal at 0 cost, but you will need to analyze your cost for the remaining items since there should be posting of adjustments after posting negative adj at 0 cost.

If you have more questions feel free to ask.

Greetings

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

If this helps: https://learn.microsoft.com/en-us/dynamics365/business-central/purchasing-how-process-purchase-returns-cancellations

https://community.dynamics.com/forums/thread/details/?threadid=4fb07523-e247-ee11-be6d-000d3a55b688

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

The easiest and most common method is to do a negative adjustment in the Item Journal. When doing this, leave the item cost field as is, don't change it to zero, because the item was originally purchased at a cost. Since you are removing it from inventory, its associated cost must also be removed for.

When you post a negative adjustment, the system will credit your inventory account on the balance sheet and debit the inventory adjustment account on the income statement. If you need this entry to affect a different G/L account on the income statement, you can use 'Option 3' in the following article. Recording Inventory Usage for Marketing, R&D, and Other Internal Needs in Business Central - Dynamics 365 Business Central Insights

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
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

How about using Assembly Order?
When you buy from the vendor, it is an item (not verified). After confirmation, use Assembly Order to convert it to an item (verified).
The consumption quantity and the final completion quantity can be modified on the order.

This can also trace history.

PS: Dynamics 365 Business Central: Assembly Management (Kitting) without the need of manufacturing functionality

https://yzhums.com/4491/

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No