When I try to import new records to the Customer table using Configuration Packages, nothing seems to happen - except Business Central seems to become aware of the new Customer No.s!
This is what happened:
- I created a Rapidstart Configuration Package for table 18 Customer, selected only field 1 "No." and field 2 "Name", filtered so I only export a few rows.
- Exported to Excel
- In Excel, I deleted all old records and entered two new ones, each with a customer No. that did not exist in the table
- On the page for the relevant Configuration Package, I imported the edited Excel file. I got no messages or popups at all after - nothing to indicate success or failure.
- The new records do not show in the Customer table -- whether viewing it in the browser or exporting all records to Excel
- I tried importing the same Excel file again in the same way. This time, I got a popup saying "Table 18 in the package TEST6 contains 2 records that will be overwritten by the import. Do you want to continue?". So now apparently Business Central thinks the customer No.s exist in the table, even though they do not show?
Why did the second attempt say that records will be overwritten? Did the first attempt import anything or not?
Any suggestion how to troubleshoot this?
