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

Deleting Item Variant Code

(0) Share

Report

Posted on by ERPMan

Hi BC Guru's,

We would like to remove item variant code from item ledger entries as we do not use it the way it was intended, and it is creating issues for us in closing inventory periods.

If we were to remove the variant code from populating in the item ledger entries would this create any issues?

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Dallefeld 235 User Group Leader on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, item variant is used in many ways, it's used in pricing, inventory counts, even descriptions on documents. My suggestion is to quit using item variants if you are using it as it was NOT intended and find another field to utilize.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,540 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, If you just want to remove from item ledger entries, it is not difficult, but there are actually many tables associated in the background, such as Value Entries, Posted Sales Invoice Lines, etc.

And if you set Item & Location & Variant in the Average cost calc. type, this will also affect the cost calculation.

I think it is better not to modify the historical data. You can choose to block the old item and create a new one. At least this doesn't break the consistency of the system data.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
ERPMan 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there any way to make it so variant code items are considered the same quantity as the main item?

We are having issues closing inventory periods due to variants being considered as a separate item with different quantity. If we could have them counted altogether it would relief the issue.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Just run the Test report first, from the Inventory Period page, see how many items it showing with error, like if they are open entries, close those entries first with Apply to field's value on Item journal with the same quantity in the Item Ledger entry do this for each item shown in Test report.

It will make close of all Item ledger entries, and moving forward stop using the variant code. also if you dont want to see that Variant code field just hide it doing some development, removing data is not recommended.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 235 User Group Leader on at

Like
a
(0)

Report
Copy link

Link copied!

The entire purpose of Variants is to be treated like different items without having to setup different items.

Was this reply helpful? Yes No
Suggested answer

Amit 2,563 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Yes it is used in calculating the valuation of the Item.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No