Shared Applications - Unit Price

This applications is common to the applications in the Accounts Payable PM module. This applications are normally not directly accessible from a menu but from related Pop Up Menus on fields in Accounts Payable options.

Block 1: Item Unit Price

Field	Type & Length	Description
Item Type	A1	Displayed item type can either be (N)on-Defined or Defined. (G)eneral items, (S)tock items and (L)ibrary items are defined items. Defined Items. General items are goods or services defined but not held as stock. The request if copied to an order should result in an order to procure the item from the item vendor. Stock items are goods held in stock and the request thereof if copied should result in a stock issue Library Items are items created in the library system and if copied to an order should result in an order to procure the library item from the item vendor. Valid values are G, S, L or N G - General Item is maintained in FPMM-3 S - Stock Item maintained in FPMM23 L - Library Item is maintained in LCAO-1 Non Defined Items Items not defined on the ITS System. No code structures exist from which to derived the description, approved vendors, prices etc for the item.
Item Number	N8	Display a valid stock, general or library item number depending on the item type selected.
Originate from
Document Number	A15	The document number for the type of document specified in the previous field from which information was copied.
Document Type	A2	Valid values are (O)rder/(G)RV if the Type of Document is (IN)voice or (IN)voice/(S)upplier Return if (CN) - Credit Note.
Line Number	N5	The item Line Number, running sequentially from 1 onwards and is controlled by the system. The field is not accessible to the user
Item Description	A4000	The item description. From an originating document The value defaults from the original document and cannot be changed by the user. Manual Capturing The description as it appears on the invoice received.
Creditor Code and Name	N9	The creditor must be defined on option {FPMM-2}, TAB - Crediotor Detail.
Currency Code and Description	A3	From an originating document The value defaults from the original document and cannot be changed by the user. Manual Capturing The system will display the Currency Code of the Creditor Code definition. The field is not accessible to the user.
Invoice Value	N15.2	The field is used to adjust an items amount where due to rounding an items values calculated through the program differs form the invoice received from the creditor. If a value is entered in to the field and the variance between what the program calculated and the amount entered is less than 0.5% the system will adjusted to the invoice amount to the amount entered.
Quantity	N10.3	The number of units that must be paid or taken credit for. Unit can be up to 3 decimals.
Unit Price	N15.4	The currency value of one unit Originating Document Item Type of Document is IN. The value defaults from the original document and can be changed by the user. Type of Document is CN. The value defaults from the original document. Manual Capturing The currency value of one unit. The value supplied here must correspond to a value of the currency code.
Trade Discount	N5.2	The percentage trade discount that will be deducted from the unit price irrespective of when the item will be paid. Originating Document Item Type of Document is IN. The value defaults from the original document and can be changed by the user. Type of Document is CN. The value defaults from the original document and cannot be changed by the user. Not Originating Document Item The system will default the creditors trade discount percentage from options {FPMM-3}, TAB - General Item Creditor Definition. This value is updateable by 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 user must supply the currency rate as 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.
Exchange Rate Updateable	A1	Exchange Rate Updateable (Y)es ot (N)o Originating Document Item The value is copied from the Originating document The user cannot change the exchange rate updateable indicator. Manual Capturing The value defaults from the field Exchange Rate Updateable for subsystem PM in option {FCSO-21} The user cannot change the exchange rate updateable indicator.
VAT Rate	N8.3	The VAT rate for the unit price and the valid range is 0 up to 1.000. From an Originating Document Item Type of Document is IN. The value defaults from the original document and can be changed by the user. Type of Document is CN. The value defaults from the original document and cannot be changed by the user. Manual Capturing The system will default the VAT rate of the previous field VAT code. The system will allow the user to use different VAT rates for each item of the document.
VAT	A1	Is VAT included/excluded in the unit price of this item? (I)ncluded or (E)xcluded. The unit price entered will remain unchanged if this value is changed. From an Originating Document Item Type of Document is IN. The value defaults from the original document and can be changed by the user. Type of Document is CN. The value defaults from the original document and cannot be changed by the user. Manual Capturing The system will default the value of system operational definition code AZ subsystem PM in to this field and the user is allowed to change the value.
Originating Documents
Unit Price	N15.4	The currency value of one unit as it appears on the Originating Document.
Trade Discount	N5.2	The percentage trade discount that will be deducted from the unit price irrespective of when the item will be paid as it appears on the Originating Document.
Vate Rate	N8.3	The VAT rate for the unit price and the valid range is 0 up to 1.000 as it appears on the Originating Document.
VAT	A1	The VAT included/excluded in the unit price of this item as it appears on the Originating Document.

Cost	N15.2	If VAT is inclusive * Unit price multiplied by the quantity for the item. Otherwise if VAT is exclusive * Unit price multiplied by the quantity for the item multiplied by (1 plus VAT rate)
		Displays the total Trade Discount value of the Item The calculation for Trade Discount is Cost multiplied by the Trade Discount Percentage divided by 100.
Creditor Currency		Displays the total Given Currency Value for the Item. The calculation for Creditors currency is Cost minus Trade Discount .
Local Currency		Displays the total value before VAT for the Item Detail (The value is in local currency). The calculation for local currency is Line Total minus VAT.
VAT		Displays the total VAT value for the Item. The calculation for VAT of this record is Line Total multiplied by the VAT rate divided by (1 plus VAT rate).
Line Total		Displays the VAT inclusive Total for the Item (The value is in local currency). The calculation for the Line Total is Creditor Currency amount multiplied withe the exchange rate for the creditors currency on the transaction date.

Example:

Block 1: Page 2

Field	Type & Length	Description
Document Number	A15	Document number defaults and dios[plays form the previous page.
Document Type	A2	Valid values are (O)rder/(G)RV if the Type of Document is (IN)voice or (IN)voice/(S)upplier Return if (CN) - Credit Note.
Line Number	N5	The item Line Number, running sequentially from 1 onwards and is controlled by the system. The field is not accessible to the user
Item Type	A1	Displayed item type can either be (N)on-Defined or Defined. (G)eneral items, (S)tock items and (L)ibrary items are defined items. Defined Items. General items are goods or services defined but not held as stock. The request if copied to an order should result in an order to procure the item from the item vendor. Stock items are goods held in stock and the request thereof if copied should result in a stock issue Library Items are items created in the library system and if copied to an order should result in an order to procure the library item from the item vendor. Valid values are G, S, L or N G - General Item is maintained in FPMM-3 S - Stock Item maintained in FPMM23 L - Library Item is maintained in LCAO-1 Non Defined Items Items not defined on the ITS System. No code structures exist from which to derived the description, approved vendors, prices etc for the item.
Item Number	N8	Display a valid stock, general or library item number depending on the item type selected.
Item Description	A4000	The item description. From an originating document The value defaults from the original document and cannot be changed by the user. Manual Capturing The description as it appears on the invoice received.
Creditor Code	N9	The creditor must be defined on option {FPMM-2}, TAB - Crediotor Detail.
Quote/Contract	A15	The ID Code or name by which this contract or quotation is known. In other words this number is an external supporting document for the unit price information.
Version	A10	Version number of the Quote/Contract.
Payment Terms		The Payment Term code as defined in option {FPMC-4}, the description of the payment term will be displayed. The payment term will ensure that the item is displayed and calculated with the correct payment percentage and effective payment date. If the item is paid before or on the effective payment date, the correct settlement discount (Using payment percentage) is deducted from the item. A list of values is available of payment term codes and the description will be displayed. From an Originating Document Item Type of Document is IN. The value defaults from the original document and can be changed by the user. Type of Document is CN. The value defaults from the original document and cannot be changed by the user. Manual Capturing The system will default the creditor payment term from options {FPMM 2p2}. The default value is updateable by the user.
Payment Percentage	N5.2	This payment percentage will be used if the item is paid before or on the effective payment date and the settlement discount (Using payment percentage) is then deducted from the item cost price. The system will default the payment percentage of the payment term as defined in option {FPMC-4} and the value is updateable as follows: From an Originating Document Item Type of Document is IN. The value defaults from the original document and can be changed by the user. Type of Document is CN. The value defaults from the original document and cannot be changed by the user. Manual Capturing The system will default the creditor payment term's payment percentage from options {FPMC-4} and can be changed by the user.
Effective Payment Date	DD-MON-YYYY	The date when this item is due for payment to the supplier. The program calculates this date using the Document Date, the numbers of Days and From Document (Statement or Invoice) of the above payment term as defined in option {FPMC-4}. If the payment term is "30 days after invoice", the system will add 30 days to the document date. If the payment term is "30 days after statement", the system will add 30 days to the first statement after the document date. The system will default the effective payment date calculated by using the payment terms and the value is updateable as follows: From an Originating Document Item Type of Document is IN. The value defaults from the original document and can be changed by the user. Type of Document is CN. The value defaults from the original document and cannot be changed by the user. Manual Capturing The system will default the creditor payment term's effective payment date and can be changed by the user. The Payment Percentage and Effective payment date can also be updated after the item was captured on the system as long as the item is not paid. NB. DIFFERENT ITEMS ON A DOCUMENT MAY HAVE DIFFERENT PAYMENT INFORMATION.

Example:

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
03-Dec-2007	v01.0.0.0	Kobus Kleinhans	t144148	New manual format.
13-Mar-2009	v01.0.0.1	Marchand Hildebrand	t152121	Proof Read System Owner.
06-Oct-2009	v01.0.0.2	Marchand Hildebrand	t160208	Currency Updateable corrected