I’ld like to know how to use a matrixform for input proposals (the right part)? It’s no problem to insert new records on the left side, but modifying a second dimension from the matrix - would solve my problem… Is there anyone out in this big world, who has managed this part, and if so, how???
I did this quite extensively for a customer in the clothing trade where each item can come in a number of different sizes. I setup a matrix so that when they entered a quantity in the right hand part, it created/amended a normal sales line behind the scenes. Setup a matrix control as normal. Source table, MatrixSourceTable, heading for right hand side etc. Create a global var (e.g. OrderQty) and put it as the SourceExpr for the right hand side. F9 for the C/AL code and in the OnFormat trigger put in some code to fill OrderQty with whatever you want to display. When the user makes an entry on the right hand side, you will be able to use OrderQty to update whatever you require. In my case, special table of items on the left, integer as the MatrixSourceTable. By looking at CurrForm.Grid.MatrixRec.Number to get the column and the item on the left hand side, I was able to identify the variant of the item and then maintain the normal sales order lines behind the scenes in the OnAfterValidate trigger. It was a bit more complicated than it sounds but the principle is sound. No doubt MindSource will come up with another way but this works for me!
JohnP ? A variety of Solutions will hopefully help the person asking the question solve the problem, in the best way to fit their specification. On this question I do not have a reply! Mr David Cox MindSource (UK) Limited Navision Solutions Partner Email: david@mindsource.co.uk Web: www.mindsource.co.uk Edited by - David Cox on 7/21/00 10:50:25 AM