Skip to Content
Author's profile photo Manoj Kapoor

Product Serialization in Business ByDesign – Part 3: Order To Cash


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

Order To Cash

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.

Sales Order

A sales order is created with the items to be sold to a customer. This step is the same as for non-serialized items.

Delivery Proposal

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

Goods Issue

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

Outbound delivery which is used for shipments, shows the Serial Numbers being shipped

Serial Numbers are also visible on Delivery Note


Customer Invoice

Serial Numbers are also carried over to Customer Invoice and are visible in Invoice Request

Registered Product

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.


Serial Number Inventory Visibility & Genealogy

This section describes the serial number inventory & genealogy reporting within the system

Serial Inventory Overview

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 (Genealogy)

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

Serial Number Data Sources & Reports

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.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks Manoj. Quite interesting..



      Author's profile photo Ed Govett
      Ed Govett

      Hi Manoj,

      Ed Govett here - I hope all is well with you. Excellent set of blogs.  I have one question that has come up. The client need to be able to serialize each unit and pack several of these units into a pallet. At the time of shipment, they only want to enter the pallet # and NOT all the serial #s in the pallet. In ByDesign, we are able to perform a goods movement to group several serialized units into a Logistics Unit but I am unable to post goods issue without explicitly specifying all the serial #s even if I specify the Logistics Unit.

      Is something we are missing or is this standard functionality that makes the user specify each serial number in the logistics unit?

      Thanks so much for you time.


      Author's profile photo Leonardo Tonelli
      Leonardo Tonelli

      Hi Manoj,

      is there a way to make visible the Serial Number in the Customer Invoice form? Because we have tried but via EasyForm Editor is not possible.