cancel
Showing results for 
Search instead for 
Did you mean: 

help - DTW error message: value must be numeric in property 'sumpaid' of 'payment account'65171

supjkt
Participant
0 Kudos

hi there,

need help please. We want to import transaction (add new) using DTW on SAP business one 9.2; for outgoing payment.

module we've used: banking | "payment" and "payment account"

when we make simulation, shown error for some lines as above.

checked that column (in payment template), entries are in numeric.

what's wrong? need help please. thank you.

Accepted Solutions (0)

Answers (5)

Answers (5)

Abdul
Active Contributor
0 Kudos

dear

try csv or txt format to make sure you are facing issue on both formats sometimes changing format resolves this problem.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Are you using same version of DTW template? Have you removed any column from the template?

Regards,

Nagarajan

azizelmir
Contributor
0 Kudos

Could you provide a sample of data in your DTW template ?

supjkt
Participant
0 Kudos

Hi Aziz,

sorry late reply. after we do again, the problem still occur, and there is no empty cell for sumpaid.

azizelmir
Contributor
0 Kudos

Hi Pengguna,

Make sure about the values in column "Sumpaid".

If the Data Source -File type-csv (Comma delimited):

1- For empty cells add zero amount.

2- Format cells > Number > Category: "General".

Thank you,

Aziz El Mir