We want to get products from our quoting software SQL Database into FS365.
I chose to go with a DataFlow but have run across a snag.
To test further I backed all the way up to only map the most minimal required columns:
Product Name
Product ID
Default Unit
Unit Group
Decimals Support
As per the wisdom from the previous posts I went to the Unit table and created a Key for the Name field, as well as the Unit Group table.
I made sure the names of each matched an existing Unit and Unit Group in FS365.
However, 0 of my 788 records "imported".
1. How do you troubleshoot something like this?
2. What am I missing?