I hope this message finds you well. I have a quick question regarding the extraction of budget data from Acumatica using Velixo formula. I successfully extracted revenue data using a specific formula, but I'm encountering difficulties with the budget data.
I have uploaded the budget information into Acumatica, and now I'm seeking guidance on how to efficiently pull it into Excel using Velixo formula. If anyone has experience with this or can provide a similar formula to what I used for revenue, I would greatly appreciate your assistance.
It is a simple process and all you need to do change the "Ledger" in your formula from ACTUAL to the Budget Ledger that you are using. (type ledgers in the search bar and view them in Acumatica if you are unsure of the name)
Good thing to note on the Budget ledgers is you can have multiple Ledgers setup so that if you are doing forecasting (say quarterly), you then add your forecasts to those ledgers say, BUDGET is your agreed budgets and then FCSTQ1, FCSTQ2, etc
Chris
1 Votes
4 Comments
Sorted by
D
Dhiraj Sharmaposted
9 months ago
It worked. Thank you.
0 Votes
C
Chris Millarposted
9 months ago
Admin
Hi Dhiraj
Not sure what I am missing here but we pull out budget data all the time.
Attached are two screenshots in a Current Month/YTD report. The first is from the ACTUAL Ledger turnover, the second is from the Budget ledger also using the Turnover function. I am sure you are correct and I think I may learn something here. You say that using the ACCOUNTTURNOVER function on the budget ledger does not work just because its an integer - it should return the integer.
(Note that in the example we use named ranges for many items that are used time and again)
hi Chris, I wish it was that easy, to get the Actual revenue we use "ACCOUNTTURNOVER" any changing the Actual to Budget it doesn't work because it is not a ACCOUNTTURNOVER number. As per the Velixo support team, they do not have this feature as of now.
0 Votes
C
Chris Millarposted
9 months ago
AdminAnswer
Hi Dhiraj
It is a simple process and all you need to do change the "Ledger" in your formula from ACTUAL to the Budget Ledger that you are using. (type ledgers in the search bar and view them in Acumatica if you are unsure of the name)
Good thing to note on the Budget ledgers is you can have multiple Ledgers setup so that if you are doing forecasting (say quarterly), you then add your forecasts to those ledgers say, BUDGET is your agreed budgets and then FCSTQ1, FCSTQ2, etc
0 Votes
Hello community members,
I hope this message finds you well. I have a quick question regarding the extraction of budget data from Acumatica using Velixo formula. I successfully extracted revenue data using a specific formula, but I'm encountering difficulties with the budget data.
I have uploaded the budget information into Acumatica, and now I'm seeking guidance on how to efficiently pull it into Excel using Velixo formula. If anyone has experience with this or can provide a similar formula to what I used for revenue, I would greatly appreciate your assistance.
Thank you in advance for your help!
Regards,
Dhiraj
Attachments (1)
Screenshot 2....png
13.4 KB
0 Votes
Chris Millar posted 9 months ago Admin Best Answer
Hi Dhiraj
It is a simple process and all you need to do change the "Ledger" in your formula from ACTUAL to the Budget Ledger that you are using. (type ledgers in the search bar and view them in Acumatica if you are unsure of the name)
Good thing to note on the Budget ledgers is you can have multiple Ledgers setup so that if you are doing forecasting (say quarterly), you then add your forecasts to those ledgers say, BUDGET is your agreed budgets and then FCSTQ1, FCSTQ2, etc
Chris
1 Votes
4 Comments
Dhiraj Sharma posted 9 months ago
It worked. Thank you.
0 Votes
Chris Millar posted 9 months ago Admin
Hi Dhiraj
Not sure what I am missing here but we pull out budget data all the time.
Attached are two screenshots in a Current Month/YTD report. The first is from the ACTUAL Ledger turnover, the second is from the Budget ledger also using the Turnover function. I am sure you are correct and I think I may learn something here. You say that using the ACCOUNTTURNOVER function on the budget ledger does not work just because its an integer - it should return the integer.
(Note that in the example we use named ranges for many items that are used time and again)
Attachments (2)
Screenshot 2....png
15.3 KB
Screenshot 2....png
13.9 KB
0 Votes
Dhiraj Sharma posted 9 months ago
hi Chris,
I wish it was that easy, to get the Actual revenue we use "ACCOUNTTURNOVER" any changing the Actual to Budget it doesn't work because it is not a ACCOUNTTURNOVER number.
As per the Velixo support team, they do not have this feature as of now.
0 Votes
Chris Millar posted 9 months ago Admin Answer
Hi Dhiraj
It is a simple process and all you need to do change the "Ledger" in your formula from ACTUAL to the Budget Ledger that you are using. (type ledgers in the search bar and view them in Acumatica if you are unsure of the name)
Good thing to note on the Budget ledgers is you can have multiple Ledgers setup so that if you are doing forecasting (say quarterly), you then add your forecasts to those ledgers say, BUDGET is your agreed budgets and then FCSTQ1, FCSTQ2, etc
Chris
1 Votes
Login or Sign up to post a comment