Sales Orders, Partially Shipped

Maybe all of you already know how to filter the Sales Orders that partially shipped. I will write it here just for a simple reminder.

You can use these filters to find those Sales Orders header:

  • Shipped: TRUE
  • Completely Shipped: FALSE

Shipped

This Boolean flow field indicates that the Sales Order has been shipped once at minimum, even though only partially.

The flow field CalcFormula is:

Exist(“Sales Line” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),Qty. Shipped (Base)=FILTER(<>0)))

It means that if there is at minimum 1 line already shipped, then this Boolean will be TRUE.

Completely Shipped

This Boolean flow field indicates that the Sales Order already completely shipped.

The CalcFormula is:

Min(“Sales Line”.”Completely Shipped” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),Type=FILTER(<>’ ‘),Location Code=FIELD(Location Filter)))

It means that if there is at minimum 1 line (with Type is not blank) that is not completely shipped, then we can say that the order is not completely shipped.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s