Use these fields to control inventory related functions within Sales Orders.
1. Allow Backorders
Indicate whether back orders are allowed in the sales orders entry programs and eCatalog and eStorefront. If N is entered, back orders are not allowed and the back order field in the sales orders entry programs is skipped. If Y is entered, back orders are allowed depending on how the Allow Backorder flag is set for the customer in the Customer F/M. Press Enter to initially default to unselected.
eCatelog Note: If the AT module is used and this field is changed, all item master records must be updated on the eCatalog database. Rather than creating all of the item master log records required for this from here, the system displays a message indicating to run the eCatalog Initialization Program for item master records, which builds all the item records into the log file and could be done at some more convenient time.
2. Commit Last Item
This field enables users to have all available items committed on sales orders or leave one in inventory. The Commit Backorder program will look at this field when calculating the amount available to be committed to back orders. Press Enter to default to unselected.
3. Commit In Confirmation
Indicate whether to allow entry of a committed quantity in order confirmation.
4. Recalc User Cost
Indicates whether to recalculate user-overridden costs for items when a quote is imported to another quote or converted to a sale order. If you do not select this option, the quote or new sale order will use the old user-entered cost.
5. BOM Update
Indicate whether to update the component items during the SO entry programs. If this flag is set to Y, the system checks the Update in SO flag of the MC BOM Entry Program to see how to handle assembling to BOM component items in SO. If this flag is set to unselected, BOM items are produced through manufacturing, regardless of the value in the Update in SO flag. Press Enter to initially default to unselected.
6. Post Actual Total
Enter whether you want to post A - actual total of LIFO/FIFO or W - weighted average. Press Enter to initially default to A.
7. Price Order
Enter the hierarchy of the order in which the system is to look for prices for an item when determining the default price. When setting up this flag, the user must determine the order in which prices should be selected. Valid entries will be any combination of:
S standard price
L level prices for both quantity breaks or level breaks
Q quantity break
C contract pricing
X lowest price which includes all other options
This must appear first in the Default Price field for the system to search for lowest price. Example: XSLCQ.
The price search program is what the system uses to find the default price. The default price is found based on a number of factors including the quantity being sold, the selling and pricing units of measure on the sales order line item, the types of prices available for the item being sold as well as a number of system control flags.
8. SO (Default) Cost
The cost entered her is used as the default cost in the Sales Order programs. The GL Cost of Goods Sold and the Inventory Asset accounts are affected by this cost. This cost is also pulled and used in the gross margin calculations. This cost is posted to Sales Analysis. Cost of Goods Sold, the expense related to inventory, is often the largest expense on the income statement. As a result, improper accounting for inventory may have a major effect upon other reported financial statement items.
Enter the cost to use as the default cost in the sales orders entry programs. Options are:
M - Manual cost from the Item File: This method is typically used in a manufacturing environment and results in an anticipated cost of producing and/or selling a unit. All manufacturing costs are charged to cost objects at standard cost. Used when detailed or actual costs per unit are not used for management purposes. Costs are used to reflect the transfer of units between work in process to finished inventory or from finished inventory to cost of goods sold. The item’s manual cost is tied to the item, not a warehouse or specific vendor. Both Item and Vendor manual costs are completely user defined. Changes to manual cost must be performed by the user.
A - Average cost from the Inventory Cost/Price File. The average unit cost computed is affected by the number of units purchased at various costs. The total of the number of units purchased plus the units on hand prior to the purchase is divided into total cost of goods available for sale. The cost of goods sold is stated at an amount less than obtained using LIFO but more than obtained under FIFO.
L - Last cost from the Inventory Cost/Price File. This method is typically used in a manufacturing environment. Also known as the replacement method, this option returns the cost of replacing inventory at current market prices. Last cost is not vendor specific. If an item is purchased from multiple vendors (primary, secondary, etc), it is important that as many vendor and item combinations as necessary are set up in the PO Vendor/Item F/M program, otherwise item values will be pulled which may not be desirable.
F - FIFO (first in first out) cost from the Inventory Cost/Price File. The costs of the first goods purchased are the first costs charged to cost of goods sold. Inventory consists of the newest units and their related costs. Balance sheet amounts for inventory are likely to approximate current market values. Offers a more precise matching of historical cost of goods sold with sales revenue.
O - LIFO (last in first out) cost from the Inventory Cost/Price File: The costs of the last goods purchased are the first costs sold. Item costs are normally closer to replacement costs and selling prices are frequently based on replacement costs. LIFO results in the largest cost of goods sold because the newest costs that are charged out of inventory are also the highest costs. Offers a more precise matching of historical cost of goods sold with sales revenue.
Enter initially defaults to the default cost set up in the Inventory Static Control Record.
8. Ser/Lot Cost
You have the ability to cost serial and lot items by the system cost (costing method for the module). The feature provides for GAAP compliance. Select from A-Averaged Actual or S-System Cost. The default setting for each Static Control F/M is A-Averaged Actual. The net result of selecting S-System Cost is that serial/lot items will be costed like non-serial/lot items. If the SO Default Cost is set to LIFO or FIFO the Ser/Lot Cost defaults to A-Averaged Actual and cannot be modified.
9. Default CM Terms Code
Enter the terms code to use as the default terms code in Credit Memo Entry. The entry must be a valid AR terms code. Entering a valid terms code displays a partial description.
10. Default Cash Customer
Enter the customer number which is used as the default cash customer in Counter Sale Entry. The entry must be a valid customer. Entering a valid customer displays a partial description.
11. Change Printed Invoice
Indicate whether to allow changes to printed invoices: Yes = allow changes, No = do not allow changes or Password = changes allowed if a password is supplied. If P is selected, use the override password set up in System Management --> File Maintenance --> Company Control F/M.
12. Credit Hold Security
Specify the security code allowed to release orders from credit hold.
13. Min. Allowable G.M.%
Enter the minimum allowable gross margin percent (+/-999). If the gross margin percent for the item falls below this number during quote, order, invoice or credit memo entry, a message is displayed and the user may continue. Press Enter to initially default to zero.
14. Max. Allowable G.M.%
Enter the maximum allowable gross margin percent (+/-999). If the gross margin percent for the item is above this number during quote, order, invoice or credit memo entry, a message is displayed and the user may continue. Press Enter to initially default to zero.