GL Account - Ongoing Snapshot of Transaction History with Running Balance?
Hello All,
Reaching out to see if anyone has ideas on how to build out a client request I received today.
Below I will outline the request and the idea I have on how to perform it. If anyone has done this before, or has ideas on how to do this, it would be greatly appreciated.
Request Details:
- Object - General Ledger Account
- GL Account Type/Sub Type - Balance Sheet/Assets
- NOT a bank account
- Related List - Transaction
The client is looking to add a column that contains the GL Account balance after EVERY transaction is performed. So, if the balance is $100 Monday morning, and there is:
- A transaction at 12pm Monday that would increase the balance by $5
- Another transaction that would increase it by $10 at 4PM Monday, and
- Another transaction that would decrease it by $2 at 11AM Tuesday
they would want to see the normal transaction related list layout with one additional column that contains the balance after each of transactions. Based on my example above, this column would contain the following balances right when the transaction occurs:
- Balance Monday at noon = $105
- Balance Monday at 4PM = $115
- Balance Tuesday at 11AM = $113 (please note, if this is the most recent transaction, this would also be the current balance of the GL Account)
I was thinking I could create a snapshot object with a flow that would kick off each time a transaction occurs that grabs the current balance, calculates the new balance based on the transaction and store it in the new column. It's pretty much balance history because we want the balance at the point in time to stay with the transaction. The most current transactions balance would be the current balance.
Has anyone else ever done something similar? Does anyone have a different/more efficient idea on how to build this out? Any ideas, formulas, field types, recommendations etc. are welcomed!
Happy to provide additional detail if needed.
Thank you!
-Stefanie
-
Hello All!
Casting the rod back out to see if anything bites. See original post for full detail. Looking for ideas on tracking a balance over time for a bank GL Account. I don't technically need a running balance, however, the running/current balance will always be the last value in the column.
Ultimately, we're looking to display the balance immediately following each transaction as a single point in time. Short example - If I have a GL Account with $100 in it, and I add $20 on Monday, and another $5 on Tuesday, the row for Monday will have a snapshot balance of $120 and the row for Tuesday will have a snapshot balance of $125. Monday's balance shouldn't change.
As mentioned, there's much greater detail in my original post. My current idea is to use snapshot in SF. If anyone has done something like this, or has an idea on how to do it, please let me know.
Thank you!
-Stefanie M
Please sign in to leave a comment.
Comments
1 comment