Hello Vishal,

Thanks for the feedback

As I got; you're trying to fetch a value from a sale order line to the automatically generated purchase order [by using procurement method such as MTO then Buy]. 

If what I get is correct then it is not simple ... lots of logic should be considered as:

First: for each sale order line a procurement order created. Then after running the procurement order(s) new stock moves will be created. Those stock moves will be confirmed and new procurement orders will be created from those stock moves. Those new procurement orders will generate the purchase orders. And this why there is  2 procurement orders will be generated if you confirmed the Sale order [one is running "the first one generated by the Sale order, the Second one "Confirmed" generated by the Stock move].

So its as: SaleOrder->Procurement Order->Stock Move->New Procurement Order->Purchase Order..

IMHO, there are two options to solve this: using context or do few modifications in some models and functions.
I didn't debug both options but I think using context will not work because running procurement can be for more than one procurement order.

So I think you need to modify some methods.

Actually the procurement.order contains a field called 'sale_line_id' and this will be automatically filled by the first first generation of the procurement order by this function . So we need to pass this field to the newly generated stock.move

So we need to add a new column to stock move and that is 'sale_line_id' then set this field in the function that will generate the stock move from the procurement . You can simple get the sale_line_id by using procurement.sale_line_id.id

after that we need to fill the sale_line_id again to the new procurement generated by the confirmation of the stock move in the _prepare_procurement_from_move . Then the new created procurement order will contains the sale_line_id that contains your new field 'preferred account number'. The last step is to fill the purchase order line with this field by using _get_po_line_values_from_proc  . 

I know this seems somehow complex . But I didn't know more simpler way to do it :( .  And it'll be great if someone else can give an idea ...

Hope it can help ...

Waiting for your feedback ....

Hi,

I hope you want to get the "preferred account number"  field value on adding a product in sale order line or purchase order line, like unit price.

Then you need to override the methods, product_id_change() in sale.order.line and onchange_product_id() in purchase.order.line.

I have added a "preferred account number" field to the sales order line and I would like the same to be reflected in the purchase.order.line. There are no calculations involved, but just lookups. 

At this time, I am looking at overriding create_procurement_purchase_order method in procurement.order.

Using Odoo 8.