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

Name of form or query for Open Receivables

Name of form or query for Open Receivables

Name of form or query for Open Receivables

HI Everyone,

I'm new to SBT and was asked if there is anyway I can add a "PO" field to the Open receivables form within customer maintenance. To clarify in SBT I would 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. I was asked to add the "PO" field to it.

Does anyone know how I can find out what form or qry this is pulling off of so that I can modify it?



RE: Name of form or query for Open Receivables

Which SBT version are you running?

Latests Accpac/SagePro versions use a dataview for those queries that is much easier to modify.

If you are running SBT 5.0(or prior) you have to modify a program. You will need the source program and VFP to compile.

So, first at all, let me know the SBT version.



RE: Name of form or query for Open Receivables


Thanks for the reply. Running 7.4 and got a tip from another website. Click on the i button which provides the dataview information i.e. the name of the dataview. Went into maintain dataview and edited the view.


RE: Name of form or query for Open Receivables

Just joined this forum and was walking through the old threads. This this is still an open request...

The answer is yes. When you are in the Open Receivables inquiry, look at the bottom left. You will see a button with an italics letter "i". Click and you get the name of the data view currently displayed: PL_SYCHST_REC. Block and copy the name to your Windows clipboard. Close the window, the inquiry and the customer window.

Now move the menu and look for File -> Maintain Dataviews. Select it and past this data view id into the "Dataview ID" field.

Next, click "edit" and the dataview comes to life.

Click the button with three dots to the right of panel "Column". Up comes the data driller "Define Columns" picker window. Look for column "PONUM" in the left panel. Double-click on it and it will move to the right panel. Position it the list of selected columns by high-lighting it and then clicking the up and down arrow buttons to move it to where you want to see it in the grid.

Click "Ok" and then the save button. Then close the dataview window.

Done! Go back to your customer and do a Receivables inquiry. You should see PONUM on the list now.

This trick works everywhere in Pro 7.4 that you see a picklist. All are dataviews that can be customized for all or just one or some users and even customized by company (if you have more than one company). Powerful stuff.

-Matthew Lefkowitz
Lefkowitz Systems

RE: Name of form or query for Open Receivables


Thanks for the reply. I did figure it out a while back ago and did as you had written out.

Thanks for the tip though as I'm sure others will benefit from the update.


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