jdoiron
Forum Replies Created
-
I believe the AP Account Detail table would have all information you need to satisfy your requirements. You could run a excel sql query to retrieve that data.
-
Was both the invoice and payment applied to the wrong customer account or just the payment? You should be able to void the cash receipt which would reverse the general ledger transaction and re-open the AR record. If the invoice needs to be corrected as well, you could apply a credit note against the invoice to correct the revenue distribution.
-
Ok. If you post a credit note against the invoice to clear the AR balance the GL distribution for the credit note entry should go to the liability account(debit customer deposit liability and credit AR). At that point your sub ledger and general ledger should agree.
customer deposit:
dr. cash
cr. customer liability deposit
invoice(billing):
dr. ar
cr. revenue/deferred revenue
credit note to clear AR:
dr. customer liability deposit
cr. ar
Workarounds are not ideal and can potentially lead to more problems. Someone with more experience can probably assist in locating the missing sub ledger transaction. If I am failing to understand, let me know.
Regards,
Johnathan
-
can you see the deposit journal entry in the general ledger (ie. increase to cash, and decrease to AR)? Locating this transaction in the general ledger might assist in solving this problem if you haven’t already done so.
-
Brenda,
I believe checks register batches will accomplish this. CHECKS>FORMS&REPORTS>CHECKS REGISTER BATCHES. Select the funding bank and date range based on your required search parameters.
Johnathan
-
I am also interested in knowing if any companies have experience using this. I see value in using the FA module if your organization has a significant number of cap. assets to manage/depreciate. With no prior experience using this module, the biggest advantages, in my opinion, would be having access to a clean continuity schedule with recurring monthly depreciation adjustments.
Thanks,
Johnathan D