Skip to main content

Notifications

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

(1) 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
  • CU03032159-0 Profile Picture
    CU03032159-0 on at
    Non-Inv Items posted to the wrong GL
    I do have access to builder!
  • Suggested answer
    Devon Southall Profile Picture
    Devon Southall on at
    Non-Inv Items posted to the wrong GL
    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
    Non-Inv Items posted to the wrong GL
    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. 
  • Devon Southall Profile Picture
    Devon Southall on at
    Non-Inv Items posted to the wrong GL
    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
  • Martin Dráb Profile Picture
    Martin Dráb Most Valuable Professional on at
    Non-Inv Items posted to the wrong GL
    Saif, you've generated a suggested answer for a wrong product. The category of this thread is Microsoft Dynamics GP.
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri Super User 2025 Season 1 on at
    Non-Inv Items posted to the wrong GL

    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans