Products
- Products
- Overview
- Create new product
- Update existing products
- Delete products
- How SKUs are generated
- Bulk replace material
- Product safety stock
- Product suppliers
- Bill of materials (BOM)
- BOM presence
- Product lines
- Projects
- Serial numbers
- Overview
- Create new serials
- Update existing serials
- Delete serials
- Extend serial's warranty
- Troubleshooting: duplicated serials
- Fixed assets
- Licenses
- Overview
- Create new license
- Update existing license
- Delete license
- Restore license
- Downgrade license
- AGV robots
Products
Overview
Products are used in the ERP to represent objects, that are used in the work processes, ranging from materials, tools, office supplies, work equipment to finished and semi-finished products. They are used throughout most work processes, including purchasing and selling processes.
Every product is, when created, assigned a unique SKU (Stock Keeping Unit) number, that will be used to refer to this product within the system. All SKUs are required to be unique, duplicates are not supported.
Create new product
To create a new product, click the "Create new" button in the top right corner of the page and you will be redirected to the "Add new product" form.
Here, we can create a new product.
Update existing products
When it comes to updating product's properties, there are specifics regarding certain properties.
The SKU
Every product has its own unique SKU, which must remain unchanged, to avoid unintentional duplicates.
Product's SKU should not be updated, if at all avoidable.
The short name
A product has a full and an abbreviated version of its name. The short version of the name should not be updated, as it version it is written on many documents, including invoices. Short name should remain unchanged to avoid any discrepancies.
Product's short name should not be updated, if issued invoices exist for that product.
Delete products
Deleting products is not advisable, as they are referenced in many places in the ERP system.
Only products, created recently (eg. a month ago) should be considered for deletion. Old products that are not sold any longer, should be marked as deprecated instead.
To delete a product, go and find it in the table. Then check it's checkbox and press the "trash" button. A confirmation dialog will appear, and once confirmed, the product will be deleted. You can check and delete multiple rows at once.
How SKUs are generated
Every product can have only one SKU and every SKU has to be unique. Duplicate SKU-s are not supported.
Example: MME.0038447.11B
In this example, the prefix MME stands for Materials, Metal (M - Materials, ME - Metal), the number 0038447 means, that this is the 38447th MME product and the suffix 11B means that the product revision is 11B.
Bulk replace material
Products can be replaced in bulk across product BOMs or in work order item BOMs.
To bulk-replace a product, open its details page and find the "Bulk replace products / work orders bom" section.
Open it and follow the steps in it.
1. Select material
Select the product, that will replace the current product in BOMs, and set its quantity. There can be from one to several products selected to replace the current product.
2. Select path
Here you have to select which type of BOMs you will be updating (replacing the product in):
- Update product BOM: the product will be replaced in BOMs of selected products.
- Update work order BOM: the product will be replaced in BOMs of selected work orders.
3. Select products (BOM)
If the selected path was "Update product BOM", the next step is to select the products, whose BOMs will be updated.
4. Select work orders (BOM)
If the selected path was "Update work order BOM", the next step is to select work order(s), where work order item BOMs will be updated.
5. Summary
If we are updating the product BOM, the summary will list the products that will be updated. Clicking the "Remove material" button and confirming will perform the replacement/removal of material on selected products.
If we are updating a work order's BOM, the summary will list the products that will be updated.
Clicking the "Replace material" button will replace material on BOMs of selected work order's items.
Clicking the "Add material" button will add material on BOMs of selected work order's items.
Product safety stock
wip
Product suppliers
wip
Bill of materials (BOM)
wip
BOM presence
wip
Product lines
Overview
Product lines are used to group similar products into merchandise groups. Product lines provide default warehouse location, maximum and minimum required stock for all products, added to that particular product line.
Create new product line
To add a new product line, press the "Add new" button to get redirected to the "Add product line" form.
To create a new product line, all that is required is a unique product line name.
When adding a product into the product line, a default location for that product is required.
Update existing product line
Delete product line
Projects
Overview
Create new project
Update existing project
Delete project
Serial numbers
Overview
Serials are used within the ERP for tracking of devices.
Serial number is a sort of identification number of a particular device.
With the serial number, users can access calibration reports for a particular device. Serial numbers can also be used to track a particular product's stock transactions.
Serials are usually connected to a product and/or to a license.
Create new serials
This actions required the "create serial" permissions.
Adding a new serial through the ERP is usually not necessary, as new TBD serials are automaticaly generated for work orders and can simply be renamed.
Serials can be added via the ERP "Add new serial number" form.
When adding a new serial number into the system, only its serial number value is required.
When adding a new serial number, keep in mind that the system does not limit the adding of multiple serials with the same serial number. There can, however, not be more than a single serial with a particular serial number and a particular product type.
Update existing serials
Delete serials
This action requires the "delete serial" permission.
Serials should, in most cases, not be deleted. The only exceptions are duplicates of existing serials. This happens when serials are create through different sources without all information.
When this happens, both serials should be checked and their data synced (warranty, calibration intervals, file manager contents...)
After syncing all serial data, the serial with existing stock transactions should be retained, while the duplicate can be deleted.
Extend serial's warranty
By default, warranty is calculated automatically, based on fields on serials:
Conditions, that apply are (warranty enabled):
- if serial is not sold (this is necessary to show correct data in calibrator)
- if sold serials do not need calibrations (image below)
- if sold serials need calibration and are calibrated (last calibration is before current date and next calibration is after)
- if warranty is valid until the warranty due on serial number. This is generated from sales date to calculated date from product setting warranty duration in months (image below)
Warranty will turn off, when warranty due date passes or calibration was not done within N months from next calibration date (the N can be setup in ERP settings).
You can turn on warranty with warranty switch on serial's page. Be aware of automation explained in section below:
Warranty will turn off every night, if settings are not correctly set up (e.g. warranty due or next calibration is missing based on conditions above)
Calibration interval can be changed, if calibration is necessary more or less often. Zero mean 12 months.
Troubleshooting: duplicated serials
Occasionally, two serials with the same serial number are created in the ERP.
When this happens, the two serials must be compared. If one serial has some fields filled that the other does not, those fields have to be synced between the two serials.
Once all the information, present on the serials, is added on both serials, the "stock transactions" section has to be checked on both serials.
After all information has been synced, files in file manager should also be synced between the two serials, as files such as calibration reports, can pertain to either of the serials.
If, on inspection, one of the serials has stock transactions while the other does not, then the one without stock transactions can be deleted.
Fixed assets
Overview
Create new fixed asset
Update existing fixed asset
Delete fixed asset
This action can be performed by users with proper permissions.
A fixed asset can be deleted from the ""Fixed assets"" table view.
Find the fixed asset that you want to delete by searching for its inventory number in the table.
Once you have found the fixed asset, tick its checkbox, and click & confirm the "Trash" button that appears in the top right corner. With the fixed asset deleted, the goods receipt can now be canceled.
Licenses
Overview
Create new license
Update existing license
Delete license
Restore license
Problem description
Customer order upgrade and then cancel it.
Because we need license key as soon as the order is created, system automatically delete old license and create new one. To revert this process you need to follow next how to guide
Solution
Go to licenses (CTRL+/ and search license):
Find newly created license and delete it:
Find old license which needs to be restored:
Open and restore it:
Create upgrade to, upgraded at and save it:
Downgrade license
Old license:
- copy sale order item id from new one
- change ds_licence_id on serial to old one
- remove deleted at on old license
- remove upgrade_ds_license_to_id
New license:
- remove upgrade_ds_license_from_id
- delete license with button