This is the final blog on three part series on the use of serial numbers in Business ByDesign. This blog focuses on the use of serial numbers in Order To Cash business process, describes serial number inventory visibility & genealogy and related data sources and reports
Serial Numbers in Business Scenarios
A typical Order To Cash process goes through the following steps:
Sales Order -> Delivery Proposal -> Goods Issue -> Outbound Delivery -> Customer Invoice -> Registered Product
This section shows various steps and ways to capture serial number during Order To Cash process.
A sales order is created with the items to be sold to a customer. This step is the same as for non-serialized items.
A released customer demand generates a Delivery Proposal. When the order is ready to be picked, the delivery proposal is released to the warehouse to generate a pick ticket. This step is similar to the non-serialized inventory
For serialized products, serial numbers are mandatory and actual quantity is incremented by entering the serial numbers.
The serial numbers can be entered i) manually in “Next Serial Number” field ii) uploaded via excel using “Upload” button iii) input via bar code scanning in the “Bar Code Input” tab
i) Manually entering serial number in “Next Serial Number” field
ii) Upload via Excel
A simple excel file with serial number column (without header) is created
The file is uploaded using the “Upload” button. This upload is performed per line item basis.
Outbound delivery which is used for shipments, shows the Serial Numbers being shipped
Serial Numbers are also visible on Delivery Note
Serial Numbers are also carried over to Customer Invoice and are visible in Invoice Request
A registered product is created when serial number is created/ gnerated in the system. This could be at Goods Receipt or Make Production Task. Registered Product is updated with customer information at the time of Goods Issue. Registered Product captures the product warranty informaton and serial number movement tracking history showing Sales Order, Outbound Delivery, Production Lot, Purchase Order information.
This section describes the serial number inventory & genealogy reporting within the system
Serial Inventory overview shows the snapshot of serial number inventory by product and logistics area. This screen can be navigated directly via Common Tasks -> Serial inventory Overview in Inbound Logistics, Outbound Logistics, Internal Logistics, Physical Inventory and Outbound Logistics Control or via Stock Overview -> Open Serial Inventory. Open Serial Inventory button is only active for serialized products
Registered Product Hierarchy shows the hierarchy of serial numbers which have gone into making of parent serial number. Note this hierarchy only shows the serialized products.
Navigation: Service Entitlements -> Registered Products: Select the registered product -> Open Chart
New data sources REG_PROD_GENERAL (Registered Product General Information) and REG_PROD_MH (Registered Product Movement History) are available to create serial number reports.
REG_PROD_GENERAL data source can be used to create flat parent- child serial number relationship report as shown below via Key User Tool.
REG_PROD_MH data source can be used to create serial number movement tracking report as shown below via Key User Tool.
In summary, this blog series serves as a quick start guide for using serial numbers in Business ByDesign. This blog series explained the required setup and configuration and showed the use of serial numbers in three major business process scenarios namely, Procure To Pay, Make To Stock and Order To Cash. As mentioned in Process Overview section serial number tracking is also supported in other scenarios like Over the Counter Sales, Third Party Delivery and Intra company stock transfer etc., which follow similar procedures. Lastly, it showed serial number tracking, tracing and reporting capabilities in Business ByDesign.