Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Microsoft Dynamics GP10.0 Financial Summary Inquiry showing zero balances period after posting sales transaction

Posted on by Microsoft Employee

I'm trying to check my posted sales in the financial summary inquiry but it shows zero balances. Currently, I'm using Microsoft Dynamics GP 10.0. How this happened and what is the cause of this problem? How am I able to solve this issue?

financial-summary-inquiry-gp10.jpg

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP10.0 Financial Summary Inquiry showing zero balances period after posting sales transaction

    Hi Jeffrey,

    I'll check this out, I think this is the solution to my problem. Thanks a ton for the quick response and in all the knowledge you share.

  • Verified answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Microsoft Dynamics GP10.0 Financial Summary Inquiry showing zero balances period after posting sales transaction

    Hi Ken

    First check your Receivables subledger, not sure if you entered, via transaction entry, invoice entry or Sales Order Processing transaction entry.

    Make sure that your transaction in the subledger is posted.

    Verify that by running a quick AR Aged Trial Balance

    If you entered the transactions in a batch and had your posting settings set to post through the GL, you should now be able to see transactions in the GL

    If you don't see transactions, go to

    Microsoft Dynamics GP > tools > routines > master posting

    Check to see if any batches show up in the window

    You may need to post these

    If nothing shows up in the Master Posting window, and you don't see the transaction in the GL then there are two more things you can check.

    First Microsoft Dynamics GP > tools > routines > batch recovery

    Are there any batches sitting here waiting to be recovered?

    If not, please check your posting setup

    First Microsoft Dynamics GP > tools > setup > posting > posting

    Select Sales for the series and for Origin select the type of sales transaction you entered.

    Is the Post to General Ledger box marked?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP10.0 Financial Summary Inquiry showing zero balances period after posting sales transaction

    Hi Jeffrey

    I checked the detail inquiry but it shows a zero balances also. Just to give you a history, this is happened when I created a new database. And when I checked my journal entry, there are some transactions that is not yet posted, but I noticed that some of my entry shows "no transaction".

  • Suggested answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Microsoft Dynamics GP10.0 Financial Summary Inquiry showing zero balances period after posting sales transaction

    Hi Ken

    Does the transaction show up if you look in the detail inquiry window?

    If it does, then run a reconcile on the GL.

    Tools > Utilities > Financial > Reconcile

    I like to start with the oldest year first and then move one by one to the current year.

    If the transaction is not in the detail inquiry, check your financial batches to ensure that the transaction is not sitting there waiting to be posted or the posting stopped because of a problem such as trying to post to a closed period or posting to an inactive GL account.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans