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!
  • Students Click Here

*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


purchase order report status

purchase order report status

purchase order report status

Hi Guys,
here is my situation:
In SBT PRO 5.0
i am running from Purchase order module, "report order status" the problem is ,that the person in purchasing dept inputed the amount we have to pay in the PO, in pounds sterling, so now when we already received the item related with this PO and the report order status run, it show the "Rec Value" in pounds sterling, i have been searching for the tables that has the field "REC VALUE' and i don't find that table, in other words, don't know if the field that is reflecting the "REC VALUE" in the report is actually named as "rec_value" or "Ltcost", i just need to change the rec_value to dollars but for that, i need to find the table that has the field and value, that makes the report to print REC VALUE, so i can change then that "REC VALUE" to dollars and when the report run, then show the "REC VALUE" IN DOLLARS.

Please if i did not explain myself correctly let me know.
Thanks so much in advance
Note: i have looking in pomastxx.dbf, potranxx.dbf, icitemxx.dbf, iccostxx.dbf and so on, so any help is very appreciated

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