GL account error balance

Hello,

i’m using ax2009. just now i got the problem which is, i’m trying to extract transaction journal to excel, now after i extract transaction i found the different amount in excel…which is not balance or not same the previous records in ax system.

someone please help me…

thanks,

Hello,

Please check in GL Parameters Transaction Reversal - Correction = Yes is set. It adds the +ve or -ve signs to Reversal Transactions for tracking purpose. So when you copy transactions from AX and paste into Excel the sum of transactions would not be correct.

You can use Export to Excel functions from the transaction form and it will take care of these additional -ve and +ve signs prefixed to transactions.

Thanks,

Thank u so much… :slight_smile:

Please click Verify Solution if this was useful, so that other can take benefit of this thread.