Audit trail transactions View Transaction types >
| Yes | You can't import the following:
- Foreign bank transactions - you must enter these manually
- Sales receipt (SR) - Instead, import as a sales payment on account (SA) and then manually allocate
- Purchase payment (PP) - Instead, import as a purchase payment on account (PA) and then manually allocate
- Sales discount (SD) - Instead, import as a sales credit (SC) and then manually allocate
- Purchase discount (PD) - Instead, import as a purchase credit (PC) and then manually allocate
- CIS deductions or payments on account for CIS purposes
- When entering a Project Ref against certain transactions (for example purchase invoice (PI) and bank payments (BP)), you must also enter a Code Code and vice versa
- Sage 50 Accounts v29.0 and below: Charities - you can't import a transaction with a fund reference. As a workaround, you can import and then Correct the transaction to add the fund reference
- When importing journals from the audit trail any cost codes and project references are not imported
|
Bank accounts | See exceptions. | You must import bank accounts as nominal records and then convert them manually to bank accounts. First import the bank nominal codes, then: - Click Bank accounts then click New/edit.
- In A/C Ref enter the required nominal code and press Enter.
- When the message 'A nominal account with this reference already exists - do you wish to convert it to a bank account?' appears, click Yes.
- Click Save then click Close.
|
Customer records | Yes | You can't import customer delivery addresses. |
Fixed asset records | Yes | None |
Invoice and credits | No | You can't import into the Invoices and credit module. You can import sales invoice (SI) and sales credit (SC) transactions as audit trail transactions.
Alternatively, there may be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace. |
Nominal accounts and standard budgets | Yes | You can't import advanced budget information. You can check if you use the standard or advanced budgeting method in Settings, Company Preferences on the Budgeting tab. |
Price lists | See exceptions. | You must import price lists from within the price list record. |
Product records | Yes | You can't import the following: - Bill of materials (BOM) information
- Quantity in stock - Instead you can import an adjustment in (AI) stock transaction for the required quantity
- Sage 50 Accounts v28.0 and below: Intrastat duty code - the 2-digit field after commodity code
|
Project records | Yes | None |
Project-only transactions | Yes | None |
Purchase orders | No | You can't import into the Purchase order module.
However, there may be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace. |
Sales orders | No | You can't import into the Sales order module.
However, there may be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace |
Quotations | No | You can't import into the Quotations module.
However, there might be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace. |
Stock take | Yes | None |
Stock transactions | Yes | You can't import the following: - Movement out (MO) - Instead, import as an adjustment out (AO)
- Movement in (MI) - Instead, import as an adjustment in (AI)
|
Subcontractors records | No | You can't import CIS information into supplier records to create subcontractors. Instead, import the supplier record, and then enter the CIS information manually. |
CIS subcontractor transaction
| No | You can't import CIS subcontractor transactional information. |
Supplier records | Yes | You can't import supplier delivery addresses. |