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 ...

    • Import format for Inventory counts with expiration dates

      Product Query Is there any format to import for inventory Counts so we can import expiration date also for batch items ? Answer We can just save the current batch number in this case since the inventory counting document is solely utilized for ...

    • 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 ...