Search results for query: *

If I use the {JrnlRow.RowDescription} to exclude the necessary inventory items, then the report works like it should (keeping the invoices with no inventory item id, but excluding the two inventory items).

Yes. The report was working before the last record selection line was added. I printed the report before and after the additional record selection. The number of records selected is significantly reduced.

Using Peachtree Premium 2009, Pervasive SQL database and Crystal Reports v9. I created a report to list the invoices, quantity, unit price and invoice amount by sales rep. My client wants to eliminate two inventory items from the report. I added the record selection not({lineitem.itemid} in...

If you want to enter a new cost for the item, first do an inventory adjustment to make the quantity 0.00. Then do another inventory adjustment to put in the correct quantity at the correct cost.

I'm using Crystal Reports v9. I need a parameter for users to enter multiple assembly item id's and the quantities to build each assembly. How can I associate the quantity needed to build with each assembly? For the {?Assembly ID}, I am allowing multiple descrete values. The {?Units to...

I use "left outer join" on all links: JrnlRow.PostOrder to JrnlHdr.Postorder JrnlRow.ItemRecordNumber to LineItem.ItemRecordNumber JrnlRow.CustomerRecordNumber to Customers.CustomerRecordNumber JrnlRow.GLAcctNumber to Chart.GLAcctNumber If JrnlRow.RowType = 0, it is a normal transaction, like...

This is an error that has occured in Peachtree since version 7. Try a different printer driver, preferrably one that is more generic. The key is also saving the new printer driver with the form.

crystalpro (TechnicalUser) 20 Jun 05 18:38 How do you get the cost for an item sold in Crystal Reports v9? I have tried: if {jrnlrow.rowtype} = 1 then GetPeachRowAmountv2 but it only returns 0.00's for every item sold. I have a record selection: {jrnlrow.journal} = 3 3 = the sales journal...

How do you get the cost for an item sold in Crystal Reports v9? I have tried: if {jrnlrow.rowtype} = 1 then GetPeachRowAmountv2 but it only returns 0.00's for every item sold. I have a record selection: {jrnlrow.journal} = 3 3 = the sales journal columns on my report include: customer...

This error means the printer driver you are using is not compatible with Peachtree. Try a more generic printer driver and then save that printer driver with your form.

I have a report that groups by SHOWROOM and by PRODUCT LINE. Is there a way to have the transactions for a blank (empty/no showroom)SHOWROOM print at the end of the report instead of the beginning?

How can I reset the Formula Editor to display the three windows at the top of the screen and across it? Somehow I changed the way the Formula Editor window displays. It used to show across the top: Report Fields, Functions, Operators. How can I change it back to this?

I think the name of the taxtable is CASDI. See if it is in the global or Peachtree-maintained taxtables.

Thank you so much for your help. I tried your suggestion in the last post and it worked like a charm.

Does anyone know if Peachtree's Crystal Reports (version 9) be used with other databases besides Peachtree? In particular, an Oracle database.

I put {@Department} in the details section and it only returns zeroes 000. However when I see the data I can see the account 5310.0.0.00.001 If I add the selection criteria as you stated above, I get no data.

The sample company contains accounting years for 2007 and 2008. If your company data is stored in a folder by itself, then the year end wizard was run more than once to get to these years.

The are stored in the datapath. The extension is always "FRM". The file name is 8 characters and generally starts with the type of form it is, i.e., inv for invoice, followed by 5 digits beginning with 00000. For example if you created a new invoice form for the first time in...

Unfortunately, this error message can only be resolved by restoring a good backup or sending in your data for repair. You can email me at gayle@baytek.com for more information.

It's stored in the company (or user-defined) taxtables under the File Menu. Select File Select Payroll Taxtables Select Company or User-Maintained (depending on your version) Select the disability taxtable Change the formula to contain the correct rate Click SAVE Click Close