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!

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

How to update Vendor Summary numbers?

Status
Not open for further replies.
May 24, 2006
219
US
We've just gone through some maintenance on our Dynamics GP 10.0 Purchasing system, and now the Purchasing Aged Trial Balance vendor totals don't match the detail printed on the report. The vendor totals are coming from the Vendor Summary records.

We've run Check Links and Reconcile for Purchasing, and both come up empty as if there are no adjustments to be made. It's been my experience that Reconcile updates those Summary numbers based on the Detail records... no?
 
Are you running the historical aged tb? if so, this could be related to how the opening data was bought in. If you stuffed it into the tables and didn't fill in the necessary apply information then the historical TB's wont work.

Otherwise if you haven't bought the data in using the UI and import tools then reconcile will fix summary balances.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top