Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
thread640-1652600
- Thread starter titoneon
- Start date
mlefkowitz
Programmer
AROREC.FRX/FRT is the form.
Program file ARREPT.PRG contains the query and setup code. Look in function L_AROREC in ARREPT.PRG
Matthew Lefkowitz
Lefkowitz Systems, Inc.
Program file ARREPT.PRG contains the query and setup code. Look in function L_AROREC in ARREPT.PRG
Matthew Lefkowitz
Lefkowitz Systems, Inc.
- Thread starter
- #3
Hi Matthew,
Thanks for getting back to me but what i want to accomplish in SBT PRO 5.0 is:
When in SBT I open up AR --> Maintain --> Customers. When the customer form opens up, I would select a customer and select click the "Inquiry" button at the top of the form. Another form opens that allows me to select the inquiry type and i select "Receivables" from there a new window opens up that is titled "Open Receivables as of today's date". It basically shows the records for the customer's receivables in a grid format or browse format, actually don't know if it is a Grid or Browse, so I would like to add the "PO" or "ponum field" to it from the table armast.dbf, can you please help me out here, where is the prg file that needs to modified and if i need to set an SQL or some kind of set relation to, any help is very appreciated, i posted this while ago and you came to the rescue.
Thanks a lot
Thanks for getting back to me but what i want to accomplish in SBT PRO 5.0 is:
When in SBT I open up AR --> Maintain --> Customers. When the customer form opens up, I would select a customer and select click the "Inquiry" button at the top of the form. Another form opens that allows me to select the inquiry type and i select "Receivables" from there a new window opens up that is titled "Open Receivables as of today's date". It basically shows the records for the customer's receivables in a grid format or browse format, actually don't know if it is a Grid or Browse, so I would like to add the "PO" or "ponum field" to it from the table armast.dbf, can you please help me out here, where is the prg file that needs to modified and if i need to set an SQL or some kind of set relation to, any help is very appreciated, i posted this while ago and you came to the rescue.
Thanks a lot
mlefkowitz
Programmer
Program file is SYCINQ.PRG function L_BROWSE. SYCINQ.PRG is usually found in folder SM. You will need to make some code changes to add the PO# to the grid. But it is very easy.
Matthew Lefkowitz
Lefkowitz Systems, Inc.
Matthew Lefkowitz
Lefkowitz Systems, Inc.
- Thread starter
- #5
- Thread starter
- #6
Matthew,
I found the "L_browse Function" and i can see this code below part of the function that should be the one that accept the other inquires, in my case the "Receivables" but there it is another procedure or file called there, which is "g_mrkbrw" where is this located ?
Can you help me out here a litte bit more at your convenient please ?
I did not find the lc_brofld1 and lc_brofld2 variables either, i am complete lost here, sorry but if you can help me a little further that will be great.
DO g_mrkbrw WITH .t., lc_title
BROWSE FONT &gc_brfnt. ;
WINDOW lw_custinq ;
FIELDS &lc_brofld1.&lc_brofld2. ;
KEY lc_custno ;
NOAPPEND ;
NODELETE ;
NOMENU ;
&gc_brcolr. ;
NOEDIT ;
TITLE lc_title
Thanks in advance
I found the "L_browse Function" and i can see this code below part of the function that should be the one that accept the other inquires, in my case the "Receivables" but there it is another procedure or file called there, which is "g_mrkbrw" where is this located ?
Can you help me out here a litte bit more at your convenient please ?
I did not find the lc_brofld1 and lc_brofld2 variables either, i am complete lost here, sorry but if you can help me a little further that will be great.
DO g_mrkbrw WITH .t., lc_title
BROWSE FONT &gc_brfnt. ;
WINDOW lw_custinq ;
FIELDS &lc_brofld1.&lc_brofld2. ;
KEY lc_custno ;
NOAPPEND ;
NODELETE ;
NOMENU ;
&gc_brcolr. ;
NOEDIT ;
TITLE lc_title
Thanks in advance
- Thread starter
- #7
- Thread starter
- #8
mlefkowitz
Programmer
- Status