Title Index
Recently Changed
Page Hierarchy
Incomplete
Tags
You can export history invoices with line item detail to a spreadsheet .csv file.
This spreadsheet is created in: Order Processing (Module 6), Electronic data interchange (Task 8), Invoice export from history (ARCEXP).
The document Export Invoices from History to a .csv using "O" Original shows you how to set parameters for exporting invoices in general, how to create an export file, where to find the export file, and an explanation of the columns in the spreadsheet. But in order to export the line items of invoices too you'll need to also set the ARC'INCLUDE'LINE'ITEMS parm to Y in the same parameter task mentioned above:
Parameter settings:
Order Processing (Module 6)
System management functions (Task 32)
Modify parameter files (Sub-task 22)
Custom options (Selection 8)
When ARC'INCLUDE'LINE'ITEMS is changed to Y the spreadsheet exported will also have order line item detail.
The .csv file created will NOT have column names in the 1st row.
Here is the spreadsheet column explanation of the detail rows:
Column EXPLANATION of detail rows
A H for header or D for item # detail, depending on ARC'INCLUDE'LINE'ITEMS= parameter setting
B Invoice # or invoice-order #, depending on ARC'INVOICE'APPEND= parameter setting. This also has the sequence # of the line item.
C Item #
D Item description
E Extended $ amount of line item
F Quantity shipped/ total square feet for dimensional items. This is blank for non-dimensional items.
G Quantity of originals. Blank for non-dimensional items.
H Quantity of sets. Quantity shipped for non-dimensional items.
I Unit price or (each price)
J Item discount $
K Unused at this time
L Dimensions, width & height, 24 X 36. Blank for non-dimension items.
M If item is taxable=1; It item is non-taxable=0