{{ 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 creation
Introduction
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 |