OverviewProduct Browse UpdateIn 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.
|
||||||||
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.
|
||||||||
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.
|
||||||||
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.
|
0 Comments