Good Receipt Format for Import Batch item with batch expiry date.

Good Receipt Format for Import Batch item with batch expiry date.

Product version:

iVend 6.5 update 6


Problem Statement:

Customers need to import Batch Managed item on Store MC-->Goods Receipt screen, with batch expiry date.


Proposed Solution:

Suggested to  import the data in the following format using the delimiter mentioned in the retail profile settings. Format attach.


  1. Product Barcode

  2. Quantity

  3. Serial/Batch Number

  4. Expiry Date in yyyyMMdd

  5. Manufacturing Date yyyyMMdd

  6. Admission Date yyyyMMdd

  7. Comments

  8. Price


For e.g.   P0001,12,B0001,20201231,20190609,Goods Receipt, 190

P0001 : Product Code/Barcode


12: Quantity

B0001: Batch Number

20201231 : Expiry Date

[Blank]: Manufacturing Date

20190609: Admission Date

Goods Receipt: Comments

190: Price of the Batch


Steps if any:

NA


Constraints/Scenarios:

NA


    • Related Articles

    • iVend POS - Expiry Date Required for Batch-Serial

      Introduction In iVend, for Serial and Batch managed products, a retailer can capture the expiry date of the products while adding a purchase transaction. Furthermore, to avoid user mistakes, iVend can be configured to enforce the capturing of the ...

    • Multiple Receipt Printing issue

      Environment: iVend 6.6 7989 SAP B1 10 Problem Statement: iVend is sending lots of receipts for single transaction until printing has to be stopped. Symptoms: It was observed that for Receipt ID ‘Transaction receipt’, Transaction receipt was selected ...

    • Updating the iVend Products with Expiry Date

      Version: 6.5 Upadted 6 Query: We imported GO Live products in the iVend with only Product and batch Numbers without expiry dates. We want an import template to enable us to update these products with expiry dates as the client wants Products in the ...

    • Serial and Batch Management

      Serial and Batch Management Serial and Batch Management is added to the inventory operations. This option is available for iVend Un-Plugged version. The option is available in the HO and Store. In HO the data of all store will be displayed based on ...

    • Good Receipt data fetch for Error Insufficient quantity for item with batch on Integration Monitor

      **********Internal Purpose to CXS Support************** Environment : iVend 6.6 With SAPB1 Problem Statement : Stock transfer and Sale transaction events stucked on Integration Failure Monitor with error message “Insufficient quantity for item with ...