Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans