we have a dimision field attached to our customer card… will this be included in the customer table or there is another table with customer - dimension linking… second, how to find out whether a field is normail field or a calcuated field in a form…
The first 2 global dimensions are saved in the customer table AND in another table. All other dimensions are saved only in the other table. The other table is 352:“Default Dimension”. You can access it by Menubutton Customer=>Dimensions on the customer-card. 2)There is a table 2000000041:“Field”. Do a GET on the table with the table-ID and the field-ID. Then in field “Class” you find if the field is a normal,flowfield or a flowfilter.
second, how to find out whether a field is normail field or a calcuated field in a form…
If the field is not editable and has a drilldown button, then propobilities are very, very high that the field is a flowfield - just to make sure, open the underlying table of that form (the SourceTable property of the form contains the underlying table) and review the FieldClass property of that field. Saludos Nils
The first 2 global dimensions are saved in the customer table AND in another table. All other dimensions are saved only in the other table. The other table is 352:“Default Dimension”. You can access it by Menubutton Customer=>Dimensions on the customer-card.
Originally posted by kriki - 2006 Apr 03 : 05:00:34
You do not have to store the 2 global dimensions in the custoemr table, they can be saved only in the default dimension table. the 2 global dimensions can be entered directly on the customer card, if they are then they are used to defualt on Sales orders, so the dimensions automatically populate the sales header fields. If you only have the dimension entered in the Defualt Dimension table and not the customer header, then the sales header table is not defaulted for the two global dimensions. Only the Order dimension is defualted to the defualt customer dimension, you access that by select the “ORder” button, dimensions.
Right, Just remember when processing dimensions with global dimensions, use the Customer.VALIDATE(“Global Dimension Code 1”) and 2nd one as well. When you use this command, the system will populate the default dimension table. In case you are ever wonder what tables get updated and coding is used. Go to the form before accessing anything. Top menu TOOLS-> DEBUGGER → CODE COVERAGE A window will appear, Click START. Then go back to your form (Customer Card). Access the screen or data entry. Exit the form. Go back to the CODE COVERAGE screen and click STOP. This will show you all tables/forms/codeunits etc that were touched during your execution. Yes, coding too. (WOW)