Notifications
Announcements
No record found.
What's the best way for me to get a report of every single user-entered and hand-keyed Journal Entry for a particular date range? Please advise. Thanks in advance!
*This post is locked for comments
Go to Tools-->SmartList and expand Financial--.Account Trasaction then click the * symbol to set filter for Transaction Date to view the report.
You also view the same from GL Trail Balance Report(Report-->Financial-->Trail Balance).
Hope this helps!!!
Won't that also give me system generated Journal Entries too, though? I want to see only the items that were hand-keyed (aka entered by hand by an end user).
When I look for hand keyed, I use the Cross Reference report and look for source document GJ which is the default source document. It may not be perfect (as users could change the source document), but would be a good place to start.
Dan Liebl, CMA CPIM | Senior Consultant | OTT, Inc.| DLiebl@OTT-inc.com
Yes, that might end up with an incomplete report. This is a request coming from an auditor. So... still hoping SOMA can address my concerns with his solution.
Set the below filter condition to your Account Transaction SmartList.
I don't believe you could end up with this requirement being fully fulfilled from Dynamics GP out of the box reports and smart lists, the Account Transaction smart lists shows all the journal entries affecting all the accounts as derived from all modules (either hand keyed or automatically generated from associated module) You do need to customize a script to retrieve the orphan records affecting General Ledger directly which doesn't have originating documents in the associated module.
I have previously worked on several scripts to match SOP, IV, POP transactions with general ledger details. You could consider simple modifications for these scripts to retrieve General Ledger Journals affecting GL with no originating module transaction along with the user who hand-keyed the JE.
Inventory module and General Ledger
POP module and General Ledger
SOP module and General Ledger
Your feedback is highly appreciated,
SOMA - in your screenprint, is that a "pipe" symbol in search section 4? Also - won't this show, as MAHMOUD said, "all the journal entries affecting all the accounts as derived from all modules (either hand keyed or automatically generated from associated module)"? Because if so, that is more than we want...
Mouse cursor is showing in the search box 4 in the screenshot. Please ignore it.
I understood what mahmoud said. But the journal entries are affected with all the accounts with appropriate modules numbers (series- finance, sales, purchase,etc.,). If user create a journal entry from General Transaction Screen without originated from any modules, the values stored to the account transaction tables is "series = 2 , originating control and transaction number is empty". I hope you can get the user entered account transaction from smartlist with the above mentioned filter(This filter will not consider the JE with originated from any other modules except GL).
Please let me know if you need any helps regarding the same.
Soma
Glad to hear from you again,
The point I wanted to make precisely is distinguishing between the transaction posted on the General Ledger directly and the transactions hand-keyed by the user on the General Ledger level. Apparently, there is a slight difference between the two, but it is crucial .
The solution you've provided will retrieve the journal entries posted on the General Ledger directly, but not necessarily hand-keyed by the user. A very simple example, cost adjustment documents which are generated automatically by the system in cases such as (enter match, override shortage with inventory replenishment ...etc) . Cost Adjustment documents are set to "Financial" series, but have neither originating control number, originating document number nor originating master number. For instance, check the following case.
As illustrated below, the journal entry is automatically generated by the system, but still has a series of "Financial" and no originating root.
Now, back to the requirement stated in this question. How to get the Journal Entries which are only hand-keyed by the user on the General Ledger level ? If we are looking for a trusted set of result, we should track back these journal entries (which are categorized under the financial series) in the originating module,
Mahmoud,
Can you run your second query with adding column series? Because I have tried this, it is showing series as 5(Inventory)?
Your reply is much appreciated.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
