Search results for query: *

Thank you for the offer. I have emailed you. Looking forward to your help soon.

Thanks Ken. I have been thru those Peachtree data dictionarys a hundred times, at least, and have printed them up as well. I missed the part about the "GetPeach" somehow and still can't find it, but it is probably pretty nebulous anyway. I will keep hunting and Im sure it will pop up...

Hi Ken, I have set up the new formula and double-clicked the "GetPeachRow(). I replaced the JrnlRow.XAmt with JrnlRow.Amount. It must be replaced because the formula isn't recognized with the XAmt in it. When I placed it in my report to see what it would do it just brings up the sales...

Hi, I have looked at the "GetPeachAmount()" in the additional functions. I have never used the Additional functions before and am not real sure how they work. I need these to figure Cost of Goods as my regular database uses Labor Cost instead of Goods Cost and there are some Item Id's...

Ken, Great information. I will see what it does. My manual doesn't even make reference to it altho it does mention the additional functions. This might make my life a whole lot easier-at least in the report programming area.

Finally found it. Peachtree calls it Labor Cost in the Item Table. Sure had to kiss a lot of frogs to find this prince.

If only it were that simple. Strangely enough the Unit Cost in the Journal Row is actually the sale price of the unit. Therefore, if I mulitply the Quanity times the Unit Cost it gives me the same amount that is in my Sale Column. Any other suggestions would be most appreciated.

I am using V8 for Peachtree. My tables are linked as follows:JrnRow to JrnHdr by Post Order. The JrnRow is also linked to Customer, Item, Cost by the Record#. I then have also linked the Item to Cost table by record number. The report is grouped by SalesRep ID. I have 2 detail sections. The...

Fixed it Ken. I am back in business again. It is report just as it ought to for the time being.:.)

Putting in the "greater than" 0.00 did change the report. It eliminated the 4 rows without the Item ID at the beginning of a new customer and eliminated the last row without and Item ID. However, it is still putting in each row 3 times with the Item ID for each Item ID. If I do a...

I have taken the suppress off and all fields are in the same detail section. For every new customer this is what I get...... SalesRep Cust. Inv# Inv.Date This is repeated 4 rows and on the 5th row I get SalesRep Cust. Inv# Inv. Date AND Item ID The above 5th row is then repeated 3 times. If...

Thanks Ken. Yes, changing the links has now enabled me to bring up the Item ID. But...for some reason it is dropping it 5 rows down leaving large white space and if there are multiple Item ID's on the order it drops down rows on each one of them. I have done the supress on all fields including...

Tables are-Customer,Journal Header, Journal Row, Line Item and Cost Code. The JrnHdr and JrnRow are linked by Post Order. JrnHdr, CostCode and LineItem are linked by description. The JrnRow and Customer are linked by Record #. I let the Wizard make my selections. I have tried other links but...

I am brand new to CR. Using V-8 for Peachtree. I have my report partially complete but it won't pick up certain data in a row. IE: My report is grouped by Sales rep. It pulls the customer, transaction #, trans date for a specified time period. However, no matter what I do it will not pull the...