how to amend trxn values of JV in table level?

[Former Member]

I am uploading large amount of trxns (over 150k in a single batch) to JV using DTW, These trxns contain FC trxns and most of the time local DR and CR is not equal beasue of the exchange rates. I have tried to update trxns value of JV, however system got hung always.

Is it possible to amend the JV figures in table level?

[former_member418241 · Accepted solution]

when JV need to be added to system through DTW both Debit and Credit should match.  This is you need to achieve in the Excel file before you upload, otherwise it will not be possible to edit at table level.

one thing you can do after this in order to run the DTW smoothly without hang.,  you need to split the Excel file into two or more files  i.e. limit the No. of JVs in each file and upload one by one...