Use this subtask to enter information used to calculate the Cost of Goods Sold for a given item. The information entered in this screen is stored in the CLIN_CST_SCH table. Initialize this subtask as part of the product unit pricing setup.
This non-editable field displays the selected project level and name.
This non-editable field displays the currency code linked to this project and CLIN.
This non-editable field displays the selected CLIN number, and the unlabeled field to the right displays the CLIN name.
This non-editable field displays the country code linked to this project and CLIN. If the currency code matches your company's functional currency, this field is not required.
This non-editable field displays the selected item number. The unlabeled field below displays the item description.
This non-editable field displays the selected revision number.
This non-editable field displays the selected item type.
This non-editable field displays the selected selling unit of measure.
Use the options in this group box to select the method you want to use for the COGS calculation.
Select this option to have cost of goods sold based on a percentage of sales or from a cost schedule. If you base COGS on a percentage of sales, enter that percentage in the Enter Percentage of Sales to Calculate Cost of Goods Sold field.
Select this option to base your COGS on a cost schedule. If you select this method, you must set up at least one row in the Table Window.
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 option in the Calculate Cost of Goods Sold Based on group box 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.
This table is available only if you selected the Cost Schedule option 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 Qty 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.
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. This is a required field.
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. This is a required field.
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 Qty on this line should be "100.0001," and the To Qty 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 Qty 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 Qty 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.