Shared Applications - Item Unit Price

Theseapplications are common to the requisition, order and goods received input applications although field attributes may differ depending on the type of document processed. These applications are normally not directly accessible from a menu but from related Pop Up Menus on fields in the Requisition, Order or Goods Received options. The ITS philosophy is that the user should be able to enter a request or order on the Requisition or Order options; should the user however require additional functionality the functionality is available and directly accessible from the record on a second or third level.

This is the unit price information of an item. On a requisition to the unit price is update when the approved creditor is linked to the a item. In the screen the user can see the how the calculation of the item total is performed.

Fields in the option:

Item Unit Price - Not Stock

Field	Type & Length	Description
Item Type	A1	Displays the Item type of the item namely Stock, General, Library or Non-Defined Item.
Item Number	N8	Displays the item number of the item if the item type is Stock, General or Library.
Description	A4000	Displays the item description.
Document Number	A10	Displays the document number of the document that the user is processing.
Document Type	A2	Displays the document type of the document that the user is processing.
Line Number	N3	Displays the line number allocated to the item by the system when the line was created.
Creditor Code	N9	Enter the creditor code. Pop Up Menu - available on field creditor. Creditor Description - Displays the approved creditor name. LOV Creditor Codes - Lists the creditor code, name, creditor currency, lead-time and payment terms. Maintain Item Quotations - By selecting this option the user drills down to the "Maintain Item Quotations" application for the item that the user selected from which to drill down. (Only available on requests). Maintain Creditor Definition - Drill down to creditor maintenance option {FPMM-2}. Update and select access rules apply to this option. On order and GRV's the creditor code is not updateable.
Unit Price	N17.2	The currency value of one unit. The value supplied here must correspond to a value of the currency code. The system will default this value if available from option {FPMM-3b2} or {FPMM-23b3} if the item is stock or general and assigned to PO.
Trade Discount Percentage	N5.2	The trade discount percentage. The system will default a value from the creditor, options {FPMM-2b1}, the general item definition, option {FPMM-3b2} or the stock item definition {FPMM-23b3} for trade discount percentage. This value is updateable by the user.
Exchange Rate Updateable	A1	Valid values are (Y)es or (N)o. The exchange rate updateable field indicates if the exchange rate on the item is updateable. The user can only indicate that an items exchange rate is updateable if: Manual Capturing Exchange rates are updateable for the subsyetm PM {FCSO-21}. The item is assigned to PO The creditor’s currency code is not the same as the local currency code From an Originating Document Item The item is assigned to PO If the creditor’s currency code is not the same as the local currency code. The currency updateable is set to updateable Yes on the originating document If the creditor’s currency code is local currency this field is not accessible to the user.
Exchange Rate	N7.3	The system will default the exchange rate depending on the following criteria: From an Originating Document Item The value is copied from the Originating document If the field Exchange Rate Updateable on the Originating document is (Y)es the exchange rate is updateable Else the field Exchange Rate Updateable on the Originating document is (N)o the exchange rate is not updateable and the exchange rate cannot be changed by the user. Manual Capturing Creditor Currency Code equal to local currency then the default is 1 and this field is not accessible to the user. Creditor Currency Code is a foreign currency: Exchange Rate Updateable - if set to (Y)es for the subsystem PM in option {FCSO-21} The program defaults the exchange rate appl;ying the currency rules PM system The user can change the exchange rate to the rate received from the bank when they purchased the forward cover. Exchange Rate Updateable - if set to (N)o for the subsystem PM in option {FCSO-21} The system will default a exchange rate from option {FCSO-21} and the user cannot change the rate. To update the oustanding commitment to teh latest exchange rate the user can run {FCSO-21 sequnce 2}
VAT Rate	N8.3	Enter the VAT rate for the unit price. The valid range is 0.000 to 1.000. The system will default the VAT rate of the previous field's VAT code. The system will allow the user to use different VAT rates per creditor of the item and items of the document.
VAT Inclusive/Exclusive Indicator	A1	Is VAT included/excluded in the unit price of this item? Reply (I)ncluded or (E)xcluded. The system will default "I" into this field and the user is allowed to change the value to "E". The unit price entered will remain unchanged.
Quote / Contract	A15	The ID Code or name by which this contract or quotation is known. In other words this number refers to an external supporting document for the unit price information.
Payment Terms	A3	Enter the payment term code as defined in option {FPMC-4}, the description of the payment term will be displayed. The system will default this value from option {FPMM-2b1}, {FPMM-3b2} or {FPMM-23b3}. The payment term will ensure that the invoice arising for the line will be included in a payment on the effective payment date and that if the invoice is paid before or on the effective payment date the correct settlement discount is deducted from the invoice. The <List of Values> available on the field will list the payment terms, description, discount percentage and number of days from statement or invoice.
Quantity Requested	N15.2	Displays the quantity requested on the item by the user
Cost	N17.2	Displays the total VAT inclusive unit price/cost value before trade discount for this record, of the unit price information in foreign currency. The user cannot access this field. The system calculations are as follows: VAT Inclusive/Exclusive Indicator is I: The value of Unit Price field. VAT Inclusive/Exclusive Indicator is E: The value of Unit Price field multiply by (1 plus VAT rate).
Trade Discount	N17.2	Displays the total trade discount value of the unit price information for this record, in foreign currency. The user cannot access this field. The system calculations are as follows: The value of Price/Cost multiply by Trade Discount Percentage divided by 100.
Given Currency	N17.2	Displays the total given currency value of the unit price information for this record, in foreign currency. The user cannot access this field. The system calculations are as follows: The value of Cost minus Trade Discount.
Local Currency	N17.2	Displays the local currency value of the unit price information for this record, in local currency. The user cannot access this field. The system calculations are as follows: The value of Item Total minus VAT.
VAT	N17.2	Displays the total VAT value for this record of the unit price information, in local currency. The user cannot access this field. The system calculations are as follows: The value of Item Total multiplied by the VAT Rate divided by (1 plus VAT Rate).
Item Total	N17.2	Displays the item unit total value for this record of the unit price information, in local currency. The user cannot access this field. The system calculations are as follows: The value of Given Currency multiplied by the Currency Rate.

Example:

Item Unit Price - Stock

This is the unit price information of a stock item.
In the screen the user can see the how the calculation of the item total is performed.

Field	Type & Length	Description
Document Number	A10	The Document Number of the document. The field is not accessible to the user.
Document type	A2	The Document Type of the document. The field is not accessible to the user.
Line Number	N5	The Line Number from Block 8 will be displayed. The field is not accessible to the user.
Item Type	A1	Displays the Item Type of the item namely Stock.
Item Number	N8	Displays the Item Number of the item if the Item Type is Stock, General or Library.
Description	A4000	Displays the item description.
Unit Price	N17.2	The value of one unit. The system will default this value from {FPMM-23b3}.
Mark Up %	N5.2	Mark-up percentage. The system will default a value from option {FPMM23b2} mark-up percentage. This value is updateable by the user.
VAT Rate	N8.3	Enter the VAT rate for the Unit Price and the valid range is from 0 to 1.000.
Quantity Requested	N15.2	Displays the requested quantity enter by the user on the item.
Cost	N17.2	Displays the total VAT inclusive cost value before mark up for this record. The user cannot access this field. The system calculations are as follows: Quantity Requested multiply by the Unit Price.
Mark Up	N15.2	Displays the mark up for this record. The user cannot access this field. The system calculations are as follows; Quantity Requested multiply by the Unit Price multiply by Mark Up %
Local Currency	N17.2	Displays the local currency value for this record, of the unit price information in local currency. The user cannot access this field. The system calculations are as follows: The value of Item Unit Total minus VAT.
VAT	N17.2	Displays the total VAT value for this record, of the unit price information in local currency. The user cannot access this field. The system calculations are as followed: The value of Item Unit Total multiply by VAT Rate divided by (1 plus VAT Rate).
Item Unit Total	N17.2	Displays the item unit total value of the unit price information for this record, in local currency. The user cannot access this field. The system calculations are as follows: The value of Cost plus Mark-Up

Example:

History of Changes

Date	System Version	By Whom	Job	Description
08-Nov-2007	v01.0.0.0	Amanda Nell	t134643	New manual format.
28-Jan-2009	v01.0.0.1	Marchand Hildebrand	t152121	Proof Read System Owner
06-Oct-2009	v01.0.0.2	Marchand Hildebrand	t160208	Correct Exchange Rate Updateable