Import records script doesn't work the same as a manual import
I have a file where multiple imports are done from a .xlsx file.
It's a fairly simple file with two tables - one for Inventory import and the other for a Scanned Count. If I manually import from the Inventory layout, choosing the inventory worksheet in Excel, the records come in normally.
If I move to the Scanned Count layout, which is associated with the Scanned Count table, and manually import the records from the Excel worksheet for the scan, the records come across normally and then a sub summary report is used to count the individual items.
For some reason, when I script the import, it will only default to the Inventory table.
My script starts with Go To Layout to the Scanned Count layout, which is associated with the Scanned Count table. For some reason, I can see using the Script Debugger that the Inventory table is selected as the target and no other option to change it is present.
I'm wondering why it would work differently in a script than in "manual mode".