Topic Options
#65187 - 11/24/20 07:03 AM PO - budgeting features
Samuel Kopstick Offline
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]
Steve Schwartz Offline
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]
Dan_Desautels Offline
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]
Samuel Kopstick Offline
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 Pennock Offline
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.com

IMS 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]
Samuel Kopstick Offline
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]
Dan_Desautels Offline
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
#65858 - 03/26/21 02:57 PM Re: PO - budgeting features [Re: Dan_Desautels]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1738
Loc: Waterloo, Ontario, Canada
Hi Sam,
As Dan has stated, there are issues with Event Tracking in PO's. We created the PO product as Purchase Orders for Adagio and could not get the Event Tracker to work properly with GL budgets.

The issue was specific to crossing over fiscal years. To be clear, we did the product design and we will not use PO Event Tracking for any of our clients.

We have a solution that we have installed for encumbrance accounting, that can do either soft or hard encumbrance accounting, that considers the PO module integrated with FX and Gridview and is quite a solution.

Best,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#65859 - 03/26/21 03:33 PM Re: PO - budgeting features [Re: Brian Stief]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4512
Loc: Wynnewood, PA
Hi Samuel

As I mentioned to you over the phone, a way around the fiscal year issue is to use Job Costing to handle the “budgets” as estimates. The job would be the account, the phase the department, and the category the fiscal year.

It has the same ability to check that you are not entering a PO that would cause the budget to be exceeded.

Steve

Top
#65872 - 03/30/21 06:49 AM Re: PO - budgeting features [Re: Steve Schwartz]
Samuel Kopstick Offline
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


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 56 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14474 Topics
70689 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
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