Adding a user-defined date field

We have done this as well. I assume you are using a Date## field in the Order Release table.

As you described, just add a custom date control to your order entry app (perhaps putting some row rule in place to make it a required entry field - or, upon after adapter method New, defaulting it to equal the planned ship date).

Then it is just a matter of chasing down all the reports, trackers and other (editing) apps that you want to make it visible and adding it. For trackers and apps, you may have to bring in the order release table as a foreign key view or a subtable to an intermediate foreign key view.

Be careful about going too crazy adding the field redundantly to too many apps as it may not be necessary: Observe how the users are really doing their jobs.

Example: Your production control people may be starting in Order Entry and right menu clicking into Job Entry or Time Phase to do their order promising/rescheduling. If so, having the date only appear on order entry is fine as the windows are linked in context (via job number or part number) and they can simply click on the order entry window to see the date.

Rob Brown



--- On Fri, 5/23/08, richter_clements <richter_clements@...> wrote:
From: richter_clements <richter_clements@...>
Subject: [Vantage] adding a user-defined date field
To: vantage@yahoogroups.com
Date: Friday, May 23, 2008, 11:04 AM











I understand I can make use of the user-defined fields available in

most tables. I'm trying to basically add a date field to order entry

to be used as a requested date - we use the need by date as the the

date promised to customer, the ship by date as the date to ship by to

meet the promised date, I would like to add a 3rd - that would

basically be used to say 'may ship by this date if ready'. I would

like to be able to populate this field in order entry and allow for

production & shipping to be able to see and add to certain reports

used by them. Any ideas? I don't know where to start or how to add

the user-defined field to the screen (for order entry) and to ensure

this date transfers as the other two dates do to other modules.....
I understand I can make use of the user-defined fields available in
most tables. I'm trying to basically add a date field to order entry
to be used as a requested date - we use the need by date as the the
date promised to customer, the ship by date as the date to ship by to
meet the promised date, I would like to add a 3rd - that would
basically be used to say 'may ship by this date if ready'. I would
like to be able to populate this field in order entry and allow for
production & shipping to be able to see and add to certain reports
used by them. Any ideas? I don't know where to start or how to add
the user-defined field to the screen (for order entry) and to ensure
this date transfers as the other two dates do to other modules.....