Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Image Modified

2, Click "Open in Excel" to generate into Excel file.

Image Modified

3, Confirm that Column I = Entry No. Column J = Batch No. / Expiry Date (if for updating Expiry Date)

If not, move the column.

Only Column I & J will be recognized by the importing function, other columns are just reference for users to

update

help them updating the entries.

Sample Excel file as captured:

Image Modified

4, After saving, back to ILE, click the import function to choose which to update, Batch No / Expiry Date

Image Modified