web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Debtors Nominal Differ...
Microsoft Dynamics GP (Archived)

Debtors Nominal Difference to Debtor Listing

(0) ShareShare
ReportReport
Posted on by Community Member

I have a difference on between my debtors nominal and my debtors code - I have been searching for an age for it trying to narrow down what date the transaction occured. My debtors reconciled every period from 1-8 and now in period 9 I am out by approx 10k. Every period is now out approx 10k as far back as the very first day of my financial period. I can't understand how this happened.

I am now trying to print of a TB from previous year which I can't figure out how to do it so I can get back to a time when the nominal matched the debtor listing.

HELP!!!!!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    I'm in the US and we use different words. But I'll give this a shot. Are you trying to balance your accounts payable with the general ledger? If yes, to print the previous year for your accounts payable, you need to print the Historical Aged Trial Balance. In this report you can enter a date and it will print the information as it appeared on that date. If you are using GP 2010 or later, there is a Reconcile to GL routine in the Financial module that will automatically compare your GL with the subsidiary ledger and tell you which transaction is creating the 10K difference. If I have totally misunderstood your question, I apologize for this post.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at

    Thanks Leslie,

    I have seen the function to reconcile but I am unsure how to use it - can you point me in the right direction for some easy steps to do this?

  • L Vail Profile Picture
    L Vail 65,271 on at

    It's in the Financial Routines area. It's called Reconcile to GL. Open it up and. There's a drop-down box mid-way down the window, make sure it says Payables Management. On the upper right hand quadrant is where you put all of the GL accounts that, added together, are supposed to balance with your payables trial balance. If you keep track of prompt pay discounts in a different GL account, be sure to include that account on the list. In the From and To boxes you enter the date range of transactions you want it to analyze. Normally the first date is the date it last balanced and the end date is when it became out of balance. You could just enter the current date if you don't have a zillion transactions.

    Hit Process when you've got it all filled out. The reconciliation routine will compare the subledger to the general ledger and generate an Excel spreadsheet. The spread sheet will show what doesn't exist it both (doesn't match) what is potentially a match and what for sure matches. I'd focus on the unmatched and potentially matched entries and ignore the matched entry.

    Kind regards

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans