OEOE - Sales Order Entry/Maintenance

New features added, version 7.5.2, 7.5.3, 8.1, 7.5.4, 8.4, 7.5.4R4, 8.4R4, 8.5.2, 8.6R1

See Also Programs

Program OEOE, Sales Order Entry/Maintenance, is used to enter customer sales orders into the system. This program is also used to maintain sales orders until shipments are recorded against them with program OESC, Shipping Confirmation.

Hot keys in this program include:

Alt+C - Header Comments

Alt+S - Summary block

Alt+K - Header Ok

 

See Also

Sales Order Entry Parameters

Sales Order Entry Features

Restricting Customer / Item Purchases

Sales Restrictions by Low Stock Allocation

Sales Order Entry by Zip Code

Sales Order Entry by Phone Number

Taxing Procedure

Purchasing Model Components for Model Work Orders

Will Call Sales Orders

Sellable Items

Vendor and Buyer Requirements in Sales Orders and Model Configurations

Sales Order Line Renumbering

Re-pricing Sales Orders when Opened

Reserving Master Lots and Lot Control Number Ranges

Hold Codes

Comments Lists of Values

Entering Sales Orders

Posting Payments to the General Ledger

Entering Sales Representative Commissions

Canceling Sales Orders

Reserving Controlled Items

Entering Substitute and Superseded Items on a Sales Order

Creating a Purchase Order from a Sales Order

Creating Work Orders or Production Schedules from Sales Orders

Copying Sales Orders

Searching for Customer Addresses

Searching for Items

OEOE Action Buttons

Payflow Pro Payment Processing

 

 

Re-pricing Sales Orders when Opened

Sales orders can be set to have the pricing on all line items recalculated when the sales order is opened. The Initial Order Status must be set to Incomplete in program ARLM, Location Maintenance, for this feature to be used.

In program MURM, Initialization Parameter Maintenance, set the OE_REPRICE_ON_OPEN to YES to have the pricing for all sales order line items recalculated when the [Open Order] button is pressed in this program.

To recalculate pricing on the sales orders at any other time, press the [Reprice] image\ebx_1063375493.gif button in the sales order header.

For customers with the Revenue Pricing method, if the OE_QUICK_PRICE parameter in program MURM, Initialization Parameter Maintenance, is set to Y, then pricing will not occur until the sales order is opened, or until the user navigates to the Summary screen.

 

Reserving Master Lots and Lot Control Number Ranges

Lot and serial control numbers can be set up with master lot control numbers. Master lots are used as an overall control number for which sub lots exist.

The master lot control designator entered in program SPMM, System Parameters/Default Maintenance, is used to determine what part of the control number is the master lot. For example, if the master lot designator is /, and the control number is ABC/123, the master control number is ABC, and the sub lot is 123.

Master lots can be received from purchase orders, issued to work orders, and shipped to customers with control number ranges.

 

Shipping lot ranges

When a control number is shipped to a customer using a control number range, the quantity shipped is divided by the number of control numbers in the range. This amount is shipped from each control number in the range. Any remaining quantity is shipped from the last control number in the range.

Numbering and Renumbering Sales Order Lines

Sales order line numbers are assigned by the program as the line items are entered. You can enter them manually.

To enter a sales order line in between two other line items, place the cursor on the bottom sales order line. Press [New Record].

To renumber all line items, press the [Renumber Lines] image\ebx_518836331.gif button.

Comments Lists of Values

The setting of the COMMENT_LOV_OEOE parameter in program MURM, Initialization Parameter Maintenance, determines whether the boilerplate list of values or a field editor will be displayed when the user double-clicks in the comment text field in this program.

See the Comment Lists of Values in Sales Order Entry section for more information.

 

Entering Sales Orders

1. In the Cust No field, enter the customer number.

2. In the Initials field, enter the initials.

3. In the Req Date field, enter the date that the customer requires the order. The default required date is calculated according to the Ship Date Calculation pop-list setting in program ARLM, Location Maintenance, but it can be changed.

4. In the Loc field, enter the sales location for this sales order.

5. In the Ordered field, enter the date the sales order was placed.

6. In the Sale Rsn field, enter the sales reason code.

7. In the Cust PO field, enter the customer's purchase order number for reference, if desired. If the PO number required flag is set to on for the customer in program CMMM, Customer Master Maintenance, a purchase order number must be entered.

8. In the User Ref fields, enter the information for which this sales order was entered.

9. In this Ship date field, enter the date that the order is scheduled to be shipped. This date becomes the default due date for the order lines. . The default ship date is calculated according to the Ship Date Calculation pop-list setting in program ARLM, Location Maintenance, but it can be changed.

10. In the Order No field, the sales order number is assigned when the sales order is committed, or you can manually enter the sales order number.

12. Sales representatives can be assigned to a sales order using the [Sales Reps] button in the header. For more information on sales representative commissions, see the Entering Sales Representative Commissions section.

12. Order codes, including ship via, FOB, terms, and freight, can be changed when you press the [Order Codes] button. These codes default from the customer record in program CMMM, Customer Master Maintenance. The following information can also be changed.

13. Addresses can be changed with the [Address] button.

14. If the sales location needs to be changed, you can change it with the [Locations] button. You can also assign an employee to the sales order, or change the initials with this button.

15. Order tracking can be viewed and maintained with the [Tracking] button.

16. When you have completed entering the header, press [Commit].

17. The cursor is moved into the Item No field in the lower block. In the Item No field, enter the item number that is being ordered.

17. In the Qty Order field, enter the order quantity.

18. In the Due Date field, enter the date by which this sales order line must be shipped.

19. Set the Override flag to the desired setting. When this flag is set to on, you can change the price in the Unit Price field.

20. In the User field, enter the user discount percentage for the sales order line.

21. In the Addtnl field, enter any additional discount percentage for the sales order line.

22. In the Flat Disc field, you can enter a flat discount, if desired.

23. You can change the extended price in the Extension field, if desired.

24. In the List Price field, a list price must be entered for non-stock items.

25. The cursor goes to the Unit Price field. The unit price defaults to the list price, and cannot be changed unless the Override flag is set to on.

26. You can place an order line on hold automatically by setting the Hold flag to on.

27. In the Plant field, you can change the default ship from plant. This is the plant from which the inventory will be shipped and for which sales allocations are made for this order line.

28In the Cust PO field, the customer purchase order number from the header is entered automatically, but can be changed. This is the customer purchase order number for which this sales order line was entered.

29. In the Line field, the customer purchase order line number from the header is entered automatically, but can be changed. This is the customer purchase order line number for which this sales order line was entered.

30. Press the [Other Details] button. The Other Details button has six tabs.

 

Pricing Tab
Tax/Cost/Flags Tab

If the item is a non-stock item or non-maintain on hand item, enter the unit cost.

The cost in the Unit Cost field may be able to be maintained or overridden for items other than non-stocked items. If the cost can be overridden, set the Override Cost flag to on and enter the desired cost in the Unit Cost field.

For stocked items, the unit cost will be displayed if the Show Unit Cost flag in program ARLM, Location Maintenance, is set to on. This cost is entered automatically from the cost record or from the purchase order if this is a drop ship invoice line.

If the cost is changed in the item cost record before the invoice is shipped, when the invoice is shipped, the unit cost will be updated to the current unit cost.

General Tab
Purch/WO/Pick Tab

Purchasing/Inventory Section

Work Orders Section

Wt/Frt/Surchg Tab
Misc Tab

31. For modular items, use the [Configure] button. For more information, see the information on program MOCF, Modular Bill Configuration.

32. Once a modular item has been configured, or if the item is a kit, you can view the components of the modular item with the [Model Details] button.

33. To view the units of measure that can be used for the item, press the [Unit Conversions] button.

34 All pricing from the pricing matrix for the item can be viewed with the [Pricing] button.

35. To view buying and selling information for the item, press the [Positions] button.

36. The available to promise inventory information can be viewed with the [ATP] button.

37. Item quantities and locations can be viewed with the [Stock Status] button.

38. Items can be substituted or superseded. For more on superseding and substituting items, see the Entering Substitute and Supersede Items on a Sales Order section.

39. Sales representatives can be credited with a line item using the [Sales Reps] button in the lower block. For more on sales representative commissions, see the Entering Sales Representative Commissions section.

40. Press [Commit].

41. Press the [Summary] button in the order header.

42In the Freight Charges field, enter the freight charges, if desired. In the Freight Cost field, you can enter freight cost, if desired.

43In the Misc Charges fields, enter miscellaneous codes and charges, if desired.

44In the Disc Pct field, enter the discount percentage. If you enter a percentage here, the discount you enter will be taken from the order total.

45In the Prepaid Payments (deposit) field, enter any deposit promised by the customer.

46In the No of Cartons field, enter the number of cartons for the order, if desired.

47In the Carrier field, enter the freight vendor, if the order will be shipped through an outside vendor.

48. Set the Keep Inventory As Customer Owned FG flag to the desired setting. This flag determines whether inventory on this sales order will be stored as customer owned inventory.

49. Press [Commit].

50. You can enter payment information in the lower block of the Summary screen, if appropriate.

Entering Sales Representative Commissions

1. There are two types of sales representative commissions that can be entered - line item and sales order.

2. Enter the sales representative who will receive the commission. The sales representative assigned to the customer in program CMMM, Customer Master Maintenance, defaults as the sales representative in the header.

3. For sales representatives entered in the lower block, enter the commission code. The commission code you enter is used to determine the commission rate for the sales representative and line item.

4. Enter the commission value percent. The commission value percent does not have to equal one hundred. If there are five sales representatives assigned to the order or to an order line, each of them can have their commission calculated from one hundred percent of the order total.

5. Press [Commit].

Canceling Sales Orders

There are two ways to cancel a sales order in this program.

When the sales order is cancelled, if any purchase orders or work orders were generated for the items on the sales order, a warning message will be displayed stating that the work order or purchase order is still open and should be cancelled.

Reserving Controlled items

1. Controlled item numbers can be reserved for a sales order.

2. Press [Reservations].

3. Enter the quantity that you want to reserve in the Qty Reserved field. The maximum quantity that can be reserved is displayed in the Max Reserve Qty field.

4. If the item that you are reserving is a lot controlled item, enter the lot control number from which you are reserving the entered quantity in the Control No. - Start field.

5. If the item that you are reserving is a serial controlled item, you can reserve a single control number or a range of control number depending upon the quantity entered.

6. Press [Commit].

7. Repeat steps 4 to 6 until all quantities and control numbers that you wish to reserve have been entered.

8. You can view all reservations for the item number. To view all reservations, press the [Show All Reservations] button.

9. If a sales order line with a reservation is deleted, or if the sales order is cancelled, the reservation is also cancelled.

10. Reserved control numbers are shipped in program OESC, Shipping Confirmation, dependent upon certain parameters.

11. If the Keep Reservation History flag in program SPMM, System Parameters/Default Maintenance, is set to on, the system will record changes made to reservation records for work orders and sales orders.

12. Control number reservations can be retained for backorders. If the OE_RESV_NO_BO is set to YES in program MURM, Initialization Parameter Maintenance, the reservations will be retained on the backorder. Otherwise, they will be cleared after the original order is processed through OESJ, Sales Order End of Day and Journals.

 

Entering Substitute and Supersede Items on Sales Orders

1. To substitute one item for another, put your cursor on the desired line item and press the [Substitute] button. Once a substituted item is committed, the item can not be changed. You must delete the item and re-enter it.

2. If an item has been superseded in program ICAM, Supersede/Substitute Maintenance, then when the item that has been superseded is entered, the program will return an alert box stating that the item has been superseded by another item. The item that supersedes the item that you entered will then be automatically inserted in the record. Once a superseded item is committed, the item can not be changed. You must delete the item and re-enter it.

3. For more information on entering supersede and substitute items into the system, see the Substituted and Superseded Items section.

 

Creating Purchase Orders from Sales Orders

Purchase orders can also be created for sales order lines for model items when the [Open Order] button is pressed if the Create PO flag is set to on under the [Other Details] button.

1. Enter the sales order.

2. The sales order can be a direct, or drop ship, order, but you can also enter purchase orders for non-direct sales orders.

3. Press the [Other Details] button if you need to maintain the Direct flag.

4. Set the Direct flag to on, if this is a direct, or drop ship order. If it is not, leave the Direct flag set to off.

5. Press [Commit]. Return to the main page.

6. Press the [Work Orders/PO's] button in the header. If the item is set to discontinued in ICEM, a Purchase Order or Work Order can be created only if the ALLOW_PO_WO_ON_DISCONTINUED MURM is set to Y. If set to N, neither purchase orders or work orders can be created for discontinued items,.

7. In the Vendor No field, enter the vendor for this sales order line. If a preferred vendor exists for the item, the preferred vendor will be entered automatically when the sales order line is entered.

8. Set the Create PO flag to on for all sales order lines for which you wish to create purchase orders. If the flag was set to on for the sales order line on the Other Details screen, it will be set to on here.

9. Press the [Create WO/PO] button. A purchase order will be created in program POEM, P.O. Entry/Maintenance, where it can be viewed and maintained.

All comments containing the type entered in the parameter will be copied. For example, if the type entered is PO, comments with PO, POR, POQ, QAPO, etc will be copied.

 

Creating Work Orders or Production Schedules from Sales Orders

Work orders and production schedules can also be created for sales order lines for model items when the [Open Order] button is pressed if the Create WO flag is set to on under the [Other Details] button.

1. To create a work order, the manufacturing method pop-list in program ICPM, Inventory Planning Data Maintenance, must be set to work order.

2. To create production schedule, the manufacturing method pop-list in program ICPM, Inventory Planning Data Maintenance, must be set to Prod Sched.

3. Enter the sales order.

4. Press the [Work Orders/PO's] button in the header.

5. Set the Create WO flag to on for all sales order lines for which you wish to create work orders.

6. Press the [Create WO/PO] button. The work order or production schedule will be created in the default manufacturing enterprise and plant for the item from program ICEM, Item/Plant Maintenance.

image\ebx_1113661474.gif

7. The production due date of the work order or production schedule is determined by the production delay days entered in program SPMM, System Parameters/Default Maintenance, and the order line due date.

Copying Sales Orders

1. Query the sales order that you want to copy.

2. Press the [Copy Order] button.

3. The program will display the order information for the selected order.

4. See program OECO, Sales Order Copy, for more information.

 

Searching for Customer Addresses

 

Press the [Search] image\ebx_-1955635254.gif button to access this screen. You must enter a zip code range, a customer name, or an address name to perform a search. Press the [Clear] button to clear any earlier searches entered in this program.

1. In the Zip From field, enter the first zip code in the range of zip codes for which you are searching for customers and addresses.

2. In the Zip To field, enter the last zip code in the range of zip code for which you are searching for customers and addresses.

3. In the Customer Name field, enter the customer name for which you are searching for addresses.

4. In the Address 1 field, enter the first address line for which you are searching for addresses.

5. In the Country Cd field, enter the country code for which you are searching for addresses.

6. Set the Bill To flag to on to search the customer master addresses on the Address Tab in program CMMM, Customer Master Maintenance.

7. Set the Mail To flag to on to search the mailing addresses in program MTMM, Mail To/Prospect Input for Catalogs.

8. Set the Ship To flag to on to search the ship to addresses on the Shipping Tab in program CMMM, Customer Master Maintenance.

9. Set the All flag to on to search all three addresses.

10. Press the [Search] button to find the addresses that match the entered criteria.

11. If you wish to only view addresses for customers that have placed orders in the last 3 years, click on the [Quick Search] button instead of the [Search] button.

12. The addresses that match the entered criteria will be displayed in the middle block.

13. When you have located the desired address record, put the cursor on record, and the contacts assigned to it will be displayed in the lower block.

14. To select a customer and address, put your cursor on the desired record in the middle or lower block and press the [Select] button. The following information will be pulled to the sales order header.

15. Press the [Return] button at any time to return to the main screen without selecting anything.

 

Searching for Items

 

1. Enter the desired search criteria in the fields in the upper block. Press the [Clear] button to clear any earlier searches entered in this program.

2. Press the [Search] button to select the display the items that meet the entered criteria.

3. In the lower block, put your cursor in the Item field for the desired item.

4. Press the [Select] button to enter the selected items as a sales order line item. The plant will also be returned to the item line.

5. Press the [Return] button to return to the sales order entry screen without selecting an item.

 

OEOE Action Buttons

Address

Maintain the customer ship to, sold to, invoice to, and bill to addresses. If DROP is entered in the ship to code field for the ship to address, the address is cleared and a new address can be entered.

ATP

View available to promise information for the selected item.

Calc Discount

Press this button to apply the order level discount to all sales order lines. For more information, see the Order Level Discounts section of the Sales Order Entry Features.

Cancel

Cancels the sales order.

Configure

Press this button to configure the modular item. For more information about configuration of modular items, see the Modular Bill manual.

When a purchase order or work order has been created for the sales order line, pressing this button will display the model configuration tree for the model item in a query-only version of program MOCF, Modular Bill Configuration.

Copy Order

Press this button to create a new sales order or quotation by copying an existing sales order or quotation. New orders or quotations can be created from sales orders with any status. See program OECO, Sales Order Copy, for more information.

Create WO/PO

Create work orders, production schedules, and purchase orders for the selected sales order lines.

Deselect All image\ebx_-1278534720.gif
Press this button to set the Create PO or Create WO flag to off for all sales order lines.
Freight

Press this button to return the custom calculated estimated freight charge to the Freight Charges field, if applicable.

Item Search image\ebx_-1955635254.gif

Press this button to display the item search screen. For more information, see the Searching for Items section

Location

Maintain the location information for the order, including financial enterprise, bank, manufacturing enterprise, and plant information.

Model Details

Press this button to view information about the component items of the selected model item.

Open Order

When the sales order status is I - Incomplete, press this button to change the sales order status to O - Complete. The sales order status will not change until this button is pressed. Incomplete sales orders cannot be staged in program OSEM, Stage Sales Order for Shipping, or shipped in program OESC, Shipping Confirmation.

Order Codes

Maintain the ship via, freight, FOB, terms, and hold codes for this order. You can also maintain the acknowledgment, ship complete only, pick print, and pack print flags.

Order Tracking

Maintain the order tracking information.

Other Details

Maintain line item details, including the direct flag and vendor information for direct orders.

Positions

View buying or selling information for the item. This includes customer or vendor, quantity, price, and sales order number or purchase order number.

Pricing

View the pricing information for the selected item, including book, list, quantity, special, and contract prices.

Promotions

Press this button to view the promotional items for this customer and sales order line.

Quick Search
Under [Search], press this button to query only customers that have placed orders in the last 3 years. This button is only displayed when the CUST_QUICK_SEARCH_BUTTON parameter is set to YES in program MURM, Initialization Parameter Maintenance.
Remove Order Level Discounts

Press this button to remove all order level discounts from the sales order.

Renumber Line Items

Located under the [Renumber Lines] image\ebx_518836331.gif button, press this button to complete the renumbering process.

Renumber Lines image\ebx_518836331.gif

Press this button to renumber the line items. Enter the increment by which you wish to renumber the line items. Press the [Renumber Line Items] button, and the line items will be renumbered using the entered renumber increment.

Reprice image\ebx_-1954182126.gif

Press this button to re-calculate the pricing of the order lines according to the new catalog ID entered.

Reservations

Use to reserve lot and serial controlled quantities for specific orders. You cannot reserve non-controlled items.

Sales Reps

In the upper block, press this button to assign sales representatives to the sales order. Sales representatives entered with this button should have a commission scheme of volume. The customer's sales representative from program CMMM, Customer Master Maintenance, is the default, but other sales representatives can be added. The commission code for the sales representative from program SMMM, Sales Representative Master Maintenance, is always used, no matter what commission code is entered here.

In the lower block, press this button to assign sales representatives to a line item. Sales representatives entered with this button should have a commission scheme of product. The commission code entered here is used to determine the commission rate for the sales representative and item entered for the line.

Save

When the sales order status is O - Complete, this button commits the header and places the cursor in the lower block for item entry.

Save New Ship To image\ebx_527884913.gif

This button allows you to enter and update ship to codes for the customer from sales order entry. For more information, see the Ship To Code Updates section of the NDS Help.

Search image\ebx_-1955635254.gif

Press this button to display the customer address search screen. For more information on searching for customer addresses with this screen, see the Searching for Customer Addresses section.

Under [Search], press this button to query the customer addresses that match the entered criteria.

Select

Under [Substitute], press this button to substitute the selected item for the entered item.

Under [Search], press this button to return the following information to the sales order.

Select All image\ebx_-108529838.gif
Press this button to set the Create PO or Create WO flag to on for all sales order lines.
Ship To image\ebx_956889131.gif

This button brightens when there are multiple ship to addresses for the customer. Press the button and a list of values is displayed from which you can pick the desired ship to code.

Show all Reservations

Press this button to view all reservations for the item.

Stock Status

View stock status information, including on hand, available, and on order quantities for the selected item.

Substitute

Press this button to substitute another item for the selected item. Substitute items are set up in program ICAM, Supersede/Substitute Maintenance.

Summary

Maintain the order summary information, including extra charges, deposits, discounts, and the carrier.

Telephone image\ebx_-1383487669.gif

Press this button to select the customer for the sales order according to telephone number. For more information see Sales Order Entry by Phone Number.

Unit Conversions

View the unit of measure conversions, stock and sales, for the selected item.

Update Card Info

On the Payflow Pro Response screen, press this button to update the credit card information for this customer in program CMCM, Customer Credit Maintenance, with this credit card, AVS Address, and AVS Zip.

Payflow Pro image\ebx_417883968.gif

Press this button to submit the payment to the Payflow Pro software for payment processing. Only payments for which the payment type is designated as Credit Card in program SPPT, Payment Type Maintenance, can be used. For more information see the Payflow Pro Payment Processing section.

Payflow Pro Response image\ebx_1398869658.gif

View the codes sent back from Payflow Pro when the credit card was authorized.

Work Orders/ PO's

Press this button to open a screen displaying the sales order lines. You can create work orders and purchase orders for the sales order lines. Set the appropriate Create flag to on and press the [Create WO/PO] button to create the purchase orders and work orders.

To create a purchase order, you must enter the vendor information under [Other Details] or on this screen and set the Create PO flag to on. When the purchase order is created, it becomes possible for you to view the purchase order in program POEM, Purchase Order Entry/Maintenance. In program OEOE, Sales Order Entry/Maintenance, the purchase order number will also be displayed.

To create a work order or production schedule, set the Create WO flag to on. The type of created is decided from the default in program ICPM, Inventory Planning Data Maintenance, where the Manufacturing Method pop-list contains that default. The work order will be created in the default manufacturing plant entered for the item in program ICEM, Item/Plant Maintenance.

If the Cascade WO Release in OE flag is set to on for the line item in program ICPM, Inventory Planning Data Maintenance, work orders will be created for the line item and its component items. For more information, see Work Orders and Production Schedules section.

Zip Code image\ebx_1245844674.gif

Press this button to select the customer by zip code. You must have entered your initials before you can press this button. For more information, see the Sales Order Entry by Zip Code section.