Skip to Content
author's profile photo Former Member
Former Member

how to amend trxn values of JV in table level?

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 28, 2016 at 12:26 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.