×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Jobs

Qty on hand for Crystal

Qty on hand for Crystal

Qty on hand for Crystal

(OP)
I am building a Crystal report for inventory control.
I would like to see an average of items sold to customers versus qty on hand. Problem is that I cant find the "qty on Hand" field. Anyone know where it lies?

RE: Qty on hand for Crystal

This info is in the Invcost.dat file.  Unfortunately, Peachtree decided not to expose this file to the .ddfs that you use to write crystal reports, so you cannot pull this info into a report.

A workaround is to use Btsearch, which will read the .DAT files and create full ddfs, then write your report from the new .ddfs.

I have never done this but I am told it works well.  Tread cautiously in any case.  Btsearch can be found at:

www.nssdd.com/btsearch.htm

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

RE: Qty on hand for Crystal

mann71  - This is a problem that I ran into also. Took Peachtree two weeks to get back to me when I asked them the same question and they wanted to charge me for the answer. I simply asked them what file/field the quantity on hand is stored in. finally they got back to me and did confirm it is calculated and not stored in a specific filed (oh what a nightmare this is). This is a tricky one to figure out and good luck and as dgillz stated above tred lightly, this is not easy to do.

RE: Qty on hand for Crystal

Actually, the data IS STORED in a specific file, the INVCOST.DAT file to be exact.  However, Peachtree, once again in their infinite wisdom, decided not to expose this particular file (and many othres) to the ddfs.  This way Crystal Reports, MS Access, etc, cannot access these files.

Peachtree does not want you to be able to write reports, they want you to come to them to get reports.  That is what this is all about, IMHO.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

RE: Qty on hand for Crystal

From Mann71.
Thanks for the info guys, as you say, not easy.....MAS90 Here I come!

RE: Qty on hand for Crystal

Try Macola.  It is better than Mas90 IMO.  I can get you all the info you need on it.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

RE: Qty on hand for Crystal

I ditto that - Macola is a very powerful, flexible and user friendly business application program which I have used in a previous position. I highly recommend it. You should at least explore its capabilities.

Mark

RE: Qty on hand for Crystal

Thanks for the Heads up on Macola guys, definatly going to have a big look at it.

RE: Qty on hand for Crystal

There is now a function for getting the quantity on hand for inventory in crystal reports for peachtree.  You will need to upgrade to Peachtree 2003 in order to get it.

RE: Qty on hand for Crystal

CrystalPro-

What is the function?  

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

RE: Qty on hand for Crystal

The new function is GetPeachQtyOnHand.  It is found under the "Additonal Functions" category in PCW 2003 of Crystal Reports.

GetPeachQtyOnHand ({Company.CompanySpecial1a}, {Company.CompanySpecial1b}, {Company.CompanySpecial1c}, {Company.CompanySpecial1d}, {LineItem.ItemRecordNumber} )

You must include the tables Company and LineItem in order for the function to work.

RE: Qty on hand for Crystal

CrystalPro,

Any chance you can email me the u2lpeach.dll that has this function?

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

RE: Qty on hand for Crystal

If you like working with data noting beats ACCPAC PRO and Vision Point

Bill Couture
http:\\www.sbtbill.com

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