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 helpSrinivas
In the Transaction Entry window click the Source Document hyperlink to drill down.
I cannot click on the source document hyperlink. It is disabled.
I cannot click on the source document hyperlink. The link is disabled.
i am logged in as system administrator.
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.
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.
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.
I added all the other Originating columns in the smartlist. They are blank.
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.
Victoria Yudin - Dynamics GP MVP (2005-2013)
Want to use Crystal Reports or SSRS with Dynamics GP? Check out GP Reports Viewer
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?
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.
Sorry for delayed reply. I was not in the office past few days.
Thanks a lot your support. I will check with the concerned departments and get back to you.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13