cancel
Showing results for 
Search instead for 
Did you mean: 

DTW AR invoice Draft only importing last line

former_member609550
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

ParentKeyLineNum
DocNumLineNum
10
11
20
30
31
40
41
42
43

Check this first,

Regards

JO

former_member609550
Discoverer
0 Kudos

I'm importing one document with four lines but only getting last line.  Running through dtw as transactional, add, other, draft.

frank_wang6
Active Contributor
0 Kudos

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