Proposal For Custom Page to Update Ship Date in Sales Orders

Requirement
Marshall Electronics would like to develop a Custom page to update the line level Ship date in Sales
order Item lines in bulk.
Our Solution
The requirement can be achieved by creating Custom page using Suite script.
The page will have the following user input fields:

  1. Sales Order# (text field)
  2. PO # (text field)
  3. Ship date (date field)
    Initially all the Sales Order Item lines which are not yet committed are listed.
    Once the user input the Sales Order # or PO #, on the field change the Item lines in the particular Sales
    Order are listed. The Item lines which are not yet committed in the sales order are only shown in the
    list.
    The listed item lines will have the following fields:
  4. Check box
  5. Item name
  6. Item Description
  7. Quantity
  8. Ship date (line level)
  9. Created by
  10. Sales Order Status
    Once the user input the Ship date, they can select the Sales Order Item lines to be updated with this
    Ship date by marking the check box. And then click on the “Submit” button which updates the input
    Ship date to the line level Ship date field in all the selected Sale Order Item lines.
    On the click of Submit button a message is shown to indicate the user that the script is running and
    ship date is being updated in the background. Once the Ship date is updated successfully, a
    confirmation message is shown to the user and the page is reloaded.
    There are two buttons named Mark All and Unmark All which enables to select or deselect all the item
    lines.
    Note: The custom page can be released only to the roles MEI- Sales Operations Manager, MEI- Sales
    Operations Associate and MEI- Order Entry.

Assumptions
• The Sales Order Item lines for which Item Fulfilments are not created are only considered for
updating the Ship date.

Leave a comment

Your email address will not be published. Required fields are marked *