You are viewing limited content. For full access, please sign in.

Question

Question

Accounts Payable (AP) Demo Vendors field not prepopulating via ExternalTables Vendors lookup

asked on October 13, 2014

When running the Laserfiche Accounts Payable (AP) Demo, the Vendor field on the Purchase Order Approval form is empty. I had a look at the form and could see now way how the field was populated and then I looked at the ExternalTables database and noticed that there is a Vendors table populated with three entries, which were consistent with the entries displayed on the form within the video made available to support the demo.

 

I therefore created a new lookup on the form to unconditionally fill the Vendor field with the Vendor column of the Vendors field, i.e. the lookup has no condition element.

 

However, when I run the form the vendor field is not populated with the contents of the ExternalTables Vendors table.

 

I have tried this with two different VAR systems and the result is the same in both cases.

 

Can anybody assist with this.

 

Many thanks, in anticipation.

0 0

Replies

replied on October 13, 2014

Instructions for how to configure the field lookups are included in the LaserRepository readme (found in the LaserRepository zip file).

Check out the readme, and if you're still having issues please post a screenshot of how you've configured your lookup and we can help troubleshoot from there.

 

0 0
replied on November 9, 2014

The same thing happens to me. I've check sql studio to make sure the table exists. 

 

 

below is the error we are referring too.

 

 

 

please assist =)

0 0
replied on February 24, 2015

Hello, not sure if you are still having this issue but here is how to fix it.

 

Manage-> Under actions, click on the Forms icon and select the purchase order form. From here, add the lookup rules to this form. It sounds like you were adding the lookups to the actual request form. Let me know if you have any questions.

0 0
replied on May 14, 2015

I am also having the exactly the same issue. The vendor does not populate. I have verified that the Lookup rules has been added to the Purchase Order Forms. What else could I check?

0 0
replied on May 15, 2015

In case anyone still need the answer, this is what you need to setup in the Lookup Rules.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.