In the blog ‘Innovation in our DNA’, we have explained in detail about the need from oil industry to handle oil density conversions at batch level and mentioned that ByDesign has a solution for that problem.

In this blog, I will take you through a simple ‘Order to Cash’ scenario and how the batch conversions are included in the entire process in SAP Business ByDesign.

a) Master Data Setup.

Creating the master data by carefully choosing the UOMs and marking the relevant UOMs as batch dependent is the crucial step

Few important points to note while defining master data are…

  • ATP shall not consider batches while giving confirmations and ATP uses planning UOM as the basis for its confirmation. Hence, for getting accurate results considering planning view of inventory as per the batch conversions maintained at btach, the UOM conversion between the planning UOM and the UOM in which the Sales order will be created should be batch independent.
  • Invoice in the ByDesign system doesn’t hold the batch information. Hence, we don’t support any batch related functionalities (viz., batch valuation, batch conversions etc) at invoice level. Quantity delivered and shown in Outbound delivery (which is always shown in order UOM), will be sent to Invoice for invoicing. Hence, the outbound delivery quantity (and hence the SO quantity) should always be
    • in UOM that is basis from the standpoint of Invoice (or)
    • in UOM, where the conversion between the invoice basis UOM to the order UOM is not batch dependent.

In the current example, I have a product, which has the following setup.

Base UOM : Kg

Inventory UOM : Kg

Planning UOM : L

Order UOM : L15

Invoice basis UOM : L15

1 Kg -> 1 L15 : Marked as batch dependent.

1 L15 -> 1.1 L : Marked as batch independent.


Master data.png



b) Inventory Build

Inventory for the product at a specific site can be build using any of the methods as per the business requirement. (viz., Production, External Procurement, Stock transfer etc). Since the focus of the blog is ‘Order to Cash’, in this post, we will directly refer to an existing inventory of 100 Kg for this product of a batch B1, where the conversion between Kg to L15 is maintained as 1.05.

Istock.png

For this batch, It can be seen in stock overview that the inventory of 100 Kg corresponds to 105 L15, considering the batch conversion.

Stock Overview.png

c) Sales Order Creation

Lets create an order for 110 L15. System shall then provide confirmation to 105 L15, which is value of inventory in L15 considering the actual conversions at batch. (Had the product conversions are considered, then the ATP confirmation would have been 100 L15, as 1 Kg = 1 L15 as per product master)


Sales Order.png



d) Customer Demand : ATP Confirmation

In the customer demand too, it can be clearly seen that the requested quantity of 110 L15, got a confirmation of 105 L15, as per the inventory (considering batch level conversions).

Customer Demand.png


e) Outbound Delivery


While creating OD, the task and the PGI screens have been enhanced to showcase the requested quantity in order UOM as well as the inventory UOM, such the warehouse worker will have an idea regarding the order quantity. (Earlier we were only showcasing the requested quantity only in inventory UOM)


As can be seen, when the batch is not entered, system showcases that the warehouse worker need to pick up 105 Kg for delivering 105 L15.

Delivery before batch.png



However, upon entering batch B1, system considers the conversions at batch B1 and suggests the user that 100 Kg of batch B1 is sufficient to deliver 105 L15.

Delivery after batch.png


User issues 100 kg of batch B1 and clicks ‘Release’ to create outbound delivery. Outbound Delivery gets created for 105 L15 by issuing inventory of 100 Kg of B1.

OD got created.png


f) Invoice

The invoice request shall showcase the actual delivered quantity of 105 L15 as invoice relevant quantity. Invoice request.png


From Invoice request, invoice got created.

/wp-content/uploads/2015/12/invoice_841766.png




Hope this blog helped in getting the idea of how the batch specific conversions are considered in the ‘Order to Cash’ scenario and also helped in understanding how the pain points laid out in earlier blogInnovation in our DNA’, got resolved.


– V Krishna Anaparthi

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Vijay Muthusamy

    Hi Krishna,

            I am trying the batch conversion  as you proposed,  I am facing the issue , after identified stock creation, where  I could not found the values in the ” Alternative Quantity ” in the Stock overview.

    1.Identifided Stock , Quantity conversion

    /wp-content/uploads/2015/12/i1_1_842986.png

    2.Stock Overview

    S1.1.png

    Please advise .. Thanks

    (0) 
    1. V Krishna Anaparthi Post author

      Hi Vijay,

      In the stock overview query parameters under the ‘Display settings’, first you need to enable the alternate UOM and mention in there, which UOM is your alternate UOM. Only then you will see inventory in that specified alternate UOM. Refer to the stock overview screenshot in the blog.

      Regards,

      Krishna

      (0) 

Leave a Reply