Skip to Content
0
Former Member
Apr 18, 2007 at 05:08 PM

Print Layout Designer - External Data Help

19 Views

Can anyone help me with a similar problem I am having with the Print Layout Designer? I am using B1 and an "add-on"? I need to include a field on the invoice that does not exist in the core B1 tables. I have looked at the "External Data" field, but when I use Source Type "Database" I can not figure any way to point it to an external data source. In the post (

Print Layout Designer - Field: External Data Help) running a SQL query was discussed, but I don't think it explained where/how to do that. Can I use the "Formula" Source Type somehow? I can have a Stored Procedure in the "add-on" database or the B1 database, but I am not familar with what I need to do so I can provide B1 with a *.dll that would run it.

Thank You

Scott Bloomer