DTW Journal Entry with tax and with Business Partner?

[Former Member]

Hi SAP Expert,

I tried to DTW Journal Entry with tax and with shortname but i found this error message:

I'm using this template for the DTW;

is it possible for me to do DTW with GST and also with Business Partner?

Thanks and looking forward to your feedback.

Aqsha

[former_member227598 · Accepted solution]

Hi Aqsha,

DTW allows to import JE with control account. In Journal entry lines template, if account code field is a control account, short name field will be Business partner.

Here is example:

ParentKey     LineNum     AccountCode     Debit     Credit     DueDate     ShortName     ContraAccount     ReferenceDate1

JdtNum     LineNum     Account     Debit     Credit     DueDate     ShortName     ContraAct     RefDate

1     0     _SYS00000001660          5000000     20160516     _SYS00000001660     V1400012     20160516

1     1     _SYS00000000050     5000000          20160516     V1400012     _SYS00000001660     20160516

Rgds

Kamlesh Naware

[Former Member · Accepted solution]

Thank you sir for the answer and the template. now i suceed the DTW

[Former Member]

i use this template for JDT1

and btw im using SAP Business One 9.1 PL: 07

[KennedyT21]

Hi,

Give the control account in the account column...

Cheers!!!

[Former Member]

Thank you sir, now i succeed the DTW