Share your Success!

[InsUser]

I keep getting an error message -Primary Address failed validation-  when trying to add a new AR customer when using the API spARapiCustomerIns. I'm adding information into the staging table StgCustomer only.  I thought that the address records would be automatically created from this one table. What information is needed for the address to work?  

 Thanks..

[LouDavis]

Have you run a trace or reviewed tdmMigrationLogWrk to see where in the validation the error occurred?  The stored procedure that validates the address is sparCustAddrVal.  Things checked by this procedure are the Action, CustAddrID, PriceAdj, etc.  Look over this procedure to ensure you have all the data it is looking for.

[InsUser]

I've tried the trace and it has no useful information about the error. The Datamigrator pdf says that a primary address will be created from the address entered.  What I need is a sample of data that the api is looking for

[JohnHanrahan]

You need to do a trace showing statements in the stored procedure.  That will give you useful information.  I suspect that this is somewhat difficult for you based on your other posts.  It's likely you can save tons of time by asking your reseller.  They'll either have someone on staff who can help or will be able to find someone.  I imagine it would only take a couple of hours to find out why it doesn't work.

John

[InsUser]

I found the problem. In the AR options for test company 'COA', the box for "Track sales tax on sales" was unchecked.

It looked like the API-(spARapiCustomerIns) was wanting this checked  regardless of what was put in the STaxSchID column in the StgCustomer table . I couldn't check the 'COA' company because I keep getting the message "The Track sales tax on sales field cannot be changed with open invoices in process" - different issue.   So I changed to test company 'SOA' that had the box checked and the test customer was inserted. Nothing to it!

[Jamey]

Hi,

I would like to be able to create customers and vendors from an application I'm building and would like to know what is involved.  If you could share how you did this I would be very grateful!  It seems simple but a walk through or documentation would be great.

Thanks in advance for your help,

Jamey