New flowfield in table 27 based on Value Entry

I’m not sure if I’m in the correct forum because I’m certainly not a developer, but end user/administrator. But it’s about C/AL, though: I want to create a new (flow)field in table 27 (Item) in which the quantity of Value Entry (table 5802) of Item Ledger Entry Type ‘Consumption’ is calculated. This should be similar to the already available fields ‘Purchases (Qty.)’ and ‘Sales (Qty.)’. I guess there should be some code behind this new created field, but what should it look like? Edited by - mfh on 2002 Jul 30 10:12:40

No code needed. Go to the table (27) Mark the entire line with, for example, the Sales (Qty) field in it. Right click, select copy. Unmark the line with Sales (Qty) Right click, select paste. Now you have 2 fields with identical numbers and names. Change the field number in the line you just pasted to something in the range 50000 to 99999 Enter the Properties for the new field. Find the property “FieldClass” and click the AssistButton (the one with the 3 dots) Click on the AssistButton in the “Table Filter” box. In the line “Entry Type” CONST Sales, you delete the word Sales, and type in the number 5 - the “5” should change to the word Comsumption. Click OK, and OK again. Save your table. Add your new field to the forms where you need it. Voila. Lars Strøm Valsted ------------------------- Why can’t programmers tell the difference between Christmas and Halloween? Because OCT(31) = DEC(25)

Thank you very much Lars! Works perfectly! Michiel