You can use the Import option to import data into your accounts, to create your stock takes. Here you can check which data fields you can import and find out more about the format required for each field.  TIP: There are reports in Sage 50 Accounts that you can use to export your existing data in the correct format for CSV files.
Stock Take | Field | Type | Size | Left blank? | Format | Excel column | Report to use | | Stock Code | Text | 30 | No | The stock code must already exist in your accounts data. | A | Stock Take Import Report | | Date | Date | 10 | Yes - Uses tthe current program date. | Enter the format DD/MM/YYYY. | B | Stock Take Import Report | | Reference | Text | 30 | Yes | | C | Stock Take Import Report | | Actual | Decimal | 11 | No | 8 digits + 2 decimal places. | D | Stock Take Import Report |
|