cancel
Showing results for 
Search instead for 
Did you mean: 

Print Layout Designer - External Data Help

Former Member
0 Kudos

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 (

) 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

Accepted Solutions (1)

Accepted Solutions (1)

former_member201110
Active Contributor
0 Kudos

Hi Scott,

Could you use a UDF and a formatted search to pull through the data from your external table and store it on the invoice when the invoice is being added? This would then be automatically available to place on the PLD layout.

Kind Regards,

Owen

Former Member
0 Kudos

Owen,

Thank you for taking the time to answer my post. I have done UDFs in other areas, but for some reason I am having trouble getting it to appear at the line level of the invoice. I will keep working at it. I think that your solution will work once I get this issue taken care of.

Thank you again for your time.

Scott

Answers (0)