Skip to Content
0
Former Member
Nov 15, 2012 at 10:40 AM

B1if FileXML2B1 scenario with a SQL validation

44 Views

Hi All,

I hope you can help me on this one.

I'm working on the following scenario:

XML file(A/R Invoice) to Business One.

Everything is working fine but I have to add a validation (look up).

It will be a SQL query to validate if the Card Code exists in B1, if this CardCode does not exist then I will replace the cardcode from the XML file with an specific cardcode.

I'm not sure how can I implement this?

Thanks!

David