Use this subtask to enter information used to calculate the Cost of Goods Sold for a given item. You can select the method for calculation of Cost of Goods Sold and enter the cost details in the table window.
Initialize this subtask as part of the product unit pricing setup. You must set all the unit information in the Basic Parts, Goods (Materials\Maintain\Items\Goods User Flow), or Services (Materials\Maintain\Items\Services User Flow) screens before you can use this subtask. You can add or change information in this screen at any time.
What validations occur in this screen?
The following validations occur in the table window:
The unit cost must be greater than "0.00."
Consecutive quantities from ".0001" to "9,999,999,999.9999" must exist for each date range. If a unit cost is in effect for a given number of units, you must add additional lines to expand the number of units to these parameters. For example, if a particular unit cost is in effect for the first 100 units, the From and To quantities entered on the first line of the table window should be from ".0001" to "100.0000." A second line must be added to the table reflecting the cost increase, or decrease, for all units after number "100.0000." The From Quantity on this line should be "100.0001," and the To Quantity should be "9,999,999,999.9999." There must be no gaps in the unit number.
There must be no overlap in the date range. If the ".0001" to "9,999,999,999.9999" unit quantity validation has been met, the Starting Date of the following line must be later than the Ending Date of the previous line.
There must be no gap in the date range. If the To Quantity does not equal "9,999,999,999.9999," the start date and end date of the next line must equal the start date and end date of the previous line. If the To Quantity does equal "9,999,999,999.9999," and there is an additional line, the start date of the next line must be one day later than the end date of the previous line.
Use the options in this group box to select the method you want to use for the COGS calculation.
Select this radio button to have cost of goods sold based on a percentage of sales. Enter the percentage you want to use in the Enter Percentage of Sales to Calculate Cost of Goods Sold field.
Select this radio button to base your COGS on a cost schedule. You must enter the cost information in the table window in the Cost Details block if you choose this method.
Enter Percentage of Sales to Calculate Cost of Goods Sold
Enter the percentage of sales that is to be used for the COGS calculation.
This field is available only if you selected the Percentage of Sales radio button AND if the currency for this CLIN is the same as your company's functional currency. If you do not meet both of these conditions, use the Table Window.
Use the table window in this block to enter the cost details. Use this table only if you selected the Cost Schedule radio button in the Calculate Cost of Goods Sold Based on group box. This table stores unit costs by unit number and date range. Unit Cost of Goods Sold transfers will reflect the unit cost based on unit usage date or unit number billed depending on the values entered here. There must be no gaps in the unit quantities or date ranges. Therefore, consecutive quantities from ".0001" to "9,999,999,999.9999" must exist in this table for each date range.
Enter the first item for which the unit cost is valid. For each new date range, the From Quantity must begin with ".0001." Pressing the Tab key will default in this value.
Enter the last item for which the unit cost is valid. Consecutive quantities from ".0001" to "9,999,999,999.9999" must exist for a given date range before you can enter a new date range. Pressing the Tab key will default in this value.
Unit Cost in Functional Currency
Enter the cost per unit that should be used for the given units. This cost is displayed in your company's functional currency.
Enter the starting date that should be used for the given units.
Enter the ending date that should be used for the given units. If the consecutive quantities for a given date range do not extend from ".0001" to "9,999,999,999.9999," you must enter additional lines for the date range until it has met this validation.
* A red asterisk denotes a required field.
Changes to this screen update the CLIN_CST_SCH (CLIN Cost Schedule) table.