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

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Jens Glathe 6,092 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Agusti Carceller on at

Like (0)

Report
Copy link

Link copied!

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í

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Configuration Package allowed me to quickly modify the BOM Lines.

Was this reply helpful? Yes No
Tharanga Chandrasekara 23,118 on at

Like (0)

Report
Copy link

Link copied!

Glad it help you.

Was this reply helpful? Yes No