Error 3The statement has been terminated.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_DOCLINE_STOCK". The conflict occurred in database "MSSQL-HANDYMAN", table "dbo.Stock", column 'WStockID'.

This option will allow you to import data for Stock items from a valid file format into an existing Set of Books. To be able to import the data for Stock items, you need to have created a valid XML Database File format or a valid Lotus Spreadsheet file format on your system in Export (Setup ribbon). 

To import Stock items: 

  1. On the Setup ribbon, select Import. The "Import Data into osFinancials" screen is displayed: 

  1. Select Stock as the Data type to import, if not already displayed.
  2. Select one of the following file types in which the data to import, is saved on your system: 
    1. Tab delimited (recommended)
    2. Comma Separated Values (*.CSV) 
    3. Tab Delimited (*.TXT)
    4. XML Database File (*.XML) 
    5. Lotus Spreadsheet File (*.WK1)
  1. Click on the button to locate the data file. The following screen is displayed: 
  2. Click on the button to locate the data file. 

Optional - You may click on the View file button to view the file in your system's default app (program) associated with the exported file type.

An example of the exported Tab Delimited text file is as follows:
  1. Click on the button. The following screen is displayed:
  2. Click on the Import button. The "ImportCheck" screen is displayed: 
  3. You may use the record buttons to add, delete or change the stock records on the "ImportCheck" screen. You may then click on the All or OK buttons to import the stock file. 
  4. Once the import process is finished an information message is displayed: 

"Data file import completed!" 

  1. Click on the OK button.  
  2. Go to the Reports ribbon and select Reports → Stock items → Stock item listing to check the stock items. 
  3. Go to the Default ribbon and select Stock items to edit the stock items, if necessary.