1. How To ..... for SO Mgmt
1.1. Find A Sales Order

 

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter the Sales/Sales Mgmt/Sales Order Management/Sales Order Management.

 

The following screen will be displayed:




Depress the Find action button. The following selection screen will be displayed. 
 
Select the desired Filter: by selecting the appropriate radio button - Open, or All.

Select the desired
Find: by selecting the appropriate radio button -  Sales Order Number, Customer, Customer PO, Work Order Number, or All. 

Enter the information into the red box, depress the Enter key and the information will populate the screen.    If you do not know the exact number, Customer, etc  you may enter in a partial number, letter, etc, then once you depress the enter key the system will pull up the matching record onto the screen or a list of all Sales Orders that contain the partial number, letter, etc. entered, to select from.
 
 
The user may exit the selection screen without a selection by selecting the X button.
 

If user selects ANY of the Filters and Find by All - a screen will appear listing all the Sale Orders filtered by the selection,  in numerical order, along with the Customer name.   


The user has the option to view the sales order by either entering the sales order number into the red box, or scrolling down the list, highlighting the desired record and double click on it.   

 

 

Once you have made your choice, the information will be displayed as follows:

Note: When an RMA is created, both the pending receipt of the items from the customer and the subsequent shipment of replacement product to the customer is entered. Reference is made to the original Sales Order and Invoice only to allow the credit memo (when created) to have a place to apply the credit. Otherwise, there is no interface between the Sales Order and the RMA modules. If you were unable to find the Sales Order, try to locate it under the RMA menu item. See RMA Management Module Article #1610 for further assistance.

1.2. Edit A Sales Order

Find a Sales Order, it may be edited by selecting the Edit Action button, then entry of the password. All fields available for editing will be enabled for modification.

Sales Order tab -  The user may add a new product, part or miscellaneous item. The user may delete an entire line item. The user may Issue a Work Order (if one hasn't already been issued). The user may change the quantity ordered, add or change the amount reserved or change the line status.  To remove a project number from the project field, ,by right clicking on the field.   (Note:  If a SO for example has three line items and user deletes only line item 01 user will NOT be able to re-use this line item when adding a new line item to this SO.  The system will use the next line item which would be line item number 04 in this example).  

Schedule tab - For the Line Item selected, the user may add or delete a scheduled delivery, change the 1st Due Date, or the Transit Days.

Pricing tab  - For the Line Item selected, the user may edit the Price, Sales Type, Tax, Lot Charge, Commissions info, Add or Delete a line.    

The Price Markup field is NOT editable within the Sales Order screen. This information defaults in from the Sales Price List Information module.

The Customer Sales Discount field is NOT editable within the Sales Order screen. This information defaults in from the Customer Information module.



WO List  -
  This screen is view only. 

 
 

Billing tab  -  The user may change the Customer address and/or add a Credit Note.



Shipping tab -
The user may edit or Add a New Ship To address, select a different Attention, FOB, Ship Via, and/or select a different Delivery Time from the pull down.  Note:  The user is able to edit or change the Cust Account No to match any special Ship Via pertaining to the specific order within the SO Shipping screen without the changes affecting the Customer Information module or any other pre-existing orders.
 


Notes tab -
The user may add or change the Sales Order Note and/or the Sales Order Acknowledgement Footnote



At the conclusion of the modification process, the user may either depress the Save  action button to save the changes or depress the Abandon changes action button to cancel changes, located at the top of the screen.
 
The following message will be displayed to the user if a WO is linked to the SO:




NOTE:  The link is for reference only between the two modules and they are still individual records so when any changes are made to either the SO or the WO the change will NOT update or be carried forward to the other.
 
 
1.3. Add A Sales Order

Adding a sales order is accomplished by first selecting the customer, a product and quantity.   Then the user visits additional tab/screens to add more information about the order.   The first of these is the Schedule Screen, where the user defines the delivery requirements for the product, then the Pricing Screen.   The user should visit the Billing Screen and the Shipping screen to ensure that the defaults established for the customer are appropriate to the order being entered.   If the user is visiting this screen to view an existing sales order, they may tab to the WO List screen and view current work orders in process. 

Depress the Add action button.  Enter your password. And the Sales Order Screen will be displayed. The current calendar date will default in the Order Date field.  This may be changed if desired.
 
 
If the user is using auto-numbering for sales orders, the Sales Order field will be completed by ManEx when the order is saved.
 
The next field to enter is the CUSTOMER. The user may begin entering the name, and ManEx will immediately begin tracking the key-entry to bring up the customer with as few keystrokes as necessary to identify the customer. Or, you may  press on the down arrow adjacent to the field and ManEx will display all of the customers from which to choose for the order.

The SO Status is defaulted to the OPEN status during entry of a new sales order.

Next, the user selects the buyer for the customer. Pressing on the down arrow adjacent to the field will display a list of contacts entered for the customer entered.  The user may select a contact or leave it blank.  If no contact has been entered for the customer, you will receive the following message. 

Depress OK and file will be left blank.

 

Next, a customer Purchase Order number is entered. This is a free-form field, and up to twenty of any normal characters(any combination of alphabet or numbers) may be entered.

If the user has a purchase order from the customer, or a confirmation of the order from the customer, then the ORDER ACK box can be checked. If this box is NOT checked, the user will NOT be able to create a packing list for the order when it comes time to ship.  If this box IS checked, then the date and initials of the user accepting responsibility for the order are recorded.

The next step is to use the Directive Buttons to add information into the sales order.

  

The "Add Product" button adds products or assemblies to the order. Pressing this button brings up the following selection screen.  User may enter in a Product Number, Part Class, or select ALL, which will display a list of products that have been established for the customer selected for the sales order. The user selects the product number being ordered by entering it in the red box, or scrolling down the list and double-clicking on the assembly. 
 

Note:  If the user enters specific customers in the Customer List within the Sales Price List Information module, then that product will only be available for that customer when creating a Sales Order.  


 

After selecting a part number, ManEx requests the quantity to be ordered. 

The user enters the Ord Qty (The quantity being ordered by the customer for the part number and the system automatically displays the Back Order, which is the quantity still due to be shipped for the order).
 
Once this quantity is entered, ManEx populates the first open line in the sales order with the data from inventory tables.  At this time user may assign a project number to the product if applicable.
 
 

You may view additional information about the part by sliding the scroll bar at the bottom of the grid  to to the right.

The "Add Part" button is to add a part from inventory to the sales order. This is material that is sold out of the stockroom, rather than material assembled to order.  It may include any part carried in ManEx inventory, with a source as “Buy”.  Pressing this button brings up the following dialogue box:   User may enter in a Part Number, Part Class, or select ALL, which wiil display a list of Inventory parts. The user selects the part number being ordered by entering it in the red box, or scrolling down the list and double-clicking on the assembly. Note: If the user enters specific customers in the Customer List within the Sales Price List Information module, then that part will only be available for that customer when creating a Sales Order.

 

After selecting the part number the following dialog box will be displayed, displaying the Warehouse, Part Mfgr, Mfgr Part Number, Warehouse Location and the Quantity Available.

Highlight and double click on the desired Part Manufacturer.

 

Once user has made their selection the part will be added to the Sales Order with the part information. The user must then move to the Order Quantity on the screen and enter the quantity ordered.
 
Once this quantity is entered, ManEx populates the line in the sales order with the data from inventory tables. At this time user may assign a project number to the product if applicable.   If parts are allocated to a project and the project is selected in SO for the SO item, when the part is shipped, those allocated to that project parts will be available to be shipped. After the project is selected in SO, the new created WO will link to that project.
 

 

Note: When the user enters a quantity for a part, the system will check to see if there is a minimum and/or multiple setup in Inventory for this particular part/product.


  If the order quantity doesn't meet the requirements, the statements shown below will popup and display in the item master min and mult order quantity with an OK button.   No other action is required. The user can choose to change the order quantity to match, or proceed as entered

 

 

 

The "Add Miscellaneous" button is to add any miscellaneous items to the sales order. This may be prototype items, engineering charges, or any item that is not manufactured nor is it in inventory. Pressing this button adds a line to the Sales Order and moves the cursor to the description field. The user enters the description, quantity and may then move to the pricing screen to complete the data.

The user is reminded that the scroll bars at the right side and bottom of the information box allow the information to be scrolled sideways and up or down to see additional information. 

The "Delete Line"  button is to delete a line already entered from the Sales Order. The user selects the line to be deleted from the Sales Order tab, and presses the button.

Pressing this button brings up the following dialogue box:

The user confirms the deletion and the deletion is complete. 

 

   Highlight the Assembly line item first before you depress the button.

Important Note: This action is taken AFTER the Scheduling tab is completely filled in for all add Products (assemblies).  So, first go to the Schedule tab (instructions below). Schedule the product and then return to this tab.  

The "Issue Work Order" button is to create work orders for each manufactured product items on the sales order.  Highlight all lines where there are products to be assembled. 

If user has the "SO Approval Required" box check in Sales Order Defaults & Sales Discount Type module checked, then user will be required to check the "SO Approved" box before being able to Issue a Work Order.  If the "SO Approved" box is NOT checked user will receive the message located to the right. 



If line item is on Admin Hold or Mfgr Hold user will receive one of the following messages and will be unable to Auto create a WO until the status has been changed for this specific line item.  User will be able to manually add a Work Order for this product in the Work Order Management module.

If there is only one delivery scheduled for the sales order, and the work order setup is established as automatic numbering, then the following screen appears:
 

Keep in mind though that even if you have the SO linked to a WO does not mean that the quantities will always be the same.  The link is for reference only between the two modules and they are still individual records so when any changes are made to either the SO or the WO the change will not update or be carried forward to the other.  A message is displayed to the users that they will have to make the same changes to the WO.  

 

If the user has established more than one delivery date for the sales order, then pressing this button brings up the following:

 
 

Depress the Save action button to finish creating the Work Order(s). 

After completing all of the Sales Order data, the Sales Order must be saved. Then pressing the WO List tab will display all of the work orders created for the current sales order.

Schedule Tab

There are two modes available for completing a scheduled delivery for a product: Automatic and Manual. In the Automatic mode, ManEx will take a beginning date and a quantity to be delivered each period (Days, Weeks or Months) and schedule out the delivery using the Delivery Schedule Default Days which are setup in the Delivery Schedule Default Setup module.

Clicking on the Schedule screen tab brings up the following:

Sales Order Line number:  Select the line number by depressing the LN down arrow.  The following selection will be displayed:

The first line is populated with the data from the part number entered on the previous screen.
 
The following activities are available:

Automatic Scheduling
Pressing this button enables the scheduling box and places the default lead time date in the Due Date box. (The user may establish a default number of days setup in the Delivery Schedule Default Setup module).  The user can then use that date, or enter the first (beginning delivery) date the customer expects to receive the order. The Delivery Qty screen allows the user to divide the shipment into multiple deliveries of equal parts. For example, if the order is for a total of 100 pieces, and the customer wishes delivery to be at the rate of 10 units each day, then the delivery quantity should be entered as 10. The next box allows the user to select the delivery intervals. The options are by day (DY), week (WK) (7 days) or month (MO) (30 days).

Note:
In using the term Weekly and Monthly, it doesn't matter what the holidays or what the weekends are (i.e. that they are not excluded from the total time of a week or month), but are considered when the final date is calculated.
 

 Manual Scheduling

Pressing the Add Line button enables the delivery schedule box and places the cursor in the Due Date box. The user can then enter the first (beginning delivery) date the customer expects to receive the order. Next, the Ship Date (the date the order is to leave the user’s dock) will be entered by ManEx based on the transit days entered. This date can then be modified by the user if a different date is desired. Then the scheduled quantity is entered. The Shipped quantity will be completed by ManEx when the line has material shipped against it. Additional lines may be added or deleted by pressing the appropriate button. The total number of units scheduled will be displayed at the bottom of the box, so the user can verify all units have been scheduled.

 

After you’ve scheduled all assemblies, you may go back into the Sales Order tab and issue the Work Orders for those assemblies. Please refer to the instructions above regarding the Issue Work Order button. 

Pricing Tab         

Clicking on the Pricing screen brings up the following screen:

Depress the down arrow next to the LN field. The following list will appear: 

Select the desired line number. If the user has completed the Pricing Screen for the product, then the pricing will be automatically entered. See Article #766 for more detail.

The Price Markup field is NOT editable.  This information defaults in from the Sales Price List Information module. 
 
The Customer Sales Discount field in NOT editable.  This information defaults in from the Customer Information module. 
 
Depress the "Add Rep" button to add a Sales Rep.  The following screen will appear listing all the Sales Rep's setup in the  Sales Rep Information module.
 
Highlight the Sales Rep or Reps, then depress the OK button and they will appear in the commissions box as displayed below.
 
 


Enter in the commission amount for that specific Sales Rep.

If accounting is installed,the user selects the Sales Type.
The user can select the Sales Type from the drop down list:

 

If the user has completed the Pricing Screen for the product, then the pricing will be automatically entered. See Article #766 for more detail.

The user may select if the unit is taxable by clicking on the appropriate box on the right side of the screen. The following message will be displayed if the customer is non-taxable.
 

For Sales Order Items with no Tax, leave the Tax box unchecked. No further action is required.

To Manually add US Tax (if not set up in Customer Information), enter line item and then in Pricing Screen click on Add Line and enter description of Sales Tax and Tax Amount manually.  A Sales Type for the appropriate Tax G/L number should be setup in Accounting so that it can be selected when entering the Sales Tax manually.  The full amount of the Tax will be Invoiced upon shipment of the first item so using manual sales tax entries may not be useful for shipments with multiple shipments against the same line item. 
 
Checking the Tax box in Sales Order Pricing will not calculate or add US Tax for a line item unless the Shipping Address for the particular Customer selected in the Sales Order Header has been set up. Setup the Shipping Address Tax in the Customer Information Module.

Adding a US Sales Tax or a US Shipping Charge Tax in Customer Information requires that those items added be entered in System Setup under Sales Tax Authority Table.

If a particular Customer Ship To Address has more than one US Tax (such as a Sales, Use, Excise, etc. tax), then the taxes may be entered in System Setup individually and added individually to the appropriate Customer Ship To addresses.

If there are more than one US Tax setup for a Customer Ship To Address, Manex will add up the tax rates and apply the combined percentage to the pre-tax line item total. 
 

User CANNOT manually add Foreign tax to Sales Orders or Invoices.  The Foreign tax box must be checked for the Shipping Address for the particular Customer selected in the Sales Order Header. 

 

If the Foreign tax box is checked for the Shipping Address for the particular Customer selected in the Sales Order Header.  Pricing will be listed as follows on the Sales Order Acknowledgement, Invoice, RMA, and Credit Memo:  First the Product Sub-tot AMT, the Sales Discount (if applicable), the Freight AMT (if applicable), a SUB-TOTAL,  the GST TAX (Primary tax) (Note: the Primary tax will always be displayed even if it is zero, if a Secondary Tax is present), then a second Sub-Total,  PST TAX (secondary tax), and last the TOTAL.  If no PST tax (secondary Tax), Sales Discount, or Freight is involved, then no lines would print for these items.    See the  Foreign Tax Examples.xls  attachment to see how the Primary and Secondary taxes are calculated.

 

The Primary tax and Secondary tax is divided into the Sales tax and Shipping tax on the Sales Tax reports. 

 

For Example: 

Primary Tax (GST):  144*10% (sales tax) + 0 (no freight tax is calculated) =$14.40

Secondary Tax (PST):  144*8% (sales tax) + 12*8% (Freight tax)  =  $12.48

 

Divided into sales tax and freight tax:

Sales Tax: 144*10% (sales tax)  +  144*8% (sales tax)  =  $25.92

Freight Tax  0 (from primary tax)  +  12*8% (from secondary tax)  =  $0.96

If the user wants to use a Lot Charge instead of unit pricing, click on the Lot box. This will take the unit cost as a lot charge for the item without extending the units by the price. This may be used if a flat fee is charged for a number of parts. 

Clicking on the Add Line button may enter additional charges for the product. These charges may carry a different unit price, and may be of any description.  A Non-inventory line added on this screen will be invoiced on the first shipment made for this sales order.

Work Order List Tab

Clicking on the Work Order List tab brings up the following:

Depress the down arrow next to the LN field. The following will display:

Select the line item containing an assembly for which Work Orders have been created.

This screen is for information only, providing the user with status of work orders created for the current sales order.  The user has the option of creating multiple work orders for a sales order line item. To see the Work Orders for the next line item, depress the LN down arrow and select the desired line item.

Billing Tab          

Clicking on the Billing screen tab brings up the following:

In this screen, a Bill-to address will be completed with the default address established in the Customer Information Module. The Bill-to address also may be selected from any other addresses entered in the Customer Information Module.  The first prompt is to enter the Bill-to address. The user may accept the default address, or select from any address established in the Customer Information Module. All address information in the set up will be displayed when the down-arrow is pressed at the right side of the field:

After selecting the appropriate bill-to address, the information fields on the screen are populated with the correct data.

Shipping Tab       

Clicking on the Shipping screen tab brings up the following:

As in the Billing screen, the user may select from established ship-to addresses by pressing on the down-arrow key at the right of the first field:

Once the ship-to address is established, the address fields are populated from the Customer file. In addition to the address, the Terms, FOB, Ship Via, Customer Account and Delivery Time are also populated from the Customer Information Module, if they were completed there. If not, or if the user wishes to change them, the user may select the appropriate response by clicking on the down-arrow next to the field, and viewing choices set up in the Sales Setup module ( in System Setup).
 
Note:  The user is able to edit or change the Cust Account No to match any special Ship Via pertaining to the specific order within the SO Shipping screen without the changes affecting the Customer Information module or any other pre-existing orders.

Notes Tab

The last screen, the NOTES screen, provisions are made to establish Sales Order Notes and/or Sales Order Acknowledgment Footnotes.  These notes are available on their respective screens.

Note that when any note is entered on this screen, the screen tab NOTES turns red to indicate there is data in the notes.

Once all Tabs have been complete Depress the Save action button to save changes or the Abandon changes action button to abandon changes. 

1.4. Cancel a Sales Order

To cancel a Sales Order

  1. Find the order using the Find procedures Article #838.
  2. Depress the Edit action button at the top of the screen.
  3. Enter your password.
  4. Highlight the line item you want to cancel.
  5. Scroll over to the Line Status field.
  6. Depress the down arrow.
  7. Highlight the Cancel selection, as illustrated below:



Once you have cancelled a line item on PO the following message will be displayed: 



Depress Ok and the Sales Order status will be changed to "Cancel"
 

Depress the Save action button, to save changes. Press the Red "X" to abandon changes.

Depress the Exit action button to exit the current screen and returns the user to the previous screen.

1.5. Delete a Sales order

A sales order may be deleted using the Delete Unwanted Sales Order in the System Utility Module.  This utility will allow users to delete any Sales Order record within the system as long as there are no shipments or reserved qty against it.  In addition to deleting the Sales order, the utility will also check to see if there were any linked Work Orders to that Sales Order, if any were found it will display a warning and then also generate a XLS spreadsheet for the users to review and re-establish links to new Sales Orders if desired.  

1.6. Link User Defined Fields to a Sales Order
The User Defined fields MUST be setup within Web ManEx.  For further detail see Article #5454.

The User Defined Fields can then be linked to a Sales Order or a line Item on the SO. 


To link a UDF to a Sales Order select a record in the ManEx Desktop, and select the UD action button (as displayed below).



The UDF for that section will then be displayed, and user can make changes (if applicable), Save & Exit or Cancel. 



To link a UDF to a Line Item on the SO select the line item, then select the UD action button that is located in the SO body (as displayed below)



The UDF for that section will then be displayed, and user can make changes (if applicable), Save & Exit or Cancel.