To all and none in particular: Is there ANY way to do this form from inside Navision?? ------------------------------MovProd_Lot N° Prod_N°-----------------------Prod_QtityOnHand Total Prod_N° Thanks in advance…
can you describe it with a little bit more info ?? Perhaps an example with quantities ?
Of course, the idea is something like this ----------------------Lot N° A15 — Lot N° B34 ---- Lot N° B342 Coke can ------------1500 Units — 25 Units ------ 0 Units Coke bottle ----------0 Units ----- 0 Units --------- 33 Units The idea is to present to the user all lots he has available to choose from to substract stock for a sale. Thanks, Ulises
This is the standard behavior of MATRIX elements ! If you know how to program do it else ask again
To tell you the truth, I’ve never programmed a matrix form, and I agree with you that this is the right object to use, and even though I checked a couple of matrixes from the database, I couldn’t understand how to create my own… Thanks, Ulises
quote:
Originally posted by Shaidallar
To tell you the truth, I’ve never programmed a matrix form, and I agree with you that this is the right object to use, and even though I checked a couple of matrixes from the database, I couldn’t understand how to create my own… Thanks, Ulises
In the C/Side Help there’s a nice description of how a MatrixBox works. See Summry → Controls → MatrixBox The explanation is quite good, the example they chose to help you understand is … the worst they could come up with! [:D] It use the same table for both dimensions. Anyway I would suggest you to read the help first, try that stupid example, then come back with more questions. [;)] Good luck Anna
Thanks Anna, I’ve already read the C/SIDE Help, but as you say, it does not do a good work to help you understand anything… I think that in my case, the matrixbox should have functions in the matrixbox’s Headers and Values, and in that example it does not explain how to do that… and the Budget matrixbox is too god damn hard!!!
quote:
Originally posted by Shaidallar
Thanks Anna, I’ve already read the C/SIDE Help, but as you say, it does not do a good work to help you understand anything… I think that in my case, the matrixbox should have functions in the matrixbox’s Headers and Values, and in that example it does not explain how to do that… and the Budget matrixbox is too god damn hard!!!
MatrixBox has a SourceExpression property as well as MatrixHeader. You can write two functions, say GetMatrixBox and GetMatrixHeader and use their return values as SourceExpression. Problem is (at least to me) which table you may use as horizontal table. To make things easy you should have a table with all the lot numbers that have been used so far; then in the GetMatrixBox function you just would have to read all the Item Ledger Entries of the current Item and Lot Number and do the calculation. But, as far as I know, such a table does not exist. If the lot number is assigned automatically, you might use the Integer table as the horizontal table and for each number try to calculate the corresponding lot number getting the starting value of the numbering series and applying as many increase intervals as the current number … it’s a bit tricky, but it may work. [:)] Anna
You might be able to use the lot no. information table for that purpose. If you tick “lot no. info. must exist” in the item tracking code, then the user has to enter a record in that table if he/she uses a new lot no. So you can keep track of the used lot nos. Other possibility could be to scan the item ledger entries and write the existing lot nos. to a temp record variable of Tracking Summary table…
Using the matrix The trick is that your form should be linked to data you want to show on the left side of the matrix. E.g. link it to the Item table. The matrix itself should be linked to the table you want to display on the top e.g. the location table. The matrix itself has two parts on the left side you can insert the fields from the Item table. E.g. Item Number and Description. On the right side you can enter a flowfield from the Item table, on which you can put a filter from the location table. Now you have to program some code in the UpdateMatrix() function. Here you have to set a range and calculate the flowfields. e.g. SETRANGE(“Location Filter”,CurrForm.ItemAvailMatrix.MatrixRec.Code) ; CalcFields(Inventory) ; This would calculate per item per location the quanity in stock. A good example is to look at the matrix used on the Item Card. Press the button Item and select Item by location. This is an easier matrix than using a matrix based on the Date table like for example the balance sheet per period. As far as I know the matrix will only work with flowfields and you can not use a matrix with fields that can be updated in the matrix. have fun with it R.J. van Kuppeveld
quote:
Originally posted by rj.kuppeveld
As far as I know the matrix will only work with flowfields and you can not use a matrix with fields that can be updated in the matrix.
Beg to differ [;)] We have some matrix forms - supplied by our NSC - in our system which calculate the values using some function defined in a codeunit. Furthermore, I have extended one of these forms to allow input in the matrix form. It’s a bit tricky (you have to know how the value had been calculated in the first place), but I was quite satisfied with the result [:D]
Ok, thank you all, I’ll give it a try. Ulises
First of all, thanks for your answers, specially to Robert, who was extremely helpful. I was finally able to create the matrix form, even if a bit rough and unpractical. I’ll just spend a few more days to make it look and feel better. Thanks, Ulises