Search results for query: *

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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

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?

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 =...

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

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