RE: Orders Coming off Backorder – now Fully Committed

Hi,

 

I am trying to make a saved search which does the following:

Show orders that contained items on back order but are now fully committed.

I have the following so far:

Criteria:

Main Line is true

Type is Sales Order

Fully Committed Date (Custom Body) is on yesterday

Customer : Category is any of Wholesale – Credit, Wholesale – Proforma, Distributor

 

Results:

Document Number

Name

Date

Fully Committed Date (Custom Body)

 

I am not certain what to add to pick up the items that were on back order, i suspect a formula of some kind.

 

Thanks

themelon007 Rookie Asked on June 24, 2020 in Saved Searches.
Add Comment
1 Answers

You have mainline = T in your criteria, you cannot retrieve line level data with that criteria.  You probably need to move the full committed date to the line level and restrict/pull from there instead.

Intermediate Answered on June 24, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.