Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to update Ref fields in JDT1 for Journal Entries update

Hi Forum,

I am this situation:

While Creating Journal Entries using DTW:

==================================

I can create Ref1 and Ref2 data at JE Header level using OJDT DTW template.

I can not update Ref1 and Ref2 (different from Ref1 and Ref2 data at header level) at line level using JDT1 template. No error in DTW, all successful, however, the Ref1 and Ref2 data at line level is copied from header level.

While updating using JDT1 DTW Template:

===================================

I thought may be DTW can update since the entries are present. It does not even do that. That is DTW does not update Ref1 and Ref2 data on JDT1 line level even with update DTW. Just to ensure I am using right template etc. I tried to update the due date and it seems to work.

Note: While entering manual Journal Entires directly on SAP B1, I could put different Ref1 and Ref2 at header and line levels.

Thanks for you help.

Former Member
Former Member replied

Hi Syed,

try this:

RecordKey LineNum AccountCode ContraAccount CostingCode Credit Debit DueDate LineMemo ShortName Reference1 Reference2

RecordKey LineNum AccountCode ContraAccount CostingCode Credit Debit DueDate LineMemo ShortName Reference1 Reference2

1 0 3274426 20110430 Basic 520010 12 12

1 1 1344031 20110430 Hra 520020 13 13

1 2 229251 20110430 Convey 520030 13 13

1 3 631301 20110430 Bonus 525020 13 13

1 4 2128839 20110430 Spl All 520040 13 13

1 5 44003 20110430 CCA/Outlocation 520050 13 13

Thanks,

Neetu

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question