Import Current Stock levels to new inventory
I went to a Filemaker demo with our local APR this week and have started to create a new inventory database based on the template in FM12.
I have managed to import the individual items, codes and prices etc - however I cannot seem to get the current stock level quantity into the database. I realise this is automatically read from the Stock Transactions table and therefore means importing a bulk transaction for each item to provide the initial stock level however I cannot seem to get the data in. I presume it cannot match to the individual item as it uses the "item ID match field" which isn't in my original data - but I don't know how to establish what the 'item ID match field" is from the data I have imported or relate it?
Any suggestions - surely I don't need to manually enter the initial stock level for each item? I am very new to FM!