Product Browse Update

Overview

Product Browse Update

In the Product Browse the following information is displayed. This depends on the stock control settings of your business.

Code	The product code is displayed in this column.
Description	The product description is displayed in description column.
Category	The product category is displayed in the category column.
Sales Price	The sales price of the product is displayed in the sales price column.
Purchase Price	The purchase price of the product is displayed in the purchase price column.
Mark up	The difference percentage of sales price and purchase price is displayed in the ‘Mark up’ column. For e.g. if the sales price is X and purchase price is Y then mark up will be (X-Y)/Y*100
Stock	The product quantity in stock is displayed in the stock column.
Orders Out	The quantity of the product sold is displayed in the ‘Orders Out’ column.
Available	The difference between the Goods In quantity and Sales Order Quantity will appear under the available column.
Orders In	The quantity of the product purchased from the supplier is displayed in ‘Orders In’ column.

Product Browse Synopsis

Stock Control   Settings Sequence I Incoming stock   level based on – Invoice Update Update   Outgoing  stock level based on –   Invoice Update Orders-in   level based on – Orders Update Orders-out   level based on -Orders
Type of Transaction	Stock		Order Out		Available		Order In
Purchase Order	No effect in the   column		No effect in the   column		No effect in the   column		Existing quantity   (+) Purchase Order Quantity
Purchase Invoice	Existing   Quantity(+) Purchase Invoice Quantity		No effect in the   column		Existing Quantity+   Purchase Invoice Quantity		No effect in the   column
Purchase Credit Note	Existing   Quantity  - Purchase Credit Note   Quantity		No effect in the   column		Existing Quantity -Purchase Credit Note Quantity		No effect in the   column
Sales order	No effect in the   column		Existing Quantity +   Sales Order Quantity		Existing Quantity -   Sales Order Quantity		No effect in the   column
Sales Invoice	Existing quantity -   Sales Invoice Quantity		No effect in the   column		Existing Quantity-   Sales Invoice Quantity		No effect in the column
Sales Credit Note	Existing Quantity +   Sales Credit Note Quantity		No effect in the   column		Existing Quantity+   Sales Credit Note		No effect in the   column
Stock Adjustment	Existing quantity +   Adjustment Quantity		No effect in the   column		Existing Quantity +   Adjustment Quantity		No effect in the   column
Goods In	No effect in the column
Goods Out	No effect in the column
Please note in the above columns the   existing quantity or value can be 0.   Purchase   Invoice cannot display in Order/Invoice No. lookup in Goods In   Sales   Invoice cannot display in Order/Invoice No. lookup in Goods Out   Goods   In and Goods Out cannot display in Stock ledger Card
Stock Control   Settings Sequence II Update Incoming   stock level based on – Delivery Update   Outgoing  stock level based on –   Delivery Update Orders-in   level based on – Order Update Orders-out   level based on –Order
Type of Transaction	Stock		Order Out		Available		Order In
Purchase Order	No effect in the   column		No effect in the   column		No effect in the   column		Existing Quantity +   Purchase Order Quantity
Goods  In	Existing Quantity +   Delivery Quantity		No effect in the   column		Existing Quantity +   Delivery Quantity		Existing Quantity -   Delivery Quantity
Sales order	No effect in the   column		Existing Quantity +   Sales Order Quantity		Current Available   column - Sales Order Quantity		No effect in the   column
Goods Out	Existing Quantity -   Delivery Quantity		Existing Quantity -   Delivery Quantity		No effect in the   column		No effect in the   column
Stock Adjustment	Existing Quantity +   Adjustment Quantity		No effect in the   column		Existing Quantity +   Adjustment Quantity		No effect in the   column
Purchase Invoice	No effect in the column
Purchase Credit Note	No effect in the column
Sales Invoice	No effect in the column
Sales Credit Note	No effect in the column
Please note in the above columns the   existing quantity or value can be 0.   Purchase   Invoice cannot display in Order/Invoice No. lookup in Goods In   Sales   Invoice cannot display in Order/Invoice No. lookup in Goods Out   Purchase   Invoice  and Sales invoice cannot   display in Stock Ledger Card
Stock Control   Settings Sequence III Update Incoming   stock level based on – Delivery Update   Outgoing  stock level based on –   Delivery Update Orders-in   level based on – Invoice Update Orders-out   level based on -Invoice
Type of Transaction		Stock		Order Out		Available		Order In
Purchase Order		No effect in the column
Purchase Invoice		No effect in the column
Purchase Credit Note		No effect in the column
Goods  In		Existing Quantity +Delivery   Quantity		No effect in the   column		Existing Quantity +   Delivery Quantity		Existing Quantity -Delivery   Quantity
Sales order		No effect in the column
Sales Invoice		No effect in the column
Sales Credit Note		No effect in the column
Goods Out		Existing Quantity -Delivery   Quantity		Existing Quantity -Delivery Quantity		No effect in the   column		No effect in the   column
Stock Adjustment		(+)Adjustment   Quantity		No effect in the   column		Existing Quantity   +Adjustment Quantity		No effect in the   column
Please note in the above columns the   existing quantity or value can be 0.   Purchase   Order cannot display in Order/Invoice No. lookup in Goods In   Sales   Order cannot display in Order/Invoice No. lookup in Goods Out   Purchase   Order Purchase Invoice, Purchase Credit Note and Sales Order, Sales Invoice   and Sales   Credit   Note cannot display in Stock ledger Card
Stock Control   Settings Sequence IV Incoming stock   update basis – Invoice Outgoing  stock update basis – Delivery Update Orders-in   level based on – Order Update Orders-out   level based on -Order
Type of Transaction	Stock		Order Out		Available		Order In
Purchase Order	No effect in the   column		No effect in the   column		No effect in the   column		Existing Quantity +   Purchase Order Quantity
Purchase Invoice	Existing Quantity +   Purchase Invoice Quantity		No effect in the   column		Existing Quantity +   Purchase Invoice Quantity		No effect in the   column
Purchase Credit Note	Existing Quantity -   Purchase Credit Note Quantity		No effect in the   column		Existing Quantity -   Purchase Credit Note Quantity		No effect in the   column
Sales Order	No effect in the column		Existing Quantity +   Sales Order Quantity		Current Available   column - Sales Order Quantity		No effect in the   column
Sales Invoice	No effect in the column
Sales Credit Note	No effect in the column
Goods Out	Existing Quantity -Delivery   Quantity		Existing Quantity -Delivery   Quantity		No effect in the   column		No effect in the   column
Goods  In	No effect in the column
Please note in the above columns the  existing quantity or value can be 0.   Purchase   Invoice cannot display in Order/Invoice No. lookup in Goods In   Sales Invoice   cannot display in Order/Invoice No. lookup in Goods Out   Goods   In, Purchase Credit Note and Sales invoice cannot display in Stock Ledger   Card

Go to top