Export to Excel

Change TEXTTRX to 3

Delete the IDTRX column

Add CN to the invoice numbers

Put the invoice numbers into INVCAPPLTO

Import

Post

Thank you. When I export, I have 5 sheets that appeared on the export file. I'm assuming that all the changes indicated above will be done to "Invoices" Tab and no changes to other 4 tabs, is that right?

Yes

YOU ARE AWESOME...thank you

I also noticed that the TERMCODE should be blank

Hi, Do you know what IDTRX means? What data goes into this column

Name Type Size Prec Description Index Attrib Initial Value
CNTBTCH BCD 5 0 Batch Number 1 RKEA 0
CNTITEM BCD 4 0 Entry Number 2 RKEA 0
IDVEND String 12 0 Vendor Number 3 REA
Mask Presentation - %-12C
IDINVC String 22 0 Document Number 4 REA
Mask Presentation - %-22C
IDRMITTO String 6 0 Remit-To Location 5 EA
Mask Presentation - %-6N
TEXTTRX Integer 2 0 Document Type 6 EA 1
List Presentation with 4 items in the list:
1 - Invoice
2 - Debit Note
3 - Credit Note
4 - Interest
IDTRX Integer 2 0 Transaction Type 7 CEA 12
List Presentation with 5 items in the list:
12 - Invoice - Summary Entered
13 - Invoice - Recurring Charge
22 - Debit Note - Summary Entered
32 - Credit Note - Summary Entered
40 - Interest Charge
INVCSTTS Integer 2 0 Reserved 8 E
ORDRNBR String 22 0 Order Number 9 EA
Mask Presentation - %-22C
PONBR String 22 0 PO Number 10 EA
Mask Presentation - %-22C
INVCDESC String 60 0 Invoice Description 11 EA
SWPRTINVC Integer 2 0 Reserved 12 E
INVCAPPLTO String 22 0 Apply-to Document 13 EA