Inventory & Stock Control: Import Inventory Stock Transactions

Follow

Inventory Stock transactions can be imported from a tab-delimited text file. It is recommended to export an existing Inventory Stock Transaction, modify the text (e.g. using Notepad) and save with a different filename.

Contact Centaur Support if assistance is required.

  1. Go to Location Management > Stock Control tab

  2. Enter the username and password of the staff member responsible for the stock list
  3. Operations menu > Import

    1. Select the location to open the file

    2. Select the file to be opened (e.g. Stock Input)

    3. Click Open
      mceclip0.png
    4. Click Accept to save the transaction

The text must be saved in a particular format, and this is different depending on the type of transaction being imported. See below examples.

 

Input Inventory Items

mceclip2.png

1

Staff Member Responsible for Inventory

2

Transaction Date

3

Transaction Number

4

Transaction Type (1 = Input Inventory Items)

5

Notes

6

Inventory Item Code

7

Inventory Stock Quantity

8

Total Cost


Liquidate Inventory Items

mceclip4.png

1

Transaction Date

2

Transaction Number

3

Transaction Type (3 = Liquidate Inventory Items)

4

Notes

5

Staff Member Responsible for Inventory

6

Inventory Item Code

7

Inventory Stock Quantity

8

Total Cost
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.