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
VAT Form 100 - Group VAT Registration
Viewed 3343 times since Tue, Oct 9, 2018
Separate Look-Ups for Extra Maintenance Screens
Viewed 1563 times since Wed, Jun 13, 2012
List All Transactions
Viewed 1516 times since Mon, Jul 2, 2012
Record Groups as Items in Discount and Supplier Matrix
Viewed 2220 times since Fri, May 27, 2016
Increased Size of User-2 / User-3 Items
Viewed 1561 times since Wed, Jun 13, 2012
Account Aged Analysis - Database Profiles
Viewed 1567 times since Mon, Jul 2, 2012
Holding Rate Revaluation
Viewed 1627 times since Mon, Jul 2, 2012
Multi-Period Allocations
Viewed 1840 times since Wed, Jun 13, 2012
Unallocating Transactions in Earlier Periods
Viewed 1781 times since Wed, May 29, 2019
Expand Data Files
Viewed 1518 times since Mon, Jul 2, 2012