Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Thomas Hill]

I have been told the only dumb question is the ONE not asked.

I am working in a new database we have.   For now, it is Cash Accounting.  I entered my batch for the month of January.  I should have had two invoices for one vendor open on the Trial Balance, the only ones to post to AP Trade.  The others posted to cash/check directly through input.  

My ageing prints for all vendors.  The options for selecting Exclude ZERO AMOUNTS are grayed out.  How do I get them?

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————

[Jo deRuiter]

?Hi

You need to print the Aged Trial Balance with Options or the Historical Aged Trial Balance?:

——————————
Regards,

Jo deRuiter
“That GP Red Head”
Senior Financial Systems Consultant
Heartland Business Systems, LLC
Eau Claire WI
770-906-4504 (Work)
770-906-4504 (Cell)
——————————
——————————————-

[Teri Carpenter]

?Make sure you select the Aged Trial Balance with options.    The Aged trial balance has no filters and is really only good for selecting a specific vendor to print all details.

——————————
Teri Carpenter
President
TD Carpenter & Associates, Inc.
Toledo OH
——————————
——————————————-

[Thomas Hill]

Thanks for the assistance.

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————
——————————————-

[Brook Newton]

I have experienced some issues with the GP historical trial balance myself.   The aged trial balance is great for a snapshot, but I have found that if you run the historical you may not have an accurate trial balance.  As historical trial balances are how you tie out month end, I was wondering if anyone had a work around for this issue?

——————————
Brook Newton
Ideal System Solutions, Inc.
Pequot Lakes MN
——————————
——————————————-

[Power Hely]

There are two out of the box Jet Reports Express Reports (GP034 Profit and Loss Statement and GP057 Month End Trial Balance) that I love. They are prebuilt, free, easy to use, free, built for slicing, and , oh yeah, free. Even our outside accountants approve.

——————————
Power Hely
VP of Operations
Hely & Weber
Santa Paula CA
——————————
——————————————-

[Erica Howlett]

With the Historical Aged TB; there are options for doc date, or post by GL date.  Depending on how your settings are in posting setup, your GL posted date may be forced by your doc date.  It doesn’t seem as if that is turned on and can throw off your balances from subledger to GL.   Please ping me with any questions.  I can jump in and take a quick look-see and we can go from there. 

Also; try running a backup; run checklinks; run reconcile.  Let’s see if anything comes out to see if there is a bigger issue.

——————————
Erica Howlett

——————————
——————————————-