[rickwilk]

I have requested help on this before and been directed to a SuiteAnswer but still not able to get what I need.

I want to be able to run a report that shows unfulfilled sales orders with the order amount and the customer deposit against the order.

Based on Answer id 42218 i have a Transaction Search with:

Criteria:

Type = Sales Order

Status = Pending Fulfillment

Applying Transaction:Type = Customer Deposit

Results:

Number

Name

Amount

Applying Transaction:Amount

The problem is that this only picks up orders which have a customer deposit. It doesn’t pick up orders with no deposit.

Any help much appreciated.

Thanks
This is a cached copy. Click here to see the original post.

[michoel]

Remove the ‘Applying Transaction:Type = Customer Deposit’ line from the criteria if you don’t want to filter by it.

[rickwilk]

Thanks that works. I had tried that before but it reported every transaction line so I have just put in extra criteria to select just the sales order.

Thanks again.

[michoel]

No problem, you probably want to add ‘Main Line = Yes’ in that case.

[rickwilk]

Cool – thanks.

Didn’t know about that one.

[Author]

Posts