...
Add Inventory items to the Job Sheet.
...
The job sheet has a few requirements for the bill of materials to work.
Macro
We have written a macro to include in the job sheet; if your current job sheet does not include this, you may want to download the template below and copy it to your job sheet.
...
Components Tab
You will also need a Components Tab. The tab MUST be named Components for the software to recognise the inventory list.
If your templates do not include a components sheet, you will need to add one; select the + icon at the bottom of the page to add a new Tab and rename it Components; it must contain this name so that the program recognises the tab.
Named Field
There will need to be a named field that encompasses all the data in the Componenets sheet, and this will need to be named ComponentsRange
...
For more information about the Name Manager, https://exceljet.net/glossary/name-manager#:~:text=To%20open%20the%20Name%20Manager,the%20keyboard%20shortcut%20Control%20%2B%20F3.
You can find all these requirements in the Template below
Job Sheet Templates - Download a template here.
Explaining the layout
| View file | ||
|---|---|---|
|
•Row 1 consists of the inventory codes (these can be exported from BUZ then Copy and Paste with Transpose)
...