...
Using apdate Batch No for example, follow below steps:
# | Description |
---|---|
1.Search "Item Ledger Entries". Users can filter the Item Ledger Entries. E.g. If just would like to update the ILE of Location Code = NY, Item No. = ABIB-733344, Type = Purchase Receipt | |
2, Click "Open in Excel" to generate into Excel file. | |
3, Confirm that Column I = Entry No. Column J = Batch No. / Expiry Date (if for updating Expiry Date) |
Only Column I & J will be recognized by the importing function, other columns are just reference for users to |
help them updating the entries. Sample Excel file as captured: | |
4, After saving, back to ILE, click the import function to choose which to update, Batch No / Expiry Date |