My G/L Account Balance for Open items is different than the Cumulative Balance

[Former Member]

I have not had much FI experience but have come across this problem.  It appears that there are Cleared documents on the G/L Account Balance that also have balances.  So, when you look at the Open items balance there is difference.  Here is an example of what we are seeing.  We received an invoice.  Debited the Vendor Account. Credited the Accounts Payable account.  Then Credited Cash Discount account.  However, we took too much discount.  Therefore, we debited the overage of the discount from the Cash Discount Account. 

Now, the Cash Discount Account Open balance is different from the Cumulative balance by the amount of the overage.  The original invoice and accompaning documents are cleared.  How do we balance the two again?

Thanks

FH

[Former Member]

Frank,

Cash discount taken account should be a P&L account which would not be open item managed, only line item display. Also while posting invoices the entries would be only Cr A/P Dr Expense (assuming no tax) and while making payment Dr AP Cr Cash Cr Cash discount (if discount was taken).

You may want to verify your entries, i think that should help.

BR

Avinash