×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

HELP ADDING COMPANY NAME IN AR REPORT

HELP ADDING COMPANY NAME IN AR REPORT

HELP ADDING COMPANY NAME IN AR REPORT

(OP)
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  

RE: HELP ADDING COMPANY NAME IN AR REPORT

(OP)
sorry i forgo to mention that this is SBT 5.0I

RE: HELP ADDING COMPANY NAME IN AR REPORT

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

RE: HELP ADDING COMPANY NAME IN AR REPORT

(OP)
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

RE: HELP ADDING COMPANY NAME IN AR REPORT

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:

CODE

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

RE: HELP ADDING COMPANY NAME IN AR REPORT

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close