Dear PBSVic (Programmer) i can you help me on this ?

[titoneon]

In SBT PRO 5.0i
Module Purchase Order, transaction, Enter Orders, Purchase Orders here is what i am looking for to do.

I need to add in the "Enter purchase orders" form screen two texboxes, where the data imputed can be saved in the corresponded tables wich i guess has to be in pomast.dbf and potran.dbf, please correct me if i am wrong, what i want to do, is add a date textbox where i can type the delivered date wich i will label it as "Delv Date" wich is complete different than Req Date and again be able to save it into the corresponded tables and in the same form another textbox that i will label it as "By", wich means, who told me at the vendor place that particular delivered date so we can have a reference's name in case they don't delivered on that day they promised. can you please help me on this ?
Thanks a million

 

[SBTBILL]

SBT PRO takes each field and has it assign a number when it is loaded. You have to research how that works first. Then the form takes that and use it as a control source. That allows it to be saved with the rest of the fields. You probably also have to understand dodefault and tab index.

PRO uses a very non-standard dialect of VFP.

 

[PBSVic]

You can add new fields to POMAST and POTRAN by entering them in System Manager -> Maintain -> Dictionary -> Tables.
Select POMAST, click the Fields button and add your fields.

You will need to run Update from Data Dictionary to actually make the changes to the tables.

To add the fields to the screen, you will need the Source Code version of Pro Series and you will need Visual FoxPro 5.

If you don't have a Source Code version of Pro Series, you cannot make any changes to the screens or code. You could write a PRG to go on the Custom menu for each user. This could open a new screen/window you create to let the user select a PO and its lines and let them enter the data into the new fields.

If you do have a Source Code version of Pro Series, then you MODIFY SCREEN po\popost and po\poposd. Copy and Paste similar fields and labels, move them around and change the properties.
You will also need to MODIFY COMMAND po\popost and create variables for your new fields. Look for the field PURDATE and make the code for your field/variable similar.

 

[SBTBILL]

Not quit true you can modify screens and VCX classes with out source code. What you can't modify are the PRG's. In the edition we're talking about here that is more of a problem then in the newer editions as more is moved to VCXs in each edition.

You can also write programs to directly access the data. That solves a lot of problems.

Bill Couture
sbtbill.com