Skip to Content
Former Member
May 15, 2009 at 03:09 AM

error when setting UDF's visible in XL reporter


Hi everyone,

Good day! I have a problem in making one several UDF's visible in XL reporter.

I'm using SAP B1 2007A PL42. I have UDF's added in the marketing documents in

the title. The code is U_RM and before this certain UDF was okay. In fact we

were able to create a repor. However, yesterday, our report will not run because

the UDF is no longer available. But if you're going to check it's setup, the box

is checked so it should be visible in XL reporter. We tried checking and

unchecking but we get this error msg, "An error occurred while trying to write

to the database. Original error-message was: Column names in each view or

function must be uniqu. Column name U_RIS in view or function "ixvfact" is

specified more than once.

U_RIS is another UDF we added in the title of the marketing documents.

Please help. Many thanks.