You can use the Import option to import data into your accounts, either to create or update your stock transactions. 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 transactions
| Field | Type | Size | Left blank? | Format | Excel column | Report to use | | Transaction Type | Text | 2 | No | This must be AI, AO, DI, DO, GI, GO, GR or WO. | A | Product Transaction CSV | | Stock Code | Text | 30 | No | The stock code must already exist in your accounts data. | B | Product Transaction CSV | | Date | Date | 10 | Yes - Uses the current program date. | Enter the format DD/MM/YYYY. | C | Product Transaction CSV | | Reference | Text | 8 | Yes | | D | Product Transaction CSV | | Details | Text | 60 | Yes | | E | Product Transaction CSV | | Quantity | Decimal | 11 | No | 8 digits + 2 decimal places. | F | Product Transaction CSV | | Cost Price | Decimal | 11 | Yes | 8 digits + 2 decimal places. | G | Product Transaction CSV | | Sales Price | Decimal | 11 | Yes | 8 digits + 2 decimal places. | H | Product Transaction CSV |
|