Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WinterDragon

    Changing the location of Forms in Peachtree

    Excellent, Thanks for the Information, I will have to try this when I get to that network again. Thanks again for the assistance
  2. WinterDragon

    Changing the location of Forms in Peachtree

    I have Peachtree Premium Accounting for Manufacturing 2005. This is installed on a Peer to Peer network, However, On each machine the software is set-up as a stand alone, using mapped network drives, since we were having problems using the network setup version. If one person makes a change to...
  3. WinterDragon

    Multiple Occurences of the same Item ID

    Ok I think I figured this out. The reason it was pulling multiple IDS, was that Peachtree has References for that Item ID, IE, Each PO that was entered. So YES, your solution would be correct, It would require a SUM of the Item ID Qty's. When I did a similar report, a couple of years back...
  4. WinterDragon

    Multiple Occurences of the same Item ID

    I am not ignoring your questions. There is only one QTY on Hand. I want the number of pieces on hand at the moment I run the report. There is no Sum, or Group, or table. Its as basic of a report as there can be. I can pull the INVENTORY LIST report from Peachtree and it shows exactly the...
  5. WinterDragon

    Multiple Occurences of the same Item ID

    There should be only one qty. When I first started Crystal, someone had posted a much simpler way of doing this, which basically eliminated the duplicate item ids. Something like Lineitem.itemid=0 or something to that effect which is what I was looking for in this forum, cuz thats where I found...
  6. WinterDragon

    Multiple Occurences of the same Item ID

    My apologies. Crystal Reports 9. Connectivity is BTRIEVE (for Peachtree) Make this simple. I do not want grouping, I do not want anything other than the 3 fields of information. I want the report to contain 3 (THREE) pieces of information. ITEM ID, QTY ON HAND, and DESCRIPTION. (NO GROUPS...
  7. WinterDragon

    Multiple Occurences of the same Item ID

    I thought that I did answer your questions. In case I did not here is the jist. I need a Piece of paper (report) with 3 things of information. The Item ID, The Qty On Hand, and the Part Description. I do not need a GROUP, or SUM, or Running Total. JUST those 3 pieces of information. I do not...
  8. WinterDragon

    Multiple Occurences of the same Item ID

    Fields: ItemID, Qty On Hand, Description these are the only 3 fields I am using. I am not Grouping fields or anything like that. Example. Item ID Qty On Hand Description 110-12 12 Adapter 111-15 1 Hose 158-10 1 Bearing 158-10...
  9. WinterDragon

    Multiple Occurences of the same Item ID

    I know the the answer to this was posted here long ago, but for the life of me i can not locate it. I have an Inventory report. ItemID - Qty Oh Hand - Etc Etc The report will show the same ItemID multiple times. 158-10 1 description 158-10 1 description 158-10 2 description I need to find...
  10. WinterDragon

    Running total based on a formula

    I am still rather new to Crystal and I am not quite sure I am following which table you are referring in ({table.qty}) Would this be like ({Lineitem.qty}) ? If so, what would the second Table be? I have 3 tables.. BOMItems, Lineitem and Lineitem_1 Qty On Hand is pulled using a Peachtree...
  11. WinterDragon

    Running total based on a formula

    Now what I am wanting to do, is in the group heading (The Assembly name) I want a running total (Or Similar) to display the Smallest number of cases. This way if an item only has enough to make 1 case, and another item might have 6,000, I want to know that I can only make 1 case. If this doesnt...
  12. WinterDragon

    Avery label definitions

    In my experience of searching for prebuilt templates, Ive had to build them myself using the page setup. I am not a Crystal Expert by any means, but this seems to be the easiest approach. I have found little or no results on the web searches. Hey I could be wrong in this. (I Hope I am Wrong...
  13. WinterDragon

    Creating Running total from a Formula field

    I have an assemblies report. List the Assembly Name, then under the Named groupd shows the component Description, Qty needed, quantity on hand, and the @Division formula, devides the quantity on hand by the qty needed, to tell me how many cases I can produce. Now what I am wanting to do, is in...
  14. WinterDragon

    Why Buy Crystal Report

    Crystal Reports should be able to handle that for you. I am still considered a "Newbie" with Crystal, but from what I have seen with Crystal Reports, It is QUITE Powerful... Winterdragon
  15. WinterDragon

    Creating Running total from a Formula field

    I have an assemblies report. List the Assembly Name, then under the Named groupd shows the component Description, Qty needed, quantity on hand, and the @Division formula, devides the quantity on hand by the qty needed, to tell me how many cases I can produce. Now what I am wanting to do, is in...
  16. WinterDragon

    Formula Issues

    Thanks Brian.. That worked!! I'm not Sure HOW it worked. The Unitcost data comes from Peachtree as 84.38 when I browse the data. I guess Some things arent meant for us to know.. Thanks Again.. Winterdragon
  17. WinterDragon

    Formula Issues

    I just tried creating a Whole new formula, where the RTotal0 (the total of RTotal4) is multipled by the Unitcost. Same thing... (#Rtotal0) * jrnlrow.unitcost 26 * 84.38 = 2193.75 <-- From Crystal 26 * 84.38 = 2193.88 <-- from calculator Any ideas?
  18. WinterDragon

    Formula Issues

    Hey guys, I have an interesting question that I do not understand. I have a field that is a Formula. (@amount) = (#Rtotal4) * {jrnlrow.unitcost} Simple enough. Should multiple the value in RTotal4 by the Unit cost. Here is the issue.. When Rtotal4 equals 6, It multiples right (6 * 84.38 =...
  19. WinterDragon

    Changing the Report Description

    Thanks for your help. That did the trick. I figured it had to be something Simple, But I guess I was looking up the wrong Key words.. Thanks Again, Winterdragon
  20. WinterDragon

    Changing the Report Description

    Does anyone know how to change the report Description? When Peachtree shows the Reports it gives a Secrip off to the left side. I need to change some Descrips and I can not find out how to do it. Winterdragon

Part and Inventory Search

Back
Top