How to get Unit Cost (ACY) in Item card?

Aravindh_Navision

Hi Friends,

In Item card, if the "Costing Method" is AVERAGE we are getting the average cost of the Item in the "Unit Cost" field. The "Unit Cost" field contains a drill down button which leads to another form named "Average Cost Calc. Overview" (the table bounded to this form is a temporay table). In this form we have "Unit Cost", "Cost Amount (Actual)", "Quantity" fields in it.

Unit Cost := Cost amount (Actual) / Quantity;

As like I need to get the Unit Cost in ACY in Item Card.

I kept a new field "Unit Cost (ACY)" in Item card and it behaves exactly as "Unit Cost" field (as mentioned in first paragraph). For achieving it I have added new fields "Unit Cost (ACY)", "Cost Amount (Actual) (ACY)", "Cost Amount (Expected) (ACY)" in "Average Cost Calc. Overview" form and it corresponding bounded table and wrote few functions and piece of codes in respective places and as a result I am getting Unit Cost and Cost Amount in ACY. (Please see the attachment for easy understanding. Red marked fields are new fields).

In Item card, Unit Cost is updating automatically but the Unit Cost (ACY) is not updating.

Can anyone help me how to get the Unit Cost (ACY) automatically in Item card?

Thanks in advance.
Aravindh.