Custom BOM

The Custom BOM form is used to modify the selected item's Bill of Materials for the selected Job only. The custom adds process must be completed prior to any finishing on the Job. Using custom adds is not related to the use of part substitutions, which represent a one-to-one relationship in which one item is replaced by another similar item on the Job's BOM and does not require any adjustment to the BOM ratio/formula. Custom adds, on the other hand, represent a situation in which the ratio of the BOM will be changed and certain parts may be removed completely, new parts added, and existing parts have their quantities modified.

Adding a reworked Finished Good will update the 'New Qty' field to reflect the change in requirements. In this case, clicking the "Issue" button on the Job should show all Part requirements matching what was seen on the Custom Adds form.

Note: The system calculates b2_quant as newqty - reworkqty. This is so that custom adds now save as the difference between the reworked and modified quantity rather than original and modified quantities.

System Navigation

  • Production > Job Entry > "Custom Adds" button
  • Production > Job Reporting > "View Detail" or "Close/Relieve" button on various reports > "Custom Adds" button

Custom BOM form

Button

Description

Add New

If clicked, opens the Edit Custom BOM form, which is used to add a new Part to this Job's BOM.

Modify

If clicked, opens the Edit Custom BOM form, which is used to set a new quantity, scrap percent, and over-issue percent.

Delete

If clicked, deletes the selected line. Users may not delete items from the original BOM, but can delete manually added items.

Save

If clicked, saves the BOM with the values defined in this form.

View Calcs

If clicked, displays the Job User Calculations.

  • If calcs are needed or added after Jobs have been created, then users will need to retro the calc.

Zero All

If clicked, zeros out all quantities listed in the "New Qty" column.

Edit Custom BOM form

Opened via the "Add New" or "Modify" buttons on the Custom BOM form, the Edit Custom BOM form is used to edit individual BOM lines and assign new quantities, scrap percentages, and over-issue percentages.

General tab

Field/Flag

Description

Part Number

Displays the Part Number.

Stock Unit

Displays the Stock Unit as defined on the Part's Item Master.

BOM Unit

Displays the BOM Unit for this line item.

Original Quantity

Displays the original quantity as specified on the BOM.

  • The "Custom Add Unit" via Production > Options (beginning in version 17.04.006) can be used to determine if the quantity in this field will be displayed in Issue Unit/Stock Unit or BOM Unit/Stock Unit. See the Production > Options page for more information.

New Quantity

Used to specify the new quantity of the custom BOM.

  • The "Custom Add Unit" via Production > Options (beginning in version 17.04.006) can be used to determine if the quantity in this field will be displayed in Issue Unit/Stock Unit or BOM Unit/Stock Unit. See the Production > Options page for more information.

Scrap %

Used to specify the scrap percent as defined on the BOM for the line/item.

Over-Issue %

Used to specify the over-issue percent as defined on the BOM for the line/item.

Source

Text field, up to 30 characters, used to indicate from where the BOM line originated.

  • "Original" indicates the line is from the BOM used during Job creation.
  • "Container Inclusion" indicates this line was added as a result of the "Auto Issue Container Contents" flag being checked in Production > Options. This flag is used in connection with the Containers feature in DEACOM.
  • Defaults to "Manual" to indicate this line was not from the original BOM.
  • Useful for recording the purpose of changes in the Custom BOM form and should be populated with pertinent information.

Standard Cost

Displays the standard cost for the Part as defined in the "Acct. Standard Cost" field in the Item Master Costs tab.

Extended Cost

Displays the extended cost for the line as calculated by the New Quantity * Standard Cost.

Notes

Memo field used to store notes for the custom BOM line. This field (b2_notes) may be added to the Custom Adds grid.

  • The notes in this field may also be added to the grid on the Issue form to help alert users to any specific details related to the issuing of custom BOM requirements.

Non-Proportional

If checked, custom adds will not be proportional to how much material has been finished.

  • If not checked, DEACOM will proportion the amount to issue to the Job by the remaining quantity on the Job.
  • Useful in situations where customers want to have a stand alone quantity added/issued to the Job.

By-Product

If checked, indicates this BOM line is a By-Product. Refer to Handling Co-Products and By-Products for more information.

  • Only available when a negative value is specified in the "New Quantity" field.
  • Quantity scaling will adhere to the rules outlined for the "Non-Proportional" flag.

Propagate User Lot

If checked, the user lot number from the item added via the Custom Add form will carry over to the finished good when finishing production.

  • Works in conjunction with the CHILDLOT function, which is available to the "Lot # Expression" field in Inventory Options.
  • Additional details and examples regarding this option are included in the "Lot # Expression" field explanation on the Inventory Options page.
  • Simply checking this flag will not propagate the item user lot number to the finished good user lot number. For the process to work, the CHILDLOT() function must be used in the "Lot # Expression" field.
  • This flag is also available on the Edit BOM Line form via Bills of Material. If the flag is checked on the Edit BOM Line form it provides the default for this flag. Note that the flag here, on the Edit Custom BOM form, takes precedence over the one on the Edit BOM Line form. Example: If the flag is checked on the Edit BOM Line form but not on this form, the user lot will not be propagated.

Sequential

If checked, tells the system that items are to be issued and staged to Jobs in the order they are sequenced on the Custom BOM Revision.

  • If users attempt to issue to a BOM line that is flagged as Sequential without first issuing to any BOM lines before this one, the system will display a prompt indicating the previous part needs to be issued/staged first.

Production Relief tab

Tab available beginning in version 17.04.001.

Note: These fields also exist on the regular Edit BOM Line form.

  • When an existing line on the custom BOM is modified, the system will default the related Issue Inc Type and Issue Increment/Increment Expression field values from the regular Edit BOM Line form. The user may modified these if desired.
  • When a new line is added to the custom BOM, these fields will default to an Issue Inc Type of "Fixed' and Issue Increment of "0". The user will need to manually set these values if desired.
  • When using the issue increment logic the system will check to see if a Custom BOM line exists and, if so, will use the increment settings from the Custom BOM line. If no Custom BOM line exists, the system will use the regular BOM line increment settings.

Field

Description

Issue Inc Type

Option to determine how issue increments will be determined for the selected custom BOM line item when issuing to a job in main app or WMS. Options are:

  • Fixed (Default) - user will need to indicate the increment in the "Issue Increment" field below.
  • Expression - user will enter an expression in the "Increment Expression" field below. This option provides more flexibility and the option to have the issue increment based on variable factors, for example which Work Center is used, instead of a hardcoded value.

Issue Increment/Increment Expression

Option to set incremental issuing for this custom BOM item. Field name displays as "Issue Increment" when selecting an "Issue Inc Type" of "Fixed" and "Increment Expression" when selecting an "Issue Inc Type" of "Expression".

  • If using a issue type of "Fixed":
    • If the increment is non-zero, the system will replace the quantity in the "To Issue" with this increment when issuing to Jobs in the Main and WMS applications.
    • All custom BOM lines with a zero issue increment will be issued as before. Users will issue the full required amount.
    • When issuing, users will enter the appropriate increment for those lines. Users may need to issue multiple increments to meet the full job requirements.
    • When returning to the Issue form, only those lines with outstanding issuing increments will remain.
    • Users have the option to set incremental final staging based on the "Job Staging Counts" value in System > Options, which works with the Incremental Issuing feature described above. As an example:
      • Assume a BOM contains Raw1/Raw2/Raw3 all set at 1 per for 1 finished good, each with an issuing increment of 100 and a Job is created for 300 finished good.
      • If "Job Staging Counts" is set to "3", the first time through the system will final stage 100 Raw1, 100 Raw2, then 100 Raw3 for iteration 1.
      • The system will present 100 each of Raw1/Raw2/Raw3 for the 2nd and 3rd iteration of final staging.
      • At the conclusion of the third iteration, all the inventory will be issued.
      • If the "Job Staging Counts" is set to "1", the system will not allow the user to final stage more than the increment + overissue % until a Job finish complete.
  • If using a issue type of "Expression":
    • The following fields/variables are available to the issue increment expression: BOM fields (dmbom), BOM revisions (dmrev), Job fields (dtjob), Job (dtjob) User Fields, Job User Calculations, Job line fields (dtljob), Job line (dtljob) User Fields, (item master(dmprod) fields, item master User Fields, BOM line User Fields, Transaction, Issue, and Final Stage.
    • The following named variables (which are also available in BOM User Calculations) are available to the expression: bocount, dispcnt, totwgt, totvol, totcub, exten, futext, wgtcost, volcost, wgtper, volper.
    • The issue increment quantity from the expression will match the Quantity Decimals defined in Sales > Options.
    • If the expression is invalid, the following prompt will be displayed: "Invalid issue increment expression".
Allowed Lots

Only enabled for items that require a lot on relief. Allows the user to specify which lots are selectable, with commas separating all applicable ones. These allowed lots will be taken sequentially.