On the PCAPs, in the commitment section, I need to pull distributions that have "Yes" selected for "Against Commitment". I'd like to do this within the turnover formula but haven't figured out what to name the dimension, if it is even possible. I have tried various other wordings for the Against Commitment dimension but haven't gotten anywhere. This is the formula I currently have:
Do you have a user-defined book setup to track commitments balance?
Was there a user-defined dimension configured in your system to track the "Against Commitment" field?
Feel free to share screenshots of how the transaction looks like.
In previous implementations that I worked on, the commitments balance was tracked in a user-defined journal; in the context of construction companies this is typically done using the process outlined here. The SI.TURNOVER() function works with dimensions and journals/books, and that's how you would pull data related to commitments.
In the context of non-profits it may be different, and I will loop in one of my colleagues who's an expert in Intacct+NFP in case he has additional tips to provide.
We'll be able to get on a call with you as well if needed to help you get the report you need.
Thanks!
0 Votes
H
Harry Lewisposted
2 days ago
Within Intacct, how does this dimension appear?
Is it a pre-defined dimension that has been renamed?
0 Votes
On the PCAPs, in the commitment section, I need to pull distributions that have "Yes" selected for "Against Commitment". I'd like to do this within the turnover formula but haven't figured out what to name the dimension, if it is even possible. I have tried various other wordings for the Against Commitment dimension but haven't gotten anywhere. This is the formula I currently have:
=SI.TURNOVER(Connection,,"3100:3199",ITD_Start_Date,End_Date,Entity,Books,SI.DIMENSIONS(Connection,"customer",$AC$12, "agnst_commit","yes"))
0 Votes
2 Comments
Gabriel Michaud posted 1 day ago
Hi Arthur,
A few questions to better assist you:
Feel free to share screenshots of how the transaction looks like.
In previous implementations that I worked on, the commitments balance was tracked in a user-defined journal; in the context of construction companies this is typically done using the process outlined here. The SI.TURNOVER() function works with dimensions and journals/books, and that's how you would pull data related to commitments.
In the context of non-profits it may be different, and I will loop in one of my colleagues who's an expert in Intacct+NFP in case he has additional tips to provide.
We'll be able to get on a call with you as well if needed to help you get the report you need.
Thanks!
0 Votes
Harry Lewis posted 2 days ago
Within Intacct, how does this dimension appear?
Is it a pre-defined dimension that has been renamed?
e.g.,
or is it a user-defined (custom) dimension?
0 Votes
Login or Sign up to post a comment