Search results for query: *

This worked perfectly, and I learned something!!! Thank you so much [hourglass]

Hello! Here's my (super simple) formula: if {oeordlin_sql.item_no} startswith "3.10" then "Blue instruction sheet enclosed." else if {oeordlin_sql.item_no} startswith "2.10" then "Yellow instruction sheet enclosed." I need a third condition, where if an order contains more than one item, and...

Thanks - that's exactly what I was talking about. I appreciate your help!

I need to know which table contains the default expiration date that is used when reporting production from within Macola Progression POP. Please see the attached for exact field location.

Turns out that the component item that I was trying to include was originally obsolete in the item master table. I had already changed it to active, but apparently I needed to delete the POP order, delete the item from the BOM, rebuild the BOM, then re-enter the POP order. Then the inventory...

Hello - I have a BOM where we are only using a percentage of the component to create the item. For example - I have a carton of flooring that we are cutting up to create a take-home sample. Each carton of flooring creates 21 samples. So, I have 2 components for each sample: the label and .048...

I guess that would be helpful... we are running Progression on SQL

Hello - I'm looking for a list of integrated crystal reports. More specifically, I need to know what the name of the report that references the "reprint posted invoices" ICR. I can't open it because I am running Crystal 8.5, and of course all of the ICR's use Crystal 11.

I'd rather not upgrade our version of Crystal Reports because of what I've heard about the more expensive lisensing and developer issues, but need to upgrade the OS.

Trying to install Crystal 8.5 onto a new workstation with Exact Progression SQL version 7.7. "Special" Macola fields don't seem to be there, like the MACOLARemoveZeroes (, )and other functions specific to Macola. Are we missing some sort of driver? I know that we are supposed to have moved to...

The font dialog box does work, and we can change the font there, but we are wondering why it is defaulting to an italic font. We have 10 users, and no one else has this issue. Not a huge problem, but an aggravation for this particular user...

whoops - Progression 7.6.400b, printing picking tickets as a separate function, not immediate pick tickets

Hello, Trying to change font defaults for user, the font dialog and "change default" function doesn't work, all of her picking tickets are printing using an italic font. Help!

Have an employee who hates it when a report opens in design view, she wants her reports to open in the "preview" view only. I can't find the stupid little check box - can anyone help? >:-<

...here? Writing in Crystal Syntax if {oelinhst_sql.item_no} in ["REC001", "REC001A"] and {020708_counties.COUNTYNM_}="Mecklenburg" then (34.95 * .0725)*{oelinhst_sql.qty_ordered} else if {020708_counties.COUNTYNM_} <> "Mecklenburg" then (??)(34.95 * .0675)*{oelinhst_sql.qty_ordered} and...

For example, Again - we ship books. The charge to ship the first box is $4.25, then it is $1.00 for each additional box. If I have a total of 10 boxes, (thanks lbass....), what formula should I use to calculate the total charge?

Perfect! I always get such great info on this board...

A full carton of books shipped = 5 books. We are trying to bill our customer for full and partial boxes of books shipped, and I need for Crystal to ALWAYS round up to the next number unless the quantity of books sold is >5. How can I get this formula to NOT return a quantity of 8.4 for an...

Hello, Trying to chop up and use a report that used to be an integrated report as a custom report (those integrated ones were so wordy.... too much info). When I refresh the report, I'm getting a "Memory full" error, and then "Not a 4.X or earlier version of Crystal Reports". How can I get...

We have noticed that when you convert a quote to an order in OE, you lose the ability to go back and look at the quote. Does anyone know why this happens, or if there is a work-around for it?