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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Non-Inv Items posted t...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Non-Inv Items posted to the wrong GL

(2) ShareShare
ReportReport
Posted on by CU03032159-0
I believe there is an issue with Non-Inv items' costs being applied to the wrong GLs. Is there a way to view all purchasing line items, receipts, class code, and the GLs they actually hit. All I can find is there assigned GLs. Bonus points if it is a Smartlist. 
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri Super User 2025 Season 2 on at

    Reviewing Non-Inventory Item Postings to the Wrong GL in Dynamics 365 Finance

    To investigate and correct non-inventory (Non-Inv) items being posted to the wrong General Ledger (GL) accounts, you need to review purchasing transactions, receipts, item class codes, and actual GL postings.

    Option 1: Use the "Voucher Transactions" Inquiry (Best for GL Analysis)

    1. Navigate to:
      • General ledger > Inquiries and reports > Voucher transactions
    2. Filter for Non-Inventory Items:
      • Add a filter where Item Type = Non-Inventory
      • Include relevant dimensions such as vendor, posting date, and GL accounts
    3. Review the Actual GL Posting:
      • Compare expected GL accounts (from item posting setup) to the actual accounts used.

    Option 2: Use the "Purchase Order Line Transactions" Inquiry (Best for Line-Level Details)

    1. Navigate to:
      • Accounts Payable > Inquiries and reports > Purchase order line transactions
    2. Customize the Inquiry:
      • Add columns for Item Class, Account Type, GL Posting, and Receipt Status
    3. Export to Excel for deeper analysis.

    Option 3: Create a SmartList (If Using Dynamics GP, Not D365 Finance)

    If you're using Dynamics GP, a SmartList can help:

    1. Go to SmartList:
      • Navigate to Purchasing > SmartList
    2. Choose the "Purchasing Line Items" View
      • Add columns: Item Number, Description, Class ID, Vendor, Receipt Status, GL Account, and Posting Date
    3. Export & Review the Data.

    Bonus: Fixing Incorrect GL Postings

    • If incorrect GL accounts are being used, check:
      1. Item Posting Setup: (Inventory management > Setup > Posting > Item posting)
      2. Procurement Categories & Posting Rules: (Procurement and sourcing > Setup > Policies)
      3. Account Structures & Financial Dimensions.
    • Use General Ledger > Voucher Transactions to make manual adjustments if needed.
  • Martin Dráb Profile Picture
    Martin Dráb Most Valuable Professional on at
    Saif, you've generated a suggested answer for a wrong product. The category of this thread is Microsoft Dynamics GP.
  • Devon Southall Profile Picture
    Devon Southall on at
    Ugh - the Receivings Line Items smartlist does NOT have the GL account.      WE could do this in SQL... is that an option?  you could add in designer or builder...    
     
    I was just working on this for a customer and I have PO lines but could revised that to use Receiving lines instead... 
     
    let me know...
    Best,
    Devon
  • CU03032159-0 Profile Picture
    CU03032159-0 on at
    I don't believe I personally have access to SQL. I was trying to figure out how to do it under the company tab in the designer/builder but couldn't figure it out. 
  • Suggested answer
    Devon Southall Profile Picture
    Devon Southall on at
    Talk to IT or your GP partner... you are going to need a custom SQL view -- then you can connect to that view in SmartList Designer.  If you have builder we can give you more assistance.   Do you know the difference between them?
     
  • CU03032159-0 Profile Picture
    CU03032159-0 on at
    I do have access to builder!
  • CU03032159-0 Profile Picture
    CU03032159-0 on at
    I do have access to builder and no I do not know the difference. I have only been working with GP for about 6 months. 

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

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 > Finance | Project Operations, Human Resources, AX, GP, SL

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans