on 05-05-2015 9:20 PM
My client wants to import AR Invoices on a regular basis from a third party product. We decided to use AR draft documents through DTW because they want the ability to make changes to the Invoice before adding. Using ODRF and DRF1, Import works fine when only one line item is on the document. If multiple lines only last line is imported.
Any assistance would be greatly appreciated.
Thank You
You need to check the Parent key in ORDF and DRF1.
Check whether corresponding keys are correct.
Suppose the Doc 1, 2, 3, 4 contains 2 lines, 1 line, 2 lines, 4 lines respectively.
Put Lines numbers 0,1 for Doc1; 0 for Doc2; 0,1 for Doc3 and 0,1,2,3 for Doc4 as follows in DRF1
ORDF
DocNum |
DocNum |
1 |
2 |
3 |
4 |
DRF1
ParentKey | LineNum |
DocNum | LineNum |
1 | 0 |
1 | 1 |
2 | 0 |
3 | 0 |
3 | 1 |
4 | 0 |
4 | 1 |
4 | 2 |
4 | 3 |
Check this first,
Regards
JO
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must miss some key field in the DWT template to link header and line together.
If you are constantly importing data on a daily basis, I would suggest you to use DI to do this. Can put logic check inside program to validate date, and schedule the import process. This is a very small job.
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.