Hi,
Is there an option to reverse a AP batch totally? We found a batch to processed incorrectly. Instead of reversing each and every transaction, is there a possibility to reverse the batch as a whole?
Hi,
Is there an option to reverse a AP batch totally? We found a batch to processed incorrectly. Instead of reversing each and every transaction, is there a possibility to reverse the batch as a whole?
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
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
*Community Hub is the new name for Sage City