Options

Need help in Matix box

sujatharaoosujatharaoo Member Posts: 57
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,.
Regards,
Sujatha.N

Comments

  • Options
    krikikriki Member, Moderator Posts: 9,098
    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);
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    sujatharaoosujatharaoo Member Posts: 57
    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 .
    Regards,
    Sujatha.N
  • Options
    leugimleugim Member Posts: 93
    i think you must accumulate your totals manually...
    _______________
    so far, so good
  • Options
    krikikriki Member, Moderator Posts: 9,098
    leugim wrote:
    i think you must accumulate your totals manually...
    Correct.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.