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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to trace the sourc...
Microsoft Dynamics GP (Archived)

How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

(0) ShareShare
ReportReport
Posted on by Srinivas Polisetti 110

Hi

I am new to GP.

I am facing a problem in financial module. I wanted to track a document source. Following is the problem:

We are using GP 10.

In Financials > Transactions > General i see one journal entry with document no is 199261. In the source document field it is showing ‘GJ’ and in the reference is showing INVRCT-2012/013250′ The batch is showing ‘GLTRX015675′

We wanted to know from which module this Journal is created and wanted to trace the source of this document. I suspect this came from inventory module, but i want to see the originating transaction.

Appreciate your help
Srinivas

*This post is locked for comments

I have the same question (0)
  • Ian Grieve Profile Picture
    Ian Grieve 22,784 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    In the Transaction Entry window click the Source Document hyperlink to drill down.

  • Srinivas Polisetti Profile Picture
    Srinivas Polisetti 110 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    I cannot click on the source document hyperlink.  It is disabled.

  • Srinivas Polisetti Profile Picture
    Srinivas Polisetti 110 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    I cannot click on the source document hyperlink.  The link is disabled.

    i am logged in as system administrator.

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,784 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    Sorry, I was thinking of the Transaction Zoom window when I mentioned the Source Doc hyperlink.

    If you open SmartList and use the Financial >> Account Transactions SmartList you should be able to add the column Series and see where the transaction originated.

  • Srinivas Polisetti Profile Picture
    Srinivas Polisetti 110 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    Hi Ian

    The series is showing 'Inventory' and the source doucment is showing 'GJ'.

    The users are saying that they did not post such transaction in Inventory.  So we dont know from where this transaction is posted to GL. We have Purchasing, inventory and field service modules which are operational.

  • Ian Grieve Profile Picture
    Ian Grieve 22,784 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    An inventory transaction would generally have a Source Document which begins with IV and would not be a GJ.

    In the Account Transactions SmartList there are several columns starting Originating... which show information for the transaction the journal originated from. Adding these to the SmartList may get more information as to the source transaction.

  • Srinivas Polisetti Profile Picture
    Srinivas Polisetti 110 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    Ian,

    I added all the other Originating columns in the smartlist. They are blank.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    Srinivas,

    This type of transaction is typically generated when you enter a POP invoice and match it to a POP receipt with a cost that is different.  So for example, you received qty 1000 of an item with a cost of $5.00 each, but when you match the receipt to the invoice, the unit cost is actually $5.10.  If you have already sold the inventory, or part of it, GP automatically creates a GL entry to record the difference.  Usually the reference will help identify the originating transaction - I would search for Receivings Transactions (Under Purchasing SmartLists)  with a POP Receipt  Number containing 013250 to find this.

  • Srinivas Polisetti Profile Picture
    Srinivas Polisetti 110 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    Victoria,

    I checked the Receiving transations (smart list) and found 1 record with POP Receipt Number 013250. The value for this transaction is 900  KD (Kuwaiti Dinar) and the values in the Journal Entry (199261)  which i refered above is KD 8,813,933.358.

    Is it possible that this is one transaction in created in GL for many such transactions (with different price) matched between POP receipt and invoice?  So if that is the case how can i know to which receipts and invoices transactions this Journal entry is related?

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: How to trace the source documents in GL ( created / posted from other modules like purchasing / inventory)

    Srinivas,

    Take a look at this KB article: support.microsoft.com/.../2448193

    According to this, your entry came from an inventory transaction.  Hopefully this will help you track it down.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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