Supply User Manual ENG -> 5. Warehouse -> 5.10 LU-SU4203: Consumption Reports -> C. HOW TO IMPORT AN EXCEL FILE ON A REAL CONSUMPTION REPORT
C. HOW TO IMPORT AN EXCEL FILE ON A REAL CONSUMPTION REPORT
In some cases, consumption may have been recorded on an Excel file. Such a file can be imported on a RCR in order to update the system (i.e. record consumptions in UniField). The import can be done via the “Import a file” button available on the main RCR screen.
The file must have a specific format (XML Spreadsheet 2003) and include the following columns in the following order: Product Code, Product Description, Product UoM, Indicative Stock, Batch Number, Expiry Date, Asset, Consumed Qty, Remark, BN (Y/N); ED (Y/N).
A template of importable file may be obtained if you export an existing RCR using the “Export lines” button.
Following the import some checks are done on BN and product lines so that error messages are raised in case of inconsistencies.
|
|
|
File format for import to RCR |
