DOWNLOAD SAMPLE FILE: Stock_Adjustments.csv
This is a simple 6-column ASCII CSV file without any fixed filename for TASBooks with Stock datasets only. Columns 4 to 6 are optional and can, therefore, be missing. It is used to perform Stock Adjustments for multiple products in one run. The MultiTAS Stock Adjustment function lets you handle adjustments in two modes:
- Adjustment mode – the adjustment is made based on +/- Quantity in the more traditional way.
- Actual Quantity mode – the counted Quantity is used (e.g. from data produced by stock count barcode readers) and the function automatically calculates the +/- adjustment quantity required.
The contents can easily be produced in Excel and saved as a CSV file. Alternatively, it may be produced directly by an upload from a stock count barcode reader device or by its management software.
If using Excel, pay particular care for codes that begin with a zero (0).
| Field | Label | Data Type | Max Size | Required? | Sample values | Remarks |
|---|---|---|---|---|---|---|
| 1 | Product Code | A | 20 | Y | PRODUCT01 | TAS Product/Service code; must be valid in TAS |
| 2 | Quantity | N | 9 | Y | 17.23 | Depending on Mode: Adjustment quantity, max = 99999.99, minimum = -99999.99; Quantity (counted) in stock, max = 99999.99, min = 0.00; max 2 d.p. |
| 3 | Adjustment Description | A | 40 | N | Stock Adjustment PRODUCT01 | optional; if blank defaults to “Stock Adjustment ” & Product Code, i.e. max 27 characters. Note that though max characters is 40, this is truncated to 29 characters max in the Financial Journal Posting |
| 4 | Cost Amount | N | 11 | N | 12.5 | optional; must be null, 0 or positive and max 2 d.p.; if null, defaults to appropriate TAS cost price. Max value = 99999999.99. |
| 5 | NL Account | N | 6 | N | 1610 | optional; with NL Department must be valid TAS CoA record |
| 6 | NL Department | A | 3 | N | 100 | optional; with NL Account must be valid TAS CoA record |
| Carriage Return (Hex = 0D, Dec = 13) | ||||||
| Line Feed (Hex = 0A, Dec = 10) |