Jump to content

Budgets and Requisitions


This topic is 7147 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have developed a Budget File and a Requisition File. I would like to link the two in such a way that (1) a message would pop up if someone is requesting supplies from a budget line item that does not have the funds to cover that purchase, or (2) better yet stop the user from continuing with the request, that is, prevent the new record of that request from being completed? This is to become one part of a larger purchase order program. Thanks.

Link to comment
Share on other sites

Tight control over creation of new records is typically handled with a layout for data entry where all the fields are global fields. A user can enter all the data, but nothing is "posted" until a button is clicked / a script is run. In your scenario, the script would first check the budget, and if ok, a new record would be created and the data fields would be set to their corresponding global fields (and you'll probably want to empty all the globals afterwards).

The way the script checks the budget would simply be something like:

If (gAmount > BudgetLineItem::Amount)

. Show Message ("No way, Jos

Link to comment
Share on other sites

This topic is 7147 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.