Monday, 22 February 2016

Activate Debug Mode in One Click


Activate Debug Mode in just One Click!!

If you are working with Odoo instance you need to activate debug mode frequently.

Here Chrome Extension .CRX file just drag and drop in your extension list and you able to activate debug mode in One click.
(Go to Setting > Extension and simply drag and drop attached .crx file)

Click here to Download :

Debug Mode


Specially Thanks to Hitesh Trivedi. ( Blog )

Note : Limited Feature to only Odoo site.
..Enjoy..

Thursday, 18 February 2016

Delivery methods configuration Odoo



While working with different delivery methods in Odoo, If you get any issue first check following configuration.

- Check your delivery method credential

- Check your packaging methods

- Check your Delivery Service Type

- Published on Website or not

- Production/Test Env


- Your warehouse company address (with all proper detail including phone number)

- Check product weight

- Customer Address (Shipping Address)

- Address State code are valid or not.


After checking all and if you still don't get any Delivery methods on checkout page the simple way to checking is go to backend and create Quotation with same product and customer address and check the error.


After all cases if you face still any error then simply google delivery method name + test site and enter same detail in test site if its not succeed then contact to your delivery provider for further assistance.

Hope it helps. :)

..Enjoy..

Landed Cost Calculation Using Various split method Odoo

Landed cost calculation based on different Split Method,

Let's take one example and check different split method and Stock valuation.

When Sales UoM and Purchase UoM same(When Purchase UoM Different keep in mind landed cost always calculate based on Purchase UoM and inventory valuation always display in Sales UoM).

Configuration :
============

To work with Landed Cost first need to activate landed cost feature, to do go to Inventory > Configuration > Settings.
Configure Warehouse   Odoo.png

Now we need to configure Product Category to define Costing method.

Wooden   Odoo 10.png

Products :
========

Wooden Table => Cost : 100, Weight : 5, Volume : 2, Category : Wooden
Wooden Chair => Cost : 200, Weight : 8, Volume : 8, Category : Wooden

Purchase Order :
==============

   Wooden Table => with Qty : 1, cost : 100
   Wooden Chair => with qty : 2, cost : 200

PO00005   Odoo.png

Landed cost Type :
================

 Transportation => Cost:  20
 Duties => Cost:  15

1.png


===========================================
Result with Different Split methods in Landed cost :
===========================================

1. Equal :

   Transportation = 20 / (no. of products 2) = 10
   Duties = 15 / (no. of products 2) = 7.5

LC 2016 0014   Odoo.png

   Valuation :
    Wooden Table => 100 + Transportation(10) + Duties(7.5) = 117.5
    Wooden Chair => 200 * qty(2) + Transportation(10) + Duties(7.5) = 417.5

2. By Quantity :
   Allocate cost based on qty, here we have wooden table with qty 1 and wooden chair with qty 2 so we have to allocate cost among 1:2 ratio.

   Transportation = 20
                       So, For Wooden Table = (20 * 1)/3 = 6.67
                        For Wooden Chair = (20 * 2)/3 = 13.33
   Duties = 15
              So, For Wooden Table = (15 * 1)/3 = 5
                  For Wooden Chair = (15 * 2)/3 = 10
LC 2016 0002   Odoo.png
   Valuation :
    Wooden Table => 100 + Transportation(6.67) + Duties(5) = 111.67
    Wooden Chair => 200 * Qty(2) + Transportation(13.33) + Duties(10) = 423.33



3. By Current Cost :

   Allocate cost based on products cost 100:400 ratio (1:4).
      Wooden Table Cost: 100 *1 (qty)
      Wooden Chair cost : 200 *2 (qty)

   Transportation = 20
                    So, For Wooden Table = (20 *1)/ 5 = 4
                        For Wooden Chair = (20 * 4)/5 = 16
                        
   Duties = 15
                    So, For Wooden Table = (15 *1)/ 5 = 3
                        For Wooden Chair = (15 * 4)/5 = 12
Landed Cost 3 (1).png
   Valuation :
    Wooden Table => 100 + Transportation(4) + Duties(3) = 107
    Wooden Chair => 200 * Qty(2) + Transportation(16) + Duties(12) = 428

4. By Weight :
   
   Wooden Table = 5 weight and Wooden Chair = 8 weight.
   So the ratio 5:8 but here for chair we have 2 qty so ratio 5:(8*2) => 5: 16
   

   Transportation = 20 allocate based on weight of products.

                    So, For Wooden Table = (20 *5)/ 21 = 4.76
                        For Wooden Chair = (20 * 16)/21 = 15.24
                        
   Duties = 15
                    So, For Wooden Table = (15 *5)/21 = 3.57
                        For Wooden Chair = (15 *16)/21 = 11.43

Landed Cost 4.png

   Valuation :
    Wooden Table => 100 + Transportation(4.76) + Duties(3.57) = 108.35
    Wooden Chair => 200 * Qty(2) + Transportation(15.24) + Duties(11.43) = 426.65


5. By Volume :

   Wooden Table = 2 Volume and Wooden Chair = 8 Volume.
                  So the ratio 2:8

   Transportation = 20 allocate based on Volume of products.
                    So, For Wooden Table = (20 *2)/ 10 = 4
                        For Wooden Chair = (20 * 8)/ 10 = 16
                        
   Duties = 15
                    So, For Wooden Table = (15 *2)/10 = 3
                        For Wooden Chair = (15 *8)/10 = 12

Landed Cost 5.png

   Valuation :
    Wooden Table => 100 + Transportation(4) + Duties(3) = 107
    Wooden Chair => 200 * Qty(2) + Transportation(16) + Duties(12) = 428

To check valuation of products first validate Landed cost and go to Inventory > Reports > Inventory Valuation.


..Enjoy..

How "Point Cost" calculated in POS reward


Point of Sale Reward Calculation 

Here the calculation is different let me explain.

If your reward calculation like Discount 80% and Point cost 5.00 that means per 1 discount it will charge 5.00 points so here 80*5.00 = 400 Points.

Now, if you have not enough points then system will set discount as per your points. 




Ex.

ice-cream 100 Dollar, Agrolait have suppose 50 points. Loyalty Program have 80% discount

Total points require to get 80% discount = 80 * 5 = 400 points

System will check total points 400 > spendable points 50.00, if yes then system will calculate : spendable points(50)/point cost(5) = 10



Now, system will apply only 10% discount instead of 80% because Agrolait have not enough points to get 80% discount..

..Enjoy..

Tuesday, 16 February 2016

How to change currency or how to configure multiple currency ?

How to change currency or how to configure multiple currency ?

When we are dealing with multiple currencies we need to configure those rate correctly in system.

To do, first make sure you have multiple currency activated(To activate Go to Accounting > Setting under Accounting & Finance find out "Allow multi currencies" and activate it)

After Activate go to debug mode (To do this click on your Username in the top right of the backend (in my case it was 'Administrator') then click on About and then Activate the Developer mode)

Now, you can see new menu added in Accounting > Configuration > Multi Currencies. You can see list of currencies, now first of all find out your company currency and set currency rate 1.0. now for the rest of currencies find out currency rate against your company currency and add it(If you have enterprise version then you can use auto update currency rate using yahoo finance,...).

That's it.

Ex. My company currency INR, so i change current rate of INR to 1.0 and for rest of currency like EUR, USD i can set rate against INR means
1 INR = ? EUR, 1 INR = ? USD .

..Enjoy..