Incorrect item Quantity per in BOMs

(0) Share

Report

Posted on by Community Member

Hello,

I am using NAV 2013. Here is the question detail.

One item is used in many Assembly BOMs, but its Quantity per in each BOMs is not correct, for example: 0.01812, 0.02254, 0.00112, etc.

We want to change these numbers to 1. We can make the change in BOM.

Is there any quick shortcut or other method to update in all BOMs?

*This post is locked for comments

All responses (7)

Answers (1)

Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: Incorrect item Quantity per in BOMs

Glad it help you.
Community Member on at

Like (0)

Report

RE: Incorrect item Quantity per in BOMs

Configuration Package allowed me to quickly modify the BOM Lines.
Community Member on at

Like (0)

Report

RE: Incorrect item Quantity per in BOMs

I used Configuration Package to export BOM Component Table, and updated those fields, and then imported the table.
Verified answer

Tharanga Chandrasekara 23,116 on at

Like (1)

Report

RE: Incorrect item Quantity per in BOMs

Export the table to Excel using Rapidstart and then do all the necessary changes to your BOMs and then upload it back. It will sort your issue and you do not require to modify or create any new reports to update quantity per field.

Refer below link on how to use Rapidstart.

msdn.microsoft.com/.../hh997614(v=nav.90).aspx

msdn.microsoft.com/.../hh997463(v=nav.90).aspx
Agusti Carceller on at

Like (0)

Report

RE: Incorrect item Quantity per in BOMs

Hi,

You must validate field, not assign "quantity per" field.

When you validate fields, "onvalidate" trigger fires code and field "quantity" is correctly updated.

ProductionBOMLine.RESET;

ProductionBOMLine.SETRANGE(ProductionBOMLine."No.", XXXXXX);

IF ProductionBOMLine.FINDSET THEN

REPEAT

ProductionBOMLine.validate("Quantity Per",1);

ProductionBOMLine.MODIFY;

UNTIL ProductionBOMLine.NEXT = 0

Regads

Agustí
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (1)

Report
RE: Incorrect item Quantity per in BOMs

Hi Allen,

This will be a customization. Let me write the code vaguely, but please find a developer to properly code it.

Since you are using the Production BOM Line table (Table 99000772), I would design my code as the following.

ProductionBOMLine.RESET; ProductionBOMLine.SETRANGE(ProductionBOMLine."No.", XXXXXX); IF ProductionBOMLine.FINDSET THEN BEGIN REPEAT ProductionBOMLine."Quantity Per" = 1; ProductionBOMLine.MODIFY; UNTIL ProductionBOMLine.NEXT = 0 END;

Please note that XXXXXX is the item which you are going to change the "Quantity Per" value and ProductionBOMLine is a record variable to the table 99000772.

Please let us know if it works for you.
Suggested answer

Jens Glathe 6,092 on at

Like (2)

Report

RE: Incorrect item Quantity per in BOMs

Hi Allen,

shortcut: no. As a programmer, I would create a batch report that updates all Assembly BOM lines with this item to 1, probably with validate. Do you have more than one item with this issue? Sounds like somebody has changed the base unit of measure...

with best regards

Jens