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, orde or issue  on the specific 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 - Stock
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.
Issue Price N17.2 The issue price or sales price at which one issue unit of the item of is sold as defined for the item option {FPMM-23} - Item Store Definition.

The issue price of a item is detremined by the user and is not calculated by the system.

If the Default Issue Price indicator on the store definition is set to Weighted Average, the Cost Price of the item as per {FPMM-23}- Stock Item Definition will default as the items sales price else if set to Sales Price  the sales price will default.

The updateability of the issue price is determined by the System Operation Definition Code A7 - "Allow Update of Price on Issue". If set to (Y)es the sales price is updateable else the issue price is not updateable.

If the sales price of an item is updateable, the updateability of the price can be limited the extent that the cost of the item may not exceed the sales price. System Operation Definition Code A8 - "Allow Issue Less Than Weighted Average Cost". If set to (Y)es the sales price may exceed the items cost price.
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 Code A2 Entering a valid VAT code will default the VAT rate from the code definition into the VAT Rate field. The purpose of entering a VAT code is to assist he user in completing the VAT Rate and is not stored in the database. The list of values on the VAT code field  will list the Code, Description, VAT Rate and Taxable Supply Indicator associated with the VAT code.
VAT Rate N8.3 Enter the VAT rate for the Unit Price and the valid range is from 0 to 1.000. 
Taxable Supply Indicator A1
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:

Example of ...

 

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
26-oct-2009 v02.0.0.0 Marchand Hildebrand t158613 Add Issue Price to the screen