You’re offline. This is a read only version of the page.
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
Victoria,
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.
Srinivas
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.
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?
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.
Ian,
I added all the other Originating columns in the smartlist. They are blank.
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.
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.
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.
I cannot click on the source document hyperlink. The link is disabled.
i am logged in as system administrator.
I cannot click on the source document hyperlink. It is disabled.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (