We just implemented SL 7.0 in January. There is a difference between our AP account balance and the vendor period trial balance. Is there a report that can be run, or any easy way to see an entry that hit AP directly?
If you want to see transactions posted to the AP Control account which did not originate in the AP module, print the Detail GL report. On the Select tab, you will have a two line entry like this.
AccthistAcct Equal 2000
GlTranModule Not Equal AP
The field names are in the format Viewname.Fieldname and I have not typed the whole thing, but you will be able to see the fields I have named when you use PageDown in the Select tab.
I have a reconciling spreadsheet I made that walks you through the various things that can cause this... since we cannot upload files, I will attempt to paste it...
Month-end AP Account Balancing
For month of: ________________________________
Note: Be *SURE* all reports are set to the current period, and GL is in same period as AP. Change 21000 to the AP Account you are balancing to the GL. This sheet assumes that prior month was in balance.
check for done, or amount
1. Run AP Batch Register for unreleased.
AP Batch Register
Should be no batches
2. Ensure no future batches
Report tab next per to 12-9999
Ensure no batches to, say, 1-3008
3. Post all batches in GL.
GL Post transactions screen
4. GL Account 21000 Balance
GL Trial Balance
5. Non-A/P entries 21000 (add credits, subtract debits)
GL Detail General Ledger
***Adjusted GL Balance
6. Vendor totals Balance
Vendor Period Trial Bal or Per Sens’ve Aged AP
APDOC.APACCT = 21000
$_________________ Should equal Adj GL balance above. If not, follow steps 7-11
7. Ensure no mis-posted voucher credit items
APTRAN.TRANTYPE In VO,AC (and) APTRAN.ACCT = 21000
Should be no entries->debit col. should be 0.00
- DR $_________________
8. Ensure no mis-posted voucher debit items
APTRAN.TRANTYPE In VO,AC (and) APTRAN.ACCT <> 21000
Should be no entries->credit col. should be 0.00
+ CR $_________________
9. Ensure no mis-posted AD/CK debit items
APTRAN.TRANTYPE In HC,CK,AD (and) APTRAN.ACCT = 21000
10. Ensure no mis-posted AD/CK credit items
APTRAN.TRANTYPE In HC,CK,AD (and) APTRAN.ACCT <> 21000
11. Subtract Prepayments
APTRAN.Trantype = PP and APTRAN.ACCT = 21000
$________________ ( subtract this...the Per rpts do not include these because they assume a different account for prepays. If you use the same account, then this will affect the total)
let me know if you have questions about it. (if you paste it back into Word, it might look better)
Thank you both for your help, much appreciated!
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics