JDE0101
Active Member
Hi all,
Apologies for the duplicate post in this discussion board, I tried in the Applications forum no response. Maybe some of the technical gurus can help..
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 (previously loaded) invoice by loading this cash collection file automatically (2).
In relation to loading into AR and also automatically matching cash:
(1)
I was thinking of using some standard EDI programs to laod in the ‘invoices’. 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.
Apologies for the duplicate post in this discussion board, I tried in the Applications forum no response. Maybe some of the technical gurus can help..
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 (previously loaded) invoice by loading this cash collection file automatically (2).
In relation to loading into AR and also automatically matching cash:
(1)
I was thinking of using some standard EDI programs to laod in the ‘invoices’. 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.
