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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Vendor / Customer / GL Ledgers

(0) ShareShare
ReportReport
Posted on by

Hi

I am not able to view the vendor / customer / General Ledger reports inside GP menus. Can anyone tell me whether it is available as report. Please let me know

 Venkat

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,627 Moderator on at

    They are absolutely in GP as reports Venkat.  Do you get an error message when trying to run them from the menu or do they not appear as menu items at all for you?  I'm guessing it may just be a security setting preventing yiou from seeing them.

  • Community Member Profile Picture
    on at

    Hi Frank

     Thanks for the reply. First of all i am not even seeing any report (even menu) which lists down the Stock, Vendor & Customer Ledger entries inside the Inventory, Purchase or Sales module.

     Can you tell me the Menu Name (For all 3 reports) where it is available?

    Please help me

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,627 Moderator on at

    It sounds like you need a Stock Status report for inventory, which details your on hand inventory and values it based on the valuation method you are using.  The menu path for this report is Reports>Inventory>Activity and you would choose the 'Stock Status' report from the drop down list under 'Reports' in the Inventory Activity Reports window.

    Also, the Accounts Payable Trial Balance lists all open invoices from vendors (Reports>Purchasing>Trial Balance and the Accounts Receivable Trial Balance (Reports>Sales>Trial Balance) lists all open invoices to customers.  Be aware however, that Accounts Receivable does not age automatically as does Accounts Payable.  For Accounts Receivable, you must run the Aging Routine prior to printing the Trial Balance.  You find the Aging Routine under Tools>Routines>Sales>Aging.  You can choose to have the Trial Balance print immediately after the Aging Routine completes or run the report later.

    Hope this helps,

  • Community Member Profile Picture
    on at

    hi Frank

    Thanks for the reply. what i meant as Ledger is that, for a vendor , it will not only list down the open transactions but will list all the Invoices, debit memo, Payments in a single report so that i will be able to view the complete history of all transactions pertaining to a vendor. This is same for Customer too. The Aging will list only the open transactions which will not give me the complete history of transactions that i had done for the customer / vendor

    Regarding Stock ledger for an Item (Which i take between dates), it will list the opening balance of an item (As of start date), Transactions of all Receipts, Transactions of All issues and the closing balance which will be Opening Balance + Receipts - Issues.

    I dont know whether we have any report like this in GP

    Thanks

    Venkat

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,627 Moderator on at

    Venkat,

    I'm sorry, I misunderstood.  You can find the transaction history reports under

    Reports>Inventory>History; Reports>Purchasing>History; and Reports>Sales>History.

    Hope this helps,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March 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