This is the starting panel for working with serial number costs. All existing serial numbers for the item are displayed.
From this panel you can define:
- individual cost prices per serial number (if the serial number is not attached to a BtB transit order type).
- individual transit cost per serial number (if the serial number is attached to a BtB transit order type).
In certain situations it can be advantageous to use this feature. The scenarios below detail circumstances in which it may be important to keep track of individual item costs:
- Specific customer requirments: Customised products can cause additional costs to be incurred when the item is manufactured: such as interruptions of the assembly line process. This functionality allows you to keep track of machinery sales and other objects that have a unique configuration.
- Trade-ins; Used equipment: This routine can be used to keep track of identical items that are in different states, i.e. used cars that are of the same model; year; but have different mileage.
- Very expensive objects: There are certain objects that are made up of components that may fluctuate in price, i.e. jewellery. These type of objects may even require a detailed cost tracking of components.
Serial number cost tracking can be further extended for use with item order structures. This will allow all component costs to be tracked.
If DC1 Service is installed this functionality can also be used for tracking service objects such as those having high maintenance costs with low profit margins:
Profitability follow-up
Profit analysis reports can also be generated per serial number item. Profitability follow-up offers a complete view of all income and all costs per serial numbers based on sales orders and/or service orders.
Balances
You can also specify – at the item level – whether you wish to generate sales balances per serial numbered item. Balance file transactions will then be created when sales or service order lines are entered. For each order line unique records will be created in the Balance file. The serial number is used as the statistic key for each new record.
Cost prices are retrieved according to unique item Cost type code in:
- Stock transactions
(Stock take difference; cost of goods sold; scrapping). - Stock valuations
(profit calculations; statistics). Note: If a serial number cost price is not found, the cost type defined at the company level will be used.
Cost prices per serial number items are calculated and updated, or manually entered, in the following transactions:
- in the purchase routine whenever the item quantity in stock is increased.
- in the Work with inventory routine.
- when entering credit notes (via the sales order entry routine).
Cost prices per serial numbers are calculated as:
| Purchase price + Landed cost (last purchase cost) |
Cost prices per serial numbers are updated in the:
- Serial number tracking file.
Note: If the Separate cost handling field in the DIS control file is set to YES, transit cost and normal stock cost information will be stored separately. - Serial number history log file
Cost change events are added to this file - Object history log file.
Cost change events are added to this file for service objects.
Setting up the serial number cost tracking function:
To define a unique cost price per serial number: the value of parameter Cost type must be set to 4 at the item level (Item file, Inventory information (DMR00301) panel).
Cost types can be defined in both the DIS control file and the Item file. In these cases cost information is calculated in parallel. You can, for example, define a cost type at company level that will keep track of all purchased items and at the item level keep track of the cost price of manufactured items.
Internal replenishment orders
- if a purchase price is not found for an item, its unique cost price will be automatically defaulted.
- when IR purchase orders are received, the item’s new cost price is calculated and updated according to the landed cost that was defined on the order.
Entering sales orders for cost per serial number items
- Item quantity per line is limited to 1.
- Order structures will be divided – according to quantity – across several sales order lines.
Options
- Serial number
- Displays the item serial number.
- Cost price
- Displays the individual cost price of the serial numbered item.
- Transit cost price
- Displays the individual transit cost of the serial numbered item.
Selection fields
Item file maintenance, Cost price per serial numbers (DMR01104)
If you have accessed this panel in Change mode you will only be able to enter information in the first two fields. The other fields in this panel are only displayed in Display mode.
Function keys
- Serial number
- Displays the item serial number.
- Cost price
- Enter the cost price of the item serial number. Note: If the serial number is in transit stock this field will be protected.
- Transit cost price
- Enter the transit cost of the item serial number. Note: If the serial number is in stock this field will be protected.
- Warehouse
- Displays a code from the Warehouse table indicating the main warehouse that the item is stocked in.
- Zone
- Displays the zone where the item is stored in the warehouse.
- Country of origin
- Displays a code from the Country table indicating item’s country of origin. This value is defaulted from the Item file maintenance, Basic data panel.
- Bin location
- Displays the bin location where the item is stored in the warehouse.
- Manually entered
- This field is set to YES if the serial number was manually entered, or NO if the serial number was created at goods reception.
- On IR order
- Indicates if the item is currently on an internal replenishment order.
- In stock
- Indicates if the item is in stock.
- In transit delivery
- Indicates if the item is currently in transit.
- In quality control
- Indicates if the item is currently located in quality control.
- Rejected at qual ctl
- Indicates if this item was rejected at quality control.
- Supplier
- Displays the supplier of the item.
- Reception date
- Displays the date that the item was received into stock.
- Purchase order
- Displays the number of the purchase order that was used to order this item from the supplier.
- Purchase order line
- Displays the purchase order line number.
- Reception note
- Displays the number of the reception note that was used to receive this item into stock.
- Reception note line
- Displays the number of the reception line note line.
- Inventory contract
- This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated. If the item received belongs to an inventory contract, this field displays the inventory contract ID.
- Inv contract line
- This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated. If the item received belongs to an inventory contract, this field displays the inventory contract line number.