AnsweredAssumed Answered

Import Current Stock levels to new inventory

Question asked by LauraBarnett on May 2, 2013
Latest reply on May 2, 2013 by philmodjunk

Title

Import Current Stock levels to new inventory

Post

     Hi

     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!

     Thank you 

     Laura

Outcomes