Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Great Plains 7.0 A/R Historical Aged Trial Balance (HATB)

Status
Not open for further replies.
r2p2s3

r2p2s3

Technical User
Nov 14, 2003
18
CA
We are a Windows 2003 SQL installation.
We continue to have issues with balancing our G/L A/R control account to the A/R Historical Aged Trial Balance. Might someone have information as to what the query is that produces the A/R Historical Aged Trial Balance? By reviewing the query we hope to identify which tables and how the report is generated and thus reconcile our totals.
 
Sort by date Sort by votes
If you are reconciling A/R detail to general ledger and sometimes have document dates that are different from GL Posting dates, make sure you are selecting to generate the report using GL Posting date.
 
Upvote 0 Downvote
Thank you. The GL posting date is selected.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kgeorge71
  • Locked
  • Question
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
1K
kgeorge71
kgeorge71
Nisly
  • Locked
  • Question
Deleting purchases from Fixed Assets Purchases in Great Plains
Replies
0
Views
839
Nisly
Nisly
appelq
  • Locked
  • Question
Receivables Batch Print the edit list is not working for an imported Cash receipts batch
Replies
0
Views
785
appelq
appelq
cgFIN
  • Locked
  • Question
Bank Transaction Entry - Transaction vs Receipt - difference?
Replies
0
Views
897
cgFIN
cgFIN
appelq
  • Locked
  • Question
Cash Batch and Bank Fees in Dynamics GP
Replies
0
Views
1K
appelq
appelq

Part and Inventory Search

Sponsor

Back
Top