DTW- Outgoing Payment Upload - Journal Entry

[Thaonguyenphuong]

Hi Experts,

I want to upload an Outgoing Payment using the Data Transfer Workbench (DTW) in SAP Business One with the DocType set as Journal Entry. I am using two templates: Payment and Payment_Invoices.

However, since Journal Entries (JE) do not have a DocEntry field like AR and AP invoices, I encountered the following error when uploading:

"Invalid document number [VPM2.DocEntry][line: 1] Invalid document number [VPM2.DocEntry][line: 1]65171"

I have tried using TransId and Document No for the DocEntry field, but they did not work. Also, I couldn't find a DocEntry field in the OJDT table.

Is there any way to successfully upload the Outgoing Payment in this case? I would really appreciate your guidance.

Thank you!

[Felipe_Lima1m8 · Accepted solution]

Hi @Thaonguyenphuong ,

Try adding the field InvType to the VPM2 template and use the Journal Entry object in there (30). I think SAP displays this message because it simply doesn't know which object you are referring to.

I hope it helps.

BR,
Felipe

[Thaonguyenphuong · Accepted solution]

The upload was successful. I really appreciate your support!

[Felipe_Lima1m8 · Accepted solution]

Hi @Thaonguyenphuong ,

I'm happy to help.

*** Please, if this answer resolves your question, kindly consider marking it as accepted. This helps our community by highlighting useful solutions. Thank you! ***