Book In - Data Import - Create Book In or In Transit

You can create a single or multiple Book Ins or In Transits using the Book In Data Import tool.

Tip: Raising an In Transit is the Zedonk equivalent of raising an ASN. Raising a Book In is the Zedonk equivalent of raising a GRN. The Book In Data Import tool allows you to perform a bulk upload of ASNs (Advanced Shipping Notices) and GRNs (Goods Received Note) into Zedonk.

#From Production Orders dropdown menu select [Book In Import]

Tip: If you do not see this option, ask your Zedonk administrator to follow the General Settings - User Management - User Permissions lesson and enable the 'Production Orders > Production - Import' permission.

#Click [Download Template]

Note:

• This import tool allows you to create an In Transit/Book In/Return from a CSV file.
• The file must be a csv file, no larger than 25Mb and have under 1000 lines.
• If you edit a file in Excel and save, you may lose any leading zeros (more)
• Click the "Import" button to process the csv file, creating the specified book in's.

#Select the docket you wish to create a Book In for from the pop up and click [Export x Docket] to download Book In template

#Open file in excel to add data

This will download a CSV file populated with details from the Production Order

1. Docket: Docket Number
2. Reference: (optional) Enter the Book In Reference. To create multiple Book Ins for the same Docket on one upload, you must give each Book In a different Reference.
3. Product ID: Enter the Product ID
4. Size: Enter the size listed on the Docket.
5. Barcode: Enter the barcode number
6. Docket Quantity: Enter the total quantity listed on this docket
7. Pending Quantity : The total quantity pending after the Book In Quantity has been entered.
8. Quantity: Enter the units to be booked in

If using barcodes ensure to reformat Barcode column to a Number format:

Tip: If you have the multi-location inventory module enabled, you will notice an additional Location column that is mandatory.

#Enter details for the Book In (or Book Ins) you wish to create

#To create an In Transit select [In Transit] from [Type] dropdown before clicking [Import]

#Success!

#To create a Book In select [Book In] from [Type] dropdown before clicking [Import]

#Success!

Tip: If you're looking to export data (e.g., a CSV or Excel file) from a Production Orders docket you can use the Production Reports. For more information, see Reports - Production Reports - Types and Uses Summary.