ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

BDO Solutions

Prevent Shipping Short-Dated Products to Your Customers with Microsoft Dynamics AX


    Email | Print

    In pharmaceutical and food & beverage industries, it is critical to avoid shipping short-dated products to customers. This helps to improve customer satisfaction and avoid unnecessary credit returns and waste throughout the whole supply chain, starting from manufacturers, distributors, retail stores and all the way to end users.

    Customers of food and drug industries always expect products to be shipped to them with newer Expiry date or Best Before date. Specifically some customers will even provide their suppliers a Sellable Days defined as the number of days between customer receipt and batch expiration or best before date for the shelf life products. Microsoft Dynamics AX 2012 for process manufacturing supports the definition of Customer Sellable Days and incorporates the feature with sales order reservation as well as MRP.

    Defining Customer Sellable Days

    Customer Sellable Days can be defined on a customer record for a specific product, a group of products or all products.

    AX Short-dated products

     

    Batch Reservation on Sales Order Lines

    Batches can be reserved on sales order lines manually, or automatically follow the predefined reservation rules. Depending on the Pick Criteria specified on the Item Model Group, Microsoft Dynamics AX will compare the Expiry Date or Best Before Date of the batch with the Sellable DateSellable Date = Requested Receipt Date (or Confirmed Receipt Date if specified) + Customer Sellable Days. A batch with an Expiry Date or Best Before Date before the Sellable Date cannot be reserved.

    The batch reservation will fail and provide an error message prompt as shown below.

    AX Short-dated products1

     

    Master Planning of Batches with Customer Sellable Days

    Master plan can be configured to Consider Shelf Life. Then the Customer Sellable Days will be considered by MRP along with Expiry Date or Best Before Date when MRP is run.

    AX Short-dated products2

     

    For example, the inventory on hand in a batch is enough to cover a sales order demand. But the Expiry date is before the Customer Sellable Date of the product for the customer of the sales order.

    AX Short-dated products3

    After running MRP, AX will recommend a planned production order for the sales order and ignores the on hand batch because it expires during the customer sellable days.

    AX Short-dated products4

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    For more tips about Microsoft Dynamics AX Enterprise Resource Planning (ERP) Software, add BDO’s ERP blog to your browser favorites.  BDO Canada has a dedicated Dynamics consulting team comprised of finance, manufacturing, operations, supply chain, developers, and technical professionals with in-depth knowledge of Microsoft Dynamics AX.

    BDO Solutions is a national firm with local practices throughout Canada, a Microsoft Gold Certified Partner and Reseller of the Year in Canada for 2010, 2011 and 2012.

    By Jasmine Chai, ERP Solutions Consultant, BDO Canada LLP

     

    2 Responses to “Prevent Shipping Short-Dated Products to Your Customers with Microsoft Dynamics AX”

    1. Anthony Lafferriere says:

      Hi

      i’m interesting by this subject.
      I configure a customer with sellable days on a product.
      This product has a item model group based on FEFO control.
      We create forecasts with this product and the customer.
      But after running MRP, it seems to do not use the sellable days.
      It used a batch that expires during sellable days.

      Can you give me more details about parameters?

      Thanks

      Best regards
      Anthony

    2. Chris says:

      Hi Anthony,

      in order to make the sellable days work the “fefo date-controlled” Checkbox in the item model Group of the sold article has to be activated.

      Kind regards,

      Christian

    Ask This Expert a Question / Leave a Comment

     

     
     
    Show Buttons
    Hide Buttons