Shipment Invoice details loading via Excel/CSV spreadsheets or how to import invoice details via Excel?
Steps to load/import the invoice details via Excel/CSV spreadsheets:
1. First, go to the shipment screen and create/edit a shipment.
It can be accessed from the Side Menu:
- Shipments >> Create/Edit (Double click to open).
Below is the screenshot:
2. Fill out the details as needed then go to the CCIs from the left side container. It will open CCI header screen as shown below:
3. Fill it out as needed, then click on details to import Excel/CSC spreadsheet.
Below is the screenshot:
4. Click on "Browse" to browse the spreadsheet(wherever it is stored on the computer/laptop) to import as shown below:
Once the data is uploaded from the spreadsheet, you can choose to "Skip" the TOP/Bottom ROWS if the data which is loaded from the spreadsheet is irrelevant.
Also, you can click on the ARROWS on the top for each column to select the correct LABEL for the data. As shown below:
Once the Column-Heading LABELS are properly selected, it would look like the below screenshot:
Click on "OK" button at the bottom right hand corner to import the DATA.
Comments
0 comments
Please sign in to leave a comment.