Categories
NAV 2017 (10) Reminder

Sales Orders, Partially Shipped

How to find the Sales Orders which are 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.

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