Recent content by SassyStacie13

I am working on an open order report for my sales reps and I am encountering a sporadic problem. Some of my records show up just fine, others duplicate the line items. I am grouping on the order number, then on the order date. I am trying to include the order notes on these, which links through...

Thank you. It worked beautifully.

lbass, That works, except that if I order a new item and don't have all the cost information, it kicks out items that are valid and not duplicated order line items. I know this is kind of confusing. Any other suggestions that might work?

Durango, I tried that, but if the first line has NO item cost, I want that line suppressed. However, the $0 cost line isn't always the second line item - and, it supresses all the duplicates - qty, costs, etc. I'm trying to write a formula to supress the line if the Item Id is the same, but...

I have developed a weekly report for my sales reps that works beautifully for their needs except for one little thing. My problem is this: When I run the booked orders report, if an item has invoiced already - it shows up twice in the order section - once with item cost(invoiced item), once...

I'm in the process of writing a weekly sales report for my Sales Reps, who have been ever so helpful in letting me know what they need to see. I am currently pulling in the qty, uom, item id, price, etc., but I need to pull in the item description. When I use the SQL information from Commerce...