Hi Dileepa-
Thank you, yes I understand that. This is the scenerio: When I select a vendor on Purchase Invoice. Then I put in the invoice number, I go to detail grid to select G/L Account, after I set No. then check detail dimensions I have two defaulted dimensions, so yes, one ID set entry, but I don’t understand, how do I get this ID value from sql? Is it determined on the No. field or the header Vendor field? Or is it a combination or fields? The Dimension Set Entry ID has to be set for Purchase Invoice, but how? Sometimes when I select a different No. such as Fixed Assets not G/L Account, I get four dimensions defaulted, which again means it’s a different Dimension Set Entry ID, so I am missing the link to how it knows which Dimension Set Entry ID is to be used?
thank you kindly.