Description |
select * from tblGLDetail where dblDebit > '0' and dblCreditUnit <>0
Here's an example of the results. When importing closed years, the unit should follow the amount.
dblDebit = dblDebitUnit
dblCredit = dblCreditUnit
|intGLDetailId|dtmDate|strBatchId|intAccountId|dblDebit|dblCredit|dblDebitUnit|dblCreditUnit|strDescription|strCode|strReference|intCurrencyId|dblExchangeRate|dtmDateEntered|dtmTransactionDate|strJournalLineDescription|intJournalLineNo|ysnIsUnposted|intUserId|intEntityId|strTransactionId|intTransactionId|strTransactionType|strTransactionForm|strModuleName|intConcurrencyId|
|80802|00:00.0|BATCH-3|620|6442.94|0|0|389.5|PAYROLL CHECK |GJ|PAYROLL CHECK |3|1|23:04.1|00:00.0|PAYROLL CHECK |80802|0|0|15|PR 0903 201409|3650|Origin Journal|General Journal|General Ledger|1|
For now I will run the queries in [http://inet.irelyserver.com/display/GL/Recreate+GL+Summary] to fix the issue.
|