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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

thread640-1652600

Status
Not open for further replies.
titoneon

titoneon

MIS
Dec 11, 2009
335
US
thread640-1652600

Hi,
Can you anyone help me to accomplish the same thing but on SBT PRO 5.0 Please ?
Thanks
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Matthew,
I will give a try, thanks a lot for the location of the files, very appreciated man.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Matthew
Sorry my search was wrong , i found all the variables, i just need to find out only which lc_brofld1 is the one i have to change
Thanks
 
Upvote 0 Downvote
Hi Matt,
Done already, really easy but if it wasn't cause you told the location, i will never figure it out
Thanks a million
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top