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.

Stock_Adjustment_Product_Browse_update.jpg

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   uparrow.png

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk