Skip to Content
author's profile photo Former Member
Former Member

Print Layout Designer - External Data Help

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Apr 18, 2007 at 08:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.