JDE0101
Active Member
Hi all,
We are planning to (1) load a file from an external company into JDE with the intent of creating invoices automatically. The file formats are not an issue as we can specify exactly how we want them. We will then receive a cash collection file from a bank and we will attempt to match this to the invoice by loading this automatically (2).
In relation to loading into AR and also automatically matching cash:
(1)
I was thinking of using some standard EDI programs. E.g. using Transaction Type 810 for the invoice loads:
R47002C: Load the invoice flat file
R470412: Attempt to create the invoices.
R47048: Purge Processed records
(2)
For matching the cash collection I am unsure how I would do this. I was thinking:
R47002C: Load the Cash Collection flat file
R470412: Attempt to match using either R47041 (Inbound Voucher), R470412 (Inbound Invoice Match to PO)or R47111 (EDI LockBox Create)
R47xxx: the related UBE to Purge Processed records
In theory will this work? Is this the best (out of box) method in JDE?
Thanks in advance,
JDE Xe, sp22, WTS, w2k+3 Deployment, UNIX AIX Enterprise.
We are planning to (1) load a file from an external company into JDE with the intent of creating invoices automatically. The file formats are not an issue as we can specify exactly how we want them. We will then receive a cash collection file from a bank and we will attempt to match this to the invoice by loading this automatically (2).
In relation to loading into AR and also automatically matching cash:
(1)
I was thinking of using some standard EDI programs. E.g. using Transaction Type 810 for the invoice loads:
R47002C: Load the invoice flat file
R470412: Attempt to create the invoices.
R47048: Purge Processed records
(2)
For matching the cash collection I am unsure how I would do this. I was thinking:
R47002C: Load the Cash Collection flat file
R470412: Attempt to match using either R47041 (Inbound Voucher), R470412 (Inbound Invoice Match to PO)or R47111 (EDI LockBox Create)
R47xxx: the related UBE to Purge Processed records
In theory will this work? Is this the best (out of box) method in JDE?
Thanks in advance,
JDE Xe, sp22, WTS, w2k+3 Deployment, UNIX AIX Enterprise.
