{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.SmartFusion Modules > Accounts Receivable > Maintenance > Import PDOX Invoices
Recent Changes:
6.200 - Fixed an issue where the system would display blank rows in the Add New AR Customers step if the CompanyIds and/or VehicleIds in the file were alphanumeric and numeric.
6.199 - Added the "No Weigh" column for import invoice CSV file. Added functionality to allow for multiple lines per invoice.
6.129 - Changed the PDOX file import to pull Field 1 (Ticket Number) into Description instead of Refuse type
6.104 - changed allowable field length for Alpha Sort to match that of Enter/Edit customer
6.88 - Moved the selection of the Product Code from Step 1 to Step 2; Added a list of duplicate invoice numbers found during the import process; Added a list of blank product codes found during the import process
6.87 - Initial creationIntroduction
This process allows for the importing of PDOX files to create invoices.
Explanation
Step #1: Select Import File and Product Code
- Select file to import (required)
Step #2: Add New AR Customers
- Enter the name (required), product code (required), address, city, state and zip code for any new customers
Step #3: Import Invoices
- Success message - Processing has been completed
- Error message - The following invoice numbers in the selected import file already exist:
- Error message - The following account numbers have blank product codes:"
Import File Layout from PDOX (abbreviated)
Type: CSV
| # | Field Name | Format | |
|---|---|---|---|
| 1 | Ticket Number | 999999 | |
| 2 | Date | 99/99/9999 | |
| 3 | Time In | XX:XX:XX | |
| 4 | Time Out | XX:XX:XX | |
| 5 | Company ID | XXXXXXXXXX | |
| 6 | Vehicle ID | XXXXXXXXXX | |
| 7 | Operator | XXX | |
| 8 | Refuse Type | XXXXXXXXXX | |
| 9 | Job ID | XXXXXXXXXX | |
| 10 | Container | XXXXXXXXXX | |
| 11 | Container Weight | 99999.99 | |
| 12 | Manual Container | Y,N | |
| 13 | Gross Weight | 999999.99 | |
| 14 | Tare Weight | 99999.99 | |
| 15 | Unit Price | 9999.99 | |
| 16 | Net Price | 9999999.99 | |
| 17 | State Fees | 99999.99 | |
| 18 | Local Fees | 99999.99 | |
| 19 | Total Price | 9999999.99 | |
| 20 | Invoice | 99999999 | |
| 21 | No Weigh | Y,N | |
| 22 | Manual Entry | G=Gross, T=Tare, B=Both | |
| 23 | Inspection | Y,N | |
| 24 | Inbound | Y,N | |
| 25 | Type | Y=Waste, N=Recycle | |
| 26 | Charge-Cash | Y=Charge, N=Cash | |
| 27 | Fixed Charge | Y,N | |
| 28 | Units | 999999 | this is a decimal in the sample import file |
| 29 | Unit Name | XXXXXXXXXX |