Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Validate Invoice Entry against Job Budgets (P/L only)

Datafile Software

Validate Invoice Entry against Job Budgets (P/L only)

This new feature allows for the invoice transaction entry within the Purchase Ledger to validate the goods value against the ‘free’ budget on the job record for the selected cost code / category.

During invoice entry, after confirmation of the job code and cost code, the system will compare the goods value for this line (including any previous lines for the same job / category) against the available budget on the job record. The available budget is calculated on the basis of ‘Budget’ less ‘Actual’. If the available budget is sufficient the system will allow you to continue with the rest of the purchase transaction entry, if the budget is insufficient the system will warn accordingly.

If you accept the warning you will be returned to the job code to re-select another job/cost code as required. Alternatively you can press the <F7-Option> key to accept the entered job/cost code even though the ‘actual’ will be over budget. If you have elected to override the warning you may, depending on configuration, be prompted for a password to allow the override – key in as required.

Installation

To enable the validation of purchase invoices against the jobs available budget you need to set parameters within the Job Costing System Profiles. Parameter Screen 1 allows the additional options to enable this feature.

Check Actuals in P/L-Inv – set this option to enable the ability to validate the invoice goods value against the jobs available budget.

Password if exceeds budget – set an optional password that the operator must enter if overriding the ‘budget exceeded’ message.

Notes

If using a Foreign Currency system the base currency equivalent of the entered goods value will be used in validating the available budget.

If mark-up options configured, either in the Job Costing System Profiles or against the individual cost code, then the mark-up percentage will be applied to the goods value when comparing against the available budget.

The Job Costing link to the Purchase ledger must be set for ‘real-time’ updating within the Job Costing System profiles.

Custom Fields
  • Release ID: 5.9
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Account Costs (Sales Ledger) - Database Profiles
Viewed 2064 times since Mon, Jul 2, 2012
STOP – Flag Accounts with Stop Status
Viewed 1047 times since Mon, Jul 2, 2012
Trans Mandatory - Database Profiles
Viewed 1982 times since Mon, Jul 2, 2012
Include Currency Accounts in Auto-Payment Procedures
Viewed 1497 times since Fri, May 27, 2016
Save Period End Reports
Viewed 1523 times since Fri, Nov 22, 2013
Sub-Contractor Accessory - Multiple Job Analysis
Viewed 1576 times since Mon, Jul 2, 2012
Additional Transaction Report Utilities
Viewed 1577 times since Mon, Jun 11, 2012
Period End & Year End
Viewed 1808 times since Mon, Jul 2, 2012
Controls and Audit Manager
Viewed 1822 times since Mon, Jul 2, 2012
Turnover History Report
Viewed 3251 times since Mon, Jun 11, 2012