You’re offline. This is a read only version of the page.
I am trying to tie the GenralJournalAccountEntry transactions back to the original transactions. While I've tried to start with individual modules e.g. Projects, Vendors etc, I'm wondering if there is a recommended or easy way to go about this as opposed to what I am doing. Wondering if there is already a pre-built entity or table that has all this data brought together.
As an example, in the case below, I have 2 tables
1. Has some basic information from GeneralJournalAccountEntry and GeneralJournalEntry
2. Has similar information from ProjectTrans with the addition of the Project ID.
I can visually see that the 3 GL transactions can be tied back to the Project Transactions based on Voucher and Cost Center ID below but I'm not certain if that is the ideal or correct way to tie these 2 datasets together.
Is there a better approach to this?
The primary business requirement was just to be able to identify if any transactions that are actually project related have been posted directly to the cost center that the project is associated to instead of the project itself. These incorrect postings are basically causing cost center based reporting and project based reporting to not tie out.
The above requirement is reasonably addressed through the posting type field itself so we are good. I just thought that there's a way to actually uniquely tie the 2 together that I just couldn't figure out, which is why I thought I'd ask here.
Now that you've indicated that it is technically not supposed to be a unique link, I will stop pursuing that.
Thanks a lot for your inputs.
HI Vicky,
Thanks for the clarification. The Cost Center ID might not be unique. In that case, you can again get many to many. In this case, there is no unique link. Can you tell about the business requirement? Maybe there is another solution direction possible.
In my example screenshot above, if I were to tie it based on just Voucher and Accounting Date, it will create a many to many join as all 3 GeneralJournalAccountEntry transactions will tie to all 3 Project Transactions given the voucher and date are the same on all 3.
My hope is that I will be able to tie each GeneralJournalAccountEntry transaction that uniquely to one or more Project Transactions that in aggregate match the GeneralJournalAccountEntry transaction amount.
In my example above, adding the Cost Center ID to the linkage would help achieve that but I'm not 100% sure that is the right approach or not.
Hi Vicky,
On the voucher transaction form, which is using the GeneralJournalAccountEntry details, there is an option to view the origin. In most of the cases, you can link on the Voucher and Accounting Date/LedgerTransDate. Based on settings (summarize postings), the voucher might not always be filled on the GeneralJournalAccountEntry table.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (