Lines (RS41)

Additional Information
More Detail Data Window
Order Entry of non-PP Product Types
Troubleshooting Retail Sales

The Lines folder in Retail Cash Counter Invoice Entry (RS41) allows you to enter the Product Detail lines, Comment lines and Supplementary charge lines for the current Sales Order entered in the Header section.

Using the Lines folder:

  1. Enter or select from the query a Product in the Product field or enter the short cut code to open the Product Browser with a specific Browse Method selected. Once a Product code is entered, tab to the Qty Order field.

    • The following messages (if applicable) automatically display for the current Product:

      • Whenever an item is ordered in one of the transaction programs (OE30, IN41 or RS41), a check is performed to determine if the current customer has backorders or active quotes for the selected item. If a backorder or active quote exists, the Backorders & Quotes Already on File screen displays to alert you of the Customer's backorder/quote position for that Product. This allows you to ensure that the current request for the Product represents a new Order, and not a duplicate of what is already on backorder.

        • The Backorders & Quotes Already on File screen displays information related to the backorder(s) and active quotes, including the type, order number, line, customer PO number, order/quote date, quote expiry date, backorder/quote quantity, price, 'per' value, and total backorder and quote quantities. Click OK to close this screen.

      • If the current Product is on a Price List that is assigned to the current Customer but the Price List has expired, the following message displays: "Customer Price for (Price List xxxxx) has expired! OK". This is only a warning message. Click OK to close the message window and return to the Lines folder.

      • If the 'Enable Same Product Warning' field is selected in Company Control Initialization (CC00/Order Entry) and you enter the same Product code on a new line on the Sales Order, the following message displays: "The Product is already on this Sales Order at Line xxx. Do you wish to continue? Yes/No". Select Yes to continue entering the current Product. Select No to abort the entry of this Product.

      • If the Product entered on a Sales Order is flagged with a 'Season Code' in Products (IM13/Selling), and this Season Code is not the same as the Season Code assigned to the first Product on the Sales Order, the following warning message displays: "Warning! Season code (xxxxxxxxx) on order is different than Season code on product (xxxxxx). OK". Click OK to close the message window. This is only a warning message and you can still enter the Product on the Sales Order.

      • If the Product is not associated with any Price List for the current Customer, the following message displays: "Based on the current pricing environment, the price for product (Product Code displays) could not be determined. Please ensure Product Code is assigned to the appropriate price lists. For information on setting up and maintaining price lists, please see the Help for program IM18. OK". Click OK to close the message window and then set up a Price List for the Product in IM18 before continuing with the Order.

      • If the Product entered on the sales order has a customer product code assigned to it (from IM40) as well as a product code in IM13, the following message displays: "The product code (xxxxxx) is also a customer product code for your code (x0x0x0). Are you entering the customer's product code? (Answer YES if you are entering the customer'’s product code or answer NO if you are entering your product code). Yes/No".

    • Once a Product code is entered, the following information automatically populates the Lines folder:

      • The Price field automatically displays the 'Best Price' for the Product from all Price Lists based on Quantity Break 1.

      • The Per factor displays for the selected Price.

      • The Discount displays for the selected Price, if applicable.

      • The Explosion button Explosion becomes available if the current Product is an Assembled Set. When you select the Explosion option, Product Consolidated Inquiry (IC45/R3) opens directly onto the 'Set Explosion' folder. The 'Set Explosion' folder allows you to view all of the components of an Assembled Set before adding it to the Sales Order.

        • For more information on IC45/R3-Set Explosion, click here.

      • The Picture icon Picture icon is always available, but only displays a picture of the Product when Product has a Picture File assigned in IM13/Misc. If the Picture File is not identified in IM13, the following message displays: "A picture is not available from the HOST for this product. OK". Click OK to close the message window.

        • When a Picture File is assigned in IM13, the picture automatically displays in a window 'over' OE30. You must close this window by clicking the 'X' at the top right of the picture or by clicking on the 'Exit' option under File on the menu bar before you can resume work on the current Sales Order.

        • Pictures for Products are helpful to customer service representatives in identifying the correct Product desired by the customer, and in describing features of the item to the Customer.

      • The Product Description (both first and second Description fields) automatically display from IM13/Header.

      • If the Product has an Internet 'e-Address' setup in IM13/MISC, the Web icon Click the web button to visit the site displays. Clicking this icon automatically launches the Internet site for the Product.

      • If the product has an Intranet 'e-Address' setup in IM13/MISC, the Intranet icon Click the intranet computer button to visit the site displays. Clicking this icon automatically launches the Intranet site for the Product.

      • The Prices and associated Quantity Breaks are displayed from the Master Price list (IM13/Pricing) for the Product/Customer.

      • The 'Price List Name' and the the 'Price List Type' that qualify as the 'best price' for this Product automatically display from Product Price Lists (IM18). The 'Price List Name' and 'Price List Type' display Q1 if a Master Price List is selected. Caution: This changes once an Order Quantity is entered. For example, if a Master Price List has 2 Quantity Breaks and a quantity for QB2 is entered, QB2 displays.

      • The Available quantity of the Product in the current Warehouse displays.

      • The 'Stock Units' for the Product display from IM13/Stock.

      • The Split Qty for the Product displays from IM13/Stock.

      • The Assortment Code for the Product displays from IM13/Selling, if applicable.

      • The #Pcs/Sell Unit for the Product displays from IM13/Stock.

      • The Cust's No. for the Product displays from ustomer Part Numbers (IM40).

      • The Supplr's Product Code displays from P/O Purchasing Info (PO13/Purchasing).

  2. In the Qty Order field, enter the total quantity ordered by the current Customer and click Update or press Enter.

    • If the Transaction Type is 'Credit Note' or 'Retail Credit', the More Detail Data window automatically opens for the entry of an appropriate TAT code for the credit. For more information on the More Detail Data window, click here.

    • If the Transaction Type is 'Retail Credit' and a positive quantity is entered, the following message displays: "This is a CREDIT NOTE. Should this really be a positive quantity? Yes/No". Select Yes to accept the positive quantity entered. Select No to stop the entry and return the cursor to the 'Qty Order' field.

    • The Qty Ordered can be either a positive or negative number. The quantity entered must be between 99999.99 to -99999.99 or 9999999 to -99999999. If you exceed these quantities, the following message displays: "Quantity must be in the range 99999.99 to -99999.99 or 99999999 to -99999999. OK". Click OK to close the message window.

    • Depending on the 'Order Type' selected on the General folder, and how the Product is set up in IM13 and in P/O Purchasing Info (PO13), one or more of the following messages display:

      • If the Order Type selected is 'Regular' or 'Sample' on the General folder, no checks for the quantity entered in the Qty Order field are performed.

      • If the Order Type is 'FOB':

        • In Enterprise 5.1 and higher, the Quantity Ordered is compared to the GTIN flagged 'Default Costing' in PO13/Pack Info for the current Product. If the Order Quantity is less than Default Costing record's quantity, the following message displays: "Invalid quantity. Minimum order quantity is (xx). Master Carton Quantity is (xx). Do you wish to continue? Yes/No". Select Yes to accept the Ordered Quantity. Select No to cancel the request and return to the 'Qty Order' field.

        • In Enterprise 5.0, the Quantity Ordered is compared to the Master Carton - Actual Quantity in PO13/Pack Info for the current Product. If the Order Quantity is less than Master Carton - Actual quantity, the following message displays: "Invalid quantity. Minimum order quantity is (xx). Master Carton Quantity is (xx). Do you wish to continue? Yes/No". Select Yes to accept the Ordered Quantity. Select No to cancel the request and return to the 'Qty Order' field.

      • If the Qty Order is greater than the stock available for the current Product and the Product is assigned a Substitute Product(s) in Substitute Products (IM14), the following message displays: "Insufficient stock. Do you wish to review available substitutions? Yes/No". Select Yes to open the 'Available Substitutes' list. Select No to close the message window and continue with the current Product.

        • The Available Substitutes screen contains the Product code, Supplier's Product code, Product Description as well as the Remark and Equivalent flag from IM14, and the Available and On Hand stock for the Substitute Product. Double click the Product you wish to substitute for the current Product. The screen closes and the original Product is replaced with the selected Substitute Product. If you decide NOT to select any of the Substitute Products, click the X in the upper right hand corner of the screen to close the window.

      • If the Product is assigned to a Contract Price list for the current Customer and the number of units ordered surpasses the maximum quantity entered for the Contract Price list, the following message displays: "Units ordered are greater than contract allows by (xxx) units. OK". Click OK to close the message window. You can still ship the units entered, but the entry should be reconsidered.

        • Note: This message only displays when the 'Maximum Qty' field is greater than zero for the Contract Price List in IM18/Price List-Products or IM18/Products-Price Lists.

      • If you want to check the availability of the Product in other Warehouses, click on the query associated with the 'Qty Order' field. The Availability of Product screen displays the availability of the current Product in all Warehouses. If there is insufficient stock in the current Warehouse, you can arrange for a stock transfer to fill the current Order or you can create an Order with an alternate Warehouse.

        • The 'Availability of Product' screen displays the following information for each Warehouse:
          • Available
          • On Order
          • In-Transit
          • Totals

        • The list is for information purposes only. When you have finished reviewing the availability, click OK to close the window.

    Once a quantity is entered in the 'Qty Order' field, the system automatically performs the following tasks:

    • The 'Standard Pricing Routine' re-evaluates the Price to reflect the best price for the Quantity entered.

    • For Companies using Internal Stock Control, the proposed Backorder and To Ship quantities are calculated based on the Inventory position at that point in time. Note: The quantity is reserved (to update its availability) once the line is Updated .

    • If the Average Cost for the product is zero, then the More Detail Data window automatically opens for the entry of an override cost (if applicable). For more information on the More Detail Data window, click here.

  3. Once the Order Quantity is entered, you can tab to the B/O (Back order) field to manually enter a quantity or use the enter key to update the line.

    • Even if there is no stock or negative stock on hand for the selected Warehouse, the B/O field defaults to zero except when the Product is Lot Controlled or Serial Controlled at the time of Receiving or Lot Conrolled. In either case, there must be stock on hand when you enter the Product. You can backorder any Type of product in RS41 by manually entering the quantity in the 'B/O' field.

      Note: If there are backorders on Invoices, a Sales Order is produced for the backordered quantities when Invoice and Credit Note Update (IN43) is executed when the 'Accept B/O' flag is selected on the General folder.

  4. The To Ship field defaults to the 'Qty Order' amount. If you have entered a B/O quantity you must manually enter the To Ship quantity. To accept the quantity displayed, press Enter.

    • If you increase the 'To Ship' quantity, the following message displays: "You are about to add ## unit(s). Continue? Yes/No". Select Yes to accept the new quantity or select No to cancel the request. If you select 'Yes' and update the line, the 'Qty order' field is also updated with the same quantity as the 'To Ship' quantity.

    • If you decrease the 'To Ship' quantity, the following message displays: "You are about to cancel ## unit(s). Continue. Yes/No".

      • Select Yes to accept the revised quantity or select No to cancel the request.

      • If you select 'Yes' and update the line, the following message displays: "Is this a customer cancellation due to inventory availability? Yes/No". Select Yes if this is a Customer cancellation or No to cancel the request.

      • If you do not want the cancelled quantity to be back ordered, change the Qty ordered and the To Ship quantity.

  5. The Price field is based on the Pricing Routine. The Pricing Routine has a 'Best Price' or 'Hierarchy' Price Control as defined in CC00/Support. The Pricing Routine looks at the pricing flags in SU13 for the Customer in order to determine where to look for the Price for this Customer/Product combination. Press Tab to accept the Price displayed in the 'Price' field.

      For more information on Customer pricing in SU13, click here.

  6. The Per field defaults to the 'Unit of Measure' assigned to the Quanity Break associated with this Order line as defined in IM18. You can override the default 'Per' by entering or selecting from the query an alternate Per code; press Tab to accept the entered code in the 'Per' field.

    • Changing the 'Per' field may change the extension of the current Order line. For example, the current Per is EA and the factor is 1, and you enter a quantity of 10 for $10.00, the line extension is $100.00. If the Per field is changed to a Per that has a factor of 12, the extension for the line is 8.33 (100 (single unit value)/12 (per factor) * 10 (Qty ordered) = 8.33)

  7. The Discount field defaults to the Discount maintained in IM18 for the selected Price List for the current Order line. You can override the Discount by entering a new Discount or removing the existing Discount. Note: If you override the default Discount percent, the override percent is applicable to this Order detail line only. Press Tab or Enter to accept the Discount value.

    • The 'Discount' field may represent a Chain discount, a Fractional discount or a Percent discount, as per the following examples:

      • 30/10/5 (Chain discount)
      • 33.333 (Fractional discount)
      • 33 (Precent discount)

    • Note: The Discount percent assigned to Order detail line is retained for the life of the Order detail line, i.e. the Discount applied on the Customer Invoice even if Pricing Table entries have since changed.

  8. In the Tat (Transaction Analysis Table) field, enter or select from the query the TAT code required. TAT codes are defined in Invoice TATs (IN02). If the default TAT code is correct, you may Tab through this field.

    • Certain Order transactions, such as Orders for no charge replacement of goods, have a different effect on Sales Analysis files and Inventory balances. For example, a no-charge Invoice reduces the Product quantity-on-hand, but does not update the Sales dollar fields in the Sales files.

    • The TAT code set up in IN02 is defined by a series of "Yes/No" responses to questions related to the updating of Sales Analysis totals and Inventory balances. The Invoice and Credit Note Update (IN43) examines the TAT flags for each Order detail line and updates Sales and Inventory files accordingly.

      Note: The default TAT code is 'REG'. If, however, you change the TAT code on an Order line, the new TAT code is used on every following line for the entire Sales Order (unless you manually change the TAT code again). When you close the Sales Order and open the Order at a later date, the TAT code from the last line entered is the TAT code assigned to any new lines on that Sales Order.

  9. When all of the information for the Order detail line is correct, click Update. Once the line is updated, the following messages may display depending on the stock position of the Product and/or how the Product is maintained:

    • If the Product entered is on Future Orders that are nearing their Release date and there is insufficient stock, the following message displays: "WARNING! Insufficient stock available to fill Future Orders nearing their release date. OK". Click OK to close the message window. You can continue to enter the current Product or you can enter a different Product.

    • If stock is being depleted by the Order detail line, the message following message display: "Warning Depleting Stock, OK." Click OK to close the message window.

    • If there is no 'Min. Gross' or 'Max. Disc' Percentages set up for the Master Price list in IM18 or the dollar value entered violates the percentages in these fields, the following message displays: "Warning, Discount is greater than maximum allowable on this product. OK". Click OK to close the message window.

  10. When all of the messages are cleared, the Order line automatically displays in the detail List Box with a line number assigned to it. The list box includes the Product code, Qty Order, B/O quantity, To Ship quantity, Price (for a single unit), Per factor and discount for every Order line.

    • Note: If the 'Split Case and Inner' field is selected in CC00/Order Entry, then the current Order line is split onto two seperate lines if the Order Quantity is:

      • Greater than the SKU Qty of the Default Costing record defined in PO13/Packing Info for Enterprise 5.1.

      • Greater than the 'Split Qty' defined for the Product in IM13/Stock for Enterprise 5.0.

  11. The previous steps describe the Order entry of a Purchase Product or a Product defined as a 'PP' Product in IM13/Stock. Additional fields and pop-up window are available for other types of Products. For more information on the entry of different types of Products, click here.

  12. The Detail Line List Box at the bottom of the RS41/Lines folder is a display of all items currently on the open Sales Order. Each line in the list includes the line number, and relevant information about the Product including quantity ordered, shippable and price per unit.

    The following information displays for each line in the List Box:

    • Line number
    • Product code
    • Quantity Ordered
    • Quantity Backordered
    • Quantity To Ship
    • Unit Price
    • Per Unit of Measure
    • Discount Percent

    Other, non-Product lines that may display in the List Box include:

    • Comments
    • Supplementary Charges

  13. The Line field (to the left of the UDI button) is used as an alternate means to recall an Order detail line for modification. You can enter the line number directly into this field and the Line is recalled.

    Note: If you are working with Models or Assembled Sets, you cannot recall the components. When you recall a Model header and make adjustments to the quantities or the Price, the following message displays: "Modify any model components? Yes/No"; select Yes to modify the components of the Model or select No to close the message window and update the line. When you recall an Assembled Set, no message displays when the quantities or Price are changed; when the line is updated, all the components of the Assembled Set are automatically be updated.

    • Note: Line numbers are generated by entering Products, Supp Charges and Comments to the Sales Order and Updating the line.

    • Line numbers are computer-generated numbers assigned to each new Order detail line. The next available number is automatically displays as each new Order detail line is entered.

    • An existing Order detail line may be recalled for modification or deletion by its line number.

The following table outlines the functionality of each button on the Lines folder in RS41:

Button Label Icon Functionality
Supp. Charge Supp. Charge The Supp. Charge button accesses the Supplementary Charge screen. This enables you to enter a Supplementary Charge detail line, for example, a non-product charge such as Freight. For more information on Supplementary Charges click here.
Note: A Supp. Charge can be set up to give a discount off an Invoice value. If the Supp. Charge appears as the last line of the Invoice, then the discount is calculated on the value of all lines above. If the Supp. Charge prints between lines, then the discount is calculated on the value of those lines appearing above it. During Order Entry, you can leave the 'Units' field on the Supplementary Charges screen blank.
Comments Comments The Comments button accesses the Comment screen. Comments may be added to Sales Orders, Sales Quotations, Invoices, Credit Notes, Direct Bills, and Retail Sales Receipts. Comments are used to provide additional text or instruction on the document. Comments in Enterprise 5.1 can be up to 1048 characters in length. For further information on the Comment screen click here.
Move Lines Move Lines The Move Lines button has no functionality in RS41. If you select the Move Lines button the message 'You are not allowed to move or sort lines unless you are in 'Quote' or 'Order' mode. OK' displays. Click the 'OK' button to close the message.
Sort Lines Sort Lines The Sort Lines button has no functionality in RS41. If you select the Move Lines button the message 'You are not allowed to move or sort lines unless you are in 'Quote' or 'Order' mode. OK' displays. Click the 'OK' button to close the message.

Extra Notes on the DELETE function in RS41/Lines:

Re-cap: The Delete button is used to delete the selected Order line from the current Order.

  • When deleting a Model or Assembled Set type product, you must select the header portion to delete the product and all associated products.

  • When a Product line is deleted from a transaction, the 'reserved' and 'back order' quantities are rolled back to update the Product's Available Quantity. At this point, Enterprise checks whether or not the Demand for this Product should also be rolled back. Demand for a Product is tracked separately from Sales in Enterprise to more accurately reflect market conditions for the Product.

  • For example, some Products that are in high demand cannot be filled from the available Inventory and Backorders are created as a result. Some Customers may elect to cancel the Backorder in favor of a substitute Product.

  • Enterprise tracks Product Demand separately from Product Sales, and uses the Demand history as its basis for forecasting. Each time a quantity of the Product is updated against a transaction, Enterprise updates the Demand for the Product instantly, so that the Purchasing system has the most up-to-date information to work with at all times.

  • When a Product line is deleted from a transaction, Enterprise requests that you consider the cause of the cancellation in terms of its effect on Demand by prompting you to answer, "Is this a customer cancellation due to inventory availability? Yes/No".

    • If the cancellation is due to the unavailability of the Product, select Yes. This directs Enterprise to leave the Demand for that Product in place. In this way, the Purchasing system is able to take into account the Demand for that quantity of the Product, even if due to its unavailability the Demand could not be met to produce a sale.

    • If the cancellation is due to other factors i.e. not related to availability, select No. This directs Enterprise to roll back the Demand as if it never existed. You typically select 'No' when you are deleting an incorrect Product line or an entire Order processed against the wrong Customer.

 Inv/Direct Bills/Credits-Lines
RS41/Lines