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