...
Prescient sends a CSV file via FTP containing sales units for different products and stores. This process loads the file and updates the vendor managed inventory to reflect the sales
Customer Sales Import
The third party company Prescient collects egg point of sales data from customer stores. It aggregates these data and generates a CSV file, which is then sent via FTP to a location accessible by Aeros ERP. Users select the file
Mapping
Users must select a division before selecting a CSV file to process. All records will be created for this division
The CSV has only four fields that are used to update the vendor inventory
Supplier store ID must map to both the customer and the customer location. That is, customer and its location must be the same for this process to work.
Supplier | ||
Retailer | ||
Supplier Store ID |
| |
Retailer Store ID | ||
Store | ||
Item Nbr | Item Code | |
SKU | ||
Description | ||
UPC | ||
Unit of Measure | ||
Business Day | Transaction Date | |
Line Items Selected | ||
Units | Units | |
Net Cost | ||
Allowance | ||
Base Cost | ||
Total Retail Amt | ||
Retail Selling Class | ||
Retail Unit Multiplier | ||
Retail Unit Price | ||
$ Impact | ||
Tracking Id | ||
Sales Type Code | ||
Warehouse Id | ||
| Other Info |
Open File Button
Users select a Prescient CSV file using the Open File button. The import form will attempt to parse it based on the specified structure for the file:
Process Sales
Once a CSV file has been loaded, the Process Sales button will do the following
- Validate each record in the CSV file.
- Update the VMI ledger for the division/customer/location for each record that passes validation
Usually, we expect these transactions to reduce available VMI inventory
VMI Adjustment Form
Users can alter the current inventory through this form
...