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

Rookie Asked on June 24, 2020 in Saved Searches.

Did this search work?

on January 12, 2021.

Hi, We have not currently go this to work as required.

on May 26, 2021.
Add Comment
1 Answer(s)

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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor