#65187 - 11/24/20 07:03 AM
PO - budgeting features
|
Adagio Maestro
Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
|
An existing Adagio client with several modules is asking bout the PO module (which they do not run yet). I understand that the PO module does offer Event Budgets, but I am not certain if it allows the following:
1. If we enter budget amounts to GL accounts, can we get the PO module to halt or reject an entry if the amount will cause the GL account to go over their specific budget limit?
2. Upon entering a PO can we report on costs-to-be to GL accounts before the PO is received or invoiced?
_________________________
Samuel Kopstick S Kopstick & Associates Inc Toronto, ON
|
Top
|
|
|
|
#65188 - 11/24/20 08:11 AM
Re: PO - budgeting features
[Re: Samuel Kopstick]
|
Adagio God
Registered: 03/10/02
Posts: 4512
Loc: Wynnewood, PA
|
Hi Samuel
I don't know much about Event Budgets (I don't think anyone does), but I can almost guarantee you that they are not the solution you are looking for.
However, there is a solution, and it has to do with JobCost. PO can flag an entry that would cause the amount to exceed the Job Estimate in JobCost.
So to get where you want to be (assuming you are not using JobCost for any other purpose), you would create one new job each fiscal year, and give it Phases/Categories that correspond to the GL Accounts/Departments, with the budget amount entered as the estimate. You would then code the PO detail lines to the correct Job (fiscal year), Phase (account), and Category (department).
I hope this makes sense. It's a bit of a workaround, but it does work.
Steve
|
Top
|
|
|
|
#65189 - 11/24/20 08:54 AM
Re: PO - budgeting features
[Re: Steve Schwartz]
|
Adagio Maestro
Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
|
Hi Sam,
The answer to your first question is no. Event budgets have to be setup separately in Purchase Orders and are not dynamically linked to the GL. But you can retrieve GL budgets into Purchase Orders and then PO can be set to block purchases if it's over the "event" budget which tracks the GL totals. The problem is that if you make changes to the budgets in the GL, event budgets won't know about the change in budget unless you retrieve them in PO.
As for your second question, it sounds like you're trying to do encumbrance accounting. There is a workaround for it, but it's not easy to setup and requires PO, Gridview, provisional posting and FX.
_________________________
Dan Desautels DezTek Solutions Inc. Thunder Bay, ON
|
Top
|
|
|
|
#65190 - 11/24/20 09:05 AM
Re: PO - budgeting features
[Re: Dan_Desautels]
|
Adagio Maestro
Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
|
Steve & Dan:
I appreciate your expertise and weighing in on this topic to let me know what may be involved here. Thank you!
_________________________
Samuel Kopstick S Kopstick & Associates Inc Toronto, ON
|
Top
|
|
|
|
#65191 - 11/24/20 10:01 AM
Re: PO - budgeting features
[Re: Samuel Kopstick]
|
Terry
Registered: 06/25/02
Posts: 276
Loc: Campbell River, BC
|
Hi Samuel,
If the client has not yet purchased Adagio Purchase orders, you could look at POTracker.
POTracker can make direct use of the Ledger budgets to prevent or warn if the budget in ledger would be exceeded by a new PO including current outstanding purchase orders.
The user can be assigned departments that they can use when creating purchase orders and they can only view PO's that have been created for those departments.
Give me a call if you would like to see an online overview or download a demo version of the program.
_________________________
Terry IMS Island Microsystems Ltd 250 287-9874 terry@islandmicro.com www.islandmicro.comIMS Applications: CounterSales . JobTracker . POTracker . LabelPrint . LotTracker . SerialTracker . IMScheduler . ReportGen JobTracker can now use ServiceTracker to track jobs performed on Equipment and Machines. Call for more information on our applications or to arrange a Demo.
|
Top
|
|
|
|
#65847 - 03/25/21 01:13 PM
Re: PO - budgeting features
[Re: Terry Pennock]
|
Adagio Maestro
Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
|
Revisiting this topic. There is a Show-Me video on Event Budgets for PO. Based on the video, I was able to copy the GL budget amounts for various GL Account-Dept’s over to the PO. In the Company Profile, I set the system to not permit posting when we go over budget. I have managed to do this in PO and it appears to work.
And you are correct, Dan. If we adjust the budget amounts in the GL, then yes, we have to re-import the GL budget values into PO. Otherwise, the incorrect pre-adjusted values remain unchanged in the PO module.
Here is one question that I am unsure about: What happens when the new fiscal year starts up? Is it possible to get the PO Events to adjust to the new year, and start counting all over again?
_________________________
Samuel Kopstick S Kopstick & Associates Inc Toronto, ON
|
Top
|
|
|
|
#65854 - 03/26/21 05:46 AM
Re: PO - budgeting features
[Re: Samuel Kopstick]
|
Adagio Maestro
Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
|
Hi Sam,
If you create the Next Fiscal Year in GL, nothing changes in PO Event budgets. They have no ability to differentiate fiscal years. The GL retrieve only looks at the current fiscal year. So you would have to finish off your current year and run the maintenance>close in GL before you can retrieve the budgets from the new year (which would then be the current year). And since the "Amount spent" is retrieved from GL in that process, it would reset to the balance of the GL account retrieved. The Amount committed, still reads your open PO's. So the issue is that you won't be checking against the next year budgets if you create PO's with a next fiscal year date while the current year is still open in GL.
_________________________
Dan Desautels DezTek Solutions Inc. Thunder Bay, ON
|
Top
|
|
|
|
#65872 - 03/30/21 06:49 AM
Re: PO - budgeting features
[Re: Steve Schwartz]
|
Adagio Maestro
Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
|
Thanks to all you for your input. I agree - the PO Event Tracking just does not appear to be able to handle the task of managing budget amounts, especially when considering different fiscal years. Too bad.
Steve, your solution of using JobCosting with PO is nice, and I see that it will work over fiscal years as well.
The issue that I am concerned about is that the users for this application are not Adagio power users. If there are a number of rules and steps that have to be performed from time to time, I am concerned that they may get messed up. For example, every time that they would adjust the Budget values in the GL (which I know will happen), they would have to reimport or update the values in the accompanying JC Estimates.
_________________________
Samuel Kopstick S Kopstick & Associates Inc Toronto, ON
|
Top
|
|
|
|
|
0 registered (),
54
Guests and
0
Spiders online. |
Key:
Admin,
Global Mod,
Mod
|
|
1865 Members
5 Forums
14473 Topics
70688 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
31
|
|
|