| Description |
select * from tblGLDetail where strBatchId = 'BATCH-3684'
select * from tblGLAccount where intAccountId = 11919
The payment entered was for $3150. However the adjustment to AR has an extra $1400 credit. Found that the overpayment method is creating an additional journal entry and the offset is coming from service charge field in company location.
I think the solution for 15.1 is to stop the additional entry for overpayment in tblGLDetail, Since there is a change in iNet for overhaul of overpayment mechanism.
|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|
|131119|00:00.0|BATCH-3684|9563|3150|0|0|0|Cash Clearing Account-|AR|CELOIL |NULL|1|14:55.7|00:00.0|NULL|NULL|0|1|1052|RCV-294|294|Receive Payments|Receive Payments|Accounts Receivable|1|
|131120|00:00.0|BATCH-3684|9564|0|1400|0|0|Accounts Receivable-|AR|CELOIL |NULL|1|14:55.7|00:00.0|NULL|NULL|0|1|1052|RCV-294|294|Receive Payments|Receive Payments|Accounts Receivable|1|
|131121|00:00.0|BATCH-3684|9564|0|1750|0|0|Accounts Receivable-|AR|CELOIL |NULL|1|14:55.7|00:00.0|NULL|NULL|0|1|1052|RCV-294|294|Receive Payments|Receive Payments|Accounts Receivable|1|
|131122|00:00.0|BATCH-3684|9564|0|1400|0|0|RCV-294|AR|CELOIL |NULL|1|14:55.7|00:00.0|NULL|NULL|0|1052|1052|SI-949|956|Overpayment|Invoice|Accounts Receivable|1|
|131123|00:00.0|BATCH-3684|11919|1400|0|0|0|RCV-294|AR|CELOIL |NULL|1|14:55.7|00:00.0|NULL|NULL|0|1052|1052|SI-949|956|Overpayment|Invoice|Accounts Receivable|1|
|