Armanino Blog
Article

Make Use of the Source Document Field on Journal Entries

November 24, 2009

The Dynamics GP Source Document field is a required field on a General Ledger journal entry but people rarely pay any attention to the field because it defaults to "GJ" for "General Journal", which meets the basic criteria. GJ is certainly acceptable for a General Ledger journal entry but you could expand on that code to make it more meaningful and therefore provide another option for reporting transaction detail. The Source Document field is a field you can place a print/search restriction on for standard GL reports, GL transaction inquiries, and smartlists. Therefore, if you do a number of journal entries for the same purpose/event, you could assign them the same Source Document and then later do a search/print restriction on that specific Source Document code. For example, if you have to do some post year-end close journal entries, you could create/assign a source document of "GJ-PCADJ" for "General Journal – Post Close Adjustment" to those journal entries. Subsequently, you could easily run a smartlist of all the post closing adjustments by doing a search of Source Document = GJ-PCADJ. You can create as many Source Document codes as you like. I recommend that you start each new code with "GJ" in case you should want to run a report/smartlist on all journals that originated in the GL, you could easily pull all those that start with "GJ".

To create a new Source Document code, you can type it into the Source Code field on the Transaction Entry window:

Transaction Entry Source Code field

Dynamics GP will then prompt you to add it:

Transaction Entry Prompt

Enter the appropriate title and click the Save button.

Transaction Entry Source Code Title Save

Please note: If you select/view an un-posted journal entry that has any Source Document other than GJ (for example, CMTRX, PMTRX, PMCHK, RMSLS, etc), do NOT change the source document. These source document codes indicate that the journal entry originated from a subsidiary module and from which subsidiary module. Also, when you are entering a General Ledger journal entry, do NOT use these pre-defined source documents, because that would make your journal entry misleading as to where it originated from. If you are unsure which Source Documents are pre-defined and which ones are custom, you can view the pre-defined ones on the Audit Trails Setup window (Tools>Setup>Posting>Audit Trails).

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
A Deep Dive of Business Valuation Discounts
Webinar
Get expert tips to better estate plans for your clients.

December 5, 2024 | 10:00 AM - 11:00 AM PT
Building Future-Proof Foundations: Insights for Family Offices and Corporate Foundation Managers
Webinar
Gain the tools to navigate the complexities of foundation management.

December 4, 2024 | 10:00 AM - 11:00 AM PT
Year-End Tax Strategies for Businesses
Webinar
Adapting to the New Tax Landscape in 2025

December 3, 2024 | 11:00 AM - 12:00 PM PT