Skip to Content
This question has been flagged
purchasesalesproductpriceserial_number
1 Respondre
2139 Vistes
Avatar
Krishnakant Joshi

Business Type: Trading

Scenario: 

Purchase 1: Purchased 10 No. of product XYZ. MRP on box was 10000.00

Created 10 Serial Number 1-10. Generated barcode for those serial numbers.


Purchase 2: Purchased 5 No. of product XYZ. MRP on box was 12000.00

Created 10 Serial Number 11-15. Generated barcode for those serial numbers.


While selling those items, I want system to fetch the actual MRP on sales order.


How to achieve this?



Avatar
Descartar
Avatar
Balagopal R
Best Answer

Hello,

The first step is to enable the Traceability option in Inventory > Settings

In the Product Categories, configure the Costing method as FIFO


After this configuration, when you are doing any purchase, the system will capture the serial/lot numbers and the cost of the product will be saved for that particular set of products. 

Now you can create a Pricelist for this product. For that you can enable the Pricelist with the following configuration


Create a new Pricelist in Sales > Products > Pricelists

Do the configuration in the following way

You can add your margin and based on that, the MRP will be calculated automatically in the Sales.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
How do I add Product Purchase and Sales History to Product View Solved
purchase sales product
Avatar
Avatar
1
de nov. 23
3193
How can i add a sales order from a product?
purchase sales product
Avatar
Avatar
2
de març 15
4175
Sales page, new order, Unit Price is not automatically be filled
sales product order price
Avatar
Avatar
1
de jul. 18
5641
Product Import Template Query
purchase sales product import inventory
Avatar
Avatar
Avatar
2
d’oct. 24
1664
Selling by Random Colours & Quantity
purchase sales accounting product inventory
Avatar
Avatar
2
d’oct. 24
2159