HELP ADDING COMPANY NAME IN AR REPORT 1

[titoneon]

Hi Everyone,
Under the accounts receivable module, prints, there is a choice for running transaction reports and then i need to run the "INVOICE REGISTER" report but this report include the "customer number" and not the "customer name", it is possible to modify this report i know but how can i add to this report the customer name, please can you help me out how to add to this report the customer name ?, i know this involve probably to add some code to a prg file, to get the data field from a table that links to the the customer number, add a variable to store the customer name and add this variable to the report but i don't know where to find first the prg file can you help me ?

The prg file is ARREPT.PRG UNDER FOLDER SBT\AR, I just cannot figured out how to link arcust.company to be stored in a variable so by time the report runs it can include in each record the company name, can any one help me out where in the prg file and what piece of code should i write there, i know we need to setup a set relation from armast to arcust, then each time a customer number is found in armast it should find it on arcust and then get from there the company name, store it in variable and then add this variable to the report detail.
Need help please ?
thanks a lot
Thanks

 

[titoneon]

sorry i forgo to mention that this is SBT 5.0I

 

[SBTBILL]

You probably don't need to use code. You can probably do it in the FRX report file. I didn't look but if anything is coming from the ARCUST table then a relation is likely set.

Bill Couture
SBTBILL.COM

 

[titoneon]

Hi SBTBILL,
I put the variable "company" in the frx file and it prints the company name but it is printing just the same company name on all records in the report so i am guessing yes the variable "company" is defined but it is not a set relation so there is my problem, where to write the set relation and i guess it has to be someting like this "set relation to custno into a_arcust", please if you can help me i will really appreciate it, the filename to be edit is arrept.prg
Thanks a lot
Ernest

 

[PBSVic]

The Summary Invoice Register Report is Related to the customer table and shows the Company Name.
The Detailed Invoice Register Report is not related to the customer table.
You will need to SEEK in the customer table and you can do this by changing the report form only, you don't need to change any code.
Instead of just putting in "Company" in the field on the report form, type:

IIF(SEEK(custno, "a_arcust", "custno"), a_arcust->company, "Not Found")

 

[titoneon]

PBSVic (Programmer),
Man, that was beautiful just right on the point thanks so much, i was looking like crazy to create a set relation in the prg file cause i did not find that relation so i assumed that has to be done first but you saved me. thanks so much.

by the way if it does not bother you i have another question.

I would like 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 "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 promised. can you please help me on this ?
Thanks a million