Saturday, September 29, 2018

Filter the Fulfill Sales Order Page to Exclude Drop Ship Orders

Customer has sales orders with drop ship PO created.  These orders are not yet shipped.  When the customer navigates to Transactions > Sales > Fulfill Orders, these drop ship orders appear on the list of orders to be fulfilled.  Customer wants to remove these orders from the Fulfill Orders page as they are to be fulfilled by vendors.


Excluding the Drop Ship Orders from the Fulfill Orders page is logged as an enhancement via issue 157601.  Workaround is to create a custom check box field on Sales Order forms that would indicate whether or not the order is a drop ship order, then add this custom check box field as a filter on the Fulfill Orders page.


A. Create a custom check box field.

1.    Navigate to Setup > Customization > Transaction Body Fields > New.

2.    Enter an appropriate label for the field (such as "Drop Ship Order").

3.    On the Type field, select Check Box.

4.    Check the box for Store Value.

5.    Under Applies To tab > Sale = T, Item Fulfillment = T and Print on Standard Forms = T.

 

6.    Under Display Tab > select where you want to show custom field.

 

7.    Hit Save and Apply To Forms > Make sure that Show box is checked for the forms you want to display custom field.

 

8.    Hit Save and hit Ok.

B. When you create drop ship orders, you can then mark this check box to identify it as a drop ship order.

C. Customize the Fulfill Orders screen to include a filter for the custom check box field created in step A.

 

1.    Navigate to Transactions > Sales > Fulfill Orders.

2.    Click Customize button.

3.    On the Additional Columns tab, check the box for the custom field you have created in step A.

4.    On the Additional Filters tab, check the box for the custom field you have created in step A.

5.    Hit Save.


Note: After these steps, you will then be able to set the "drop ship" filter to No so that you can only select those that are not drop ship orders.

No comments:

Post a Comment