Dear Team
Kindly note that our client purchased advanced procurement module for which we still requires customizations to link with standard budget screen. Their process, as attached is as follows:
1. Purchase requisition- where they want a control to check budget and prevent overbudget for all items being purchased and expenses
From the attached screenshot, Transport allowance, for example, had a budget amount of 10000, however, currently there is no control in case the used budget exceeds the budget amount. The restriction should not take place if the utilized amount is within the budget amount e.g. for transport allowance, less than 10000.
2. Purchase order- the purchase order is expected to commit the amount against the budget line set on the budget module screen
3. Billing- once the purchase order is checked against the budget and approved, the user will proceed to receipt and then bill where now the budget will be utilized and decommit budget. From the standard bill screen, this will affect used budget for expenses, however, I had to introduce another field called 'Budget account' for items.
In all the above procurement modules, I had to introduce another field called 'Budget amount' and 'Budget used amount' for items. However, I am facing a challenge to pull these amounts as seen on the budget vs actual report to the respective purchase screens mentioned above.
Requesting your guidance or workaround on how to proceed with same since the client is a non-for-profit organization and requires budget linked to procurement.
Regards.