How to update Ref fields in JDT1 for Journal Entries update

[Former Member]

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 · Accepted solution]

hi

u may use the follwing fields to do it

RecordKey LineNum AccountCode ContraAccount CostingCode Credit Debit DueDate LineMemo ShortName

RecordKey LineNum AccountCode ContraAccount CostingCode Credit Debit DueDate LineMemo ShortName

1 0 3274426 20110430 Basic 520010

1 1 1344031 20110430 Hra 520020

1 2 229251 20110430 Convey 520030

1 3 631301 20110430 Bonus 525020

1 4 2128839 20110430 Spl All 520040

1 5 44003 20110430 CCA/Outlocation 520050

Regards

Manish

[Former Member · Accepted solution]

Hi Manish,

You do not show Ref1 and Ref2 fields in your entries.

Yes, I tried what you have shown here, I could udpate other fields but not Ref1 and Ref2 fields at JDT1 entries line level.

Thanks.

[former_member206488 · Accepted solution]

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