Need help in Matix box

sujatharaoo

I have created a new form in Nav 2009 to display Stock availability across companies . The problem is i have used matrix box to display the company name ( horizontal table) and items ( vertical table ) similar to the Items By Location screen .
Everything works fine except that i want to display the sum of hte Quantity in all the companies next to the item field . When i do run time calculation , it is not happening correctly . Do we have any other way to do this . Please guide me in this regard,.

kriki

Probably you do something like recItem.CALCFIELDS(Inventory) to get the inventory.

Try to do it on the item ledger entry. Something like this:

recILE.RESET;
recILE.CHANGECOMPANY('The company you need');
recILE.SETCURRENTKEY("Item no.");
recILE.SETRANGE("Item No.",'The item you need');
recILE.CALCFIELDS(Inventory);

sujatharaoo

Thanks for the reply .

I have actually completed the inventory availability calculation using change company & calc fields but my problem is to display the total ( SUM OF THE STOCK ) for all the companies .

leugim

i think you must accumulate your totals manually...

kriki

leugim wrote:

i think you must accumulate your totals manually...

Correct.