Documentation/ Integrations with external programs/ a3
a3
a3 is a Wolters Kluwer brand covering several different programs, and they do not all connect to Dijit.app the same way. Before reading the rest of this page, it is worth knowing which one your company uses.
On this page
- The three a3 programs
- The certified reseller's direct connector
- a3innuva: still to come
- The file: purchases and sales separately
- The company code in a3
- Before the first export
- How the file is exported
- What each entry contains
- The Canaries (IGIC)
- The review spreadsheet
- The risk of duplicating
- Things that come up
The three a3 programs
| Program | What it is | How Dijit.app reaches it |
|---|---|---|
| a3 asesor | The accounting program, the one practices use. | By link file, or over the reseller's direct connector. |
| a3 ERP | The brand's full ERP. | Only over the reseller's direct connector. |
| a3innuva | Management and accounting in the cloud. | Still to come. Not available yet. |
The rest of this page explains the two routes that are running today: the direct connector from the certified reseller, and the link file exported from Dijit.app.
The certified reseller's direct connector
This is the route for a3 ERP, and an alternative for a3 asesor. Dijit.app runs in its usual way, with nothing to install or set up: the connector is external, installed and maintained by the official certified a3 reseller, and it lives inside your company's own a3 program.
Dijit.app and that connector talk over an interface, already running. Dijit.app sends the documents; the reseller handles the installation, the set-up inside a3 and the maintenance and support of that side.
If your company uses this route, you will see no button and no screen in Dijit.app to do with a3: there is no "Export to a3" to press, because the sending happens on its own, behind the scenes. That is the right behaviour, not a fault in the application.
For questions about whether a particular document reached the other side properly, or about the connector's set-up inside a3, the certified reseller is the point of reference; Dijit.app support can confirm the side of the connection that belongs to it.
a3innuva: still to come
a3innuva is the a3 family's cloud version, with an interface of its own. The direct connection between Dijit.app and a3innuva is in development and is not available yet. If your company works with a3innuva, ask support where things stand before taking anything for granted.
The file: purchases and sales separately
What follows is a3 asesor's second route: instead of the direct connector, Dijit.app generates a file you import into a3 yourself.
| Export | From which list | Which documents it includes |
|---|---|---|
| Purchases | Purchase invoices and expense invoices | Whatever is ticked on that list, without mixing either type with sales. |
| Sales | Sales invoices | Whatever is ticked on the sales list. |
Each has its own Export to a3 button, on the list it belongs to, and generates its own file: there is no single export putting purchases and sales together.
The two files are called the same thing, SUENLACE.DAT, and their review spreadsheets carry
different names depending on which they came from, but the .DAT does not. Export purchases and sales one after the
other without importing the first into a3 or renaming the downloaded file, and the second overwrites the first
in your downloads folder.
The company code in a3
Each file carries a five-digit a3 company code. That is what tells a3 which company to load the entries into. You will find it in a3, in the list of companies. If your company uses the reseller's direct connector rather than the file, this code does not apply to you.
The code is held on the company's record, inside the clients and companies screen:
Side menu › Account › Clients / Companies › a3 code
- If you are an accountancy practice, each client has its own: open the client's record, fill in a3 code and save.
- If you keep your own books, the code goes on your own company's record, on that same screen.
The field takes numbers only, up to five digits, and it only appears on accounts that have a3 switched on. It also shows as a column in the list, so you can see at a glance who is missing one. The screen itself is covered in Clients and companies.
The code comes from the record of the company the invoices belong to: on purchases, whoever receives them; on sales, whoever issues them.
Each file carries a single company code. Where what you are exporting does not meet that condition, the file is not downloaded and the message says what to look at:
- Falta el código de empresa en a3 de: … Fill in the code on the records of the clients it names and export again.
- Las facturas seleccionadas son de varias empresas de a3 (…). Exporta las de cada cliente por separado. Tick one client's invoices, export them, load them into a3 and move on to the next.
- Estas facturas no corresponden a ningún cliente de Cuenta › Clientes / Empresas: … Those invoices' tax ID does not match any record. Add the client with the same tax ID the invoice carries.
Before the first export
The file carries whatever nominal accounts each invoice has in Dijit. If an invoice has none, that field comes out empty. There are three things to get done the first time:
- Add your clients. In Account › Clients / Companies, press New, fill in the name, the tax ID and the a3 code, and save. If you have many, the Excel import creates them in one go, although the a3 code does not travel in the template: it goes on each record afterwards.
- Load each client's nominal accounts. In Accounting › Chart of Accounts, press Import and follow the wizard: pick the client, download the template, fill it in with each account's code and name, and upload it. Before you type the codes, set the column to text format, so Excel does not eat the leading zeros. The procedure is in Importing the chart of accounts.
- Put the accounts on the invoices. Open the invoice and, in the general data, go down to Accounting classification. Set the invoice's account and the supplier's. Doing it once per supplier is enough: their next invoices arrive with the accounts already on. It is covered in Coding a document.
How the file is exported
As with every accounting export, whatever leaves Dijit.app wrong will enter the books wrong. Go over supplier, date, net, VAT and nominal account before downloading anything.
- Go to the right list: purchase or expense invoices for the purchases export, sales invoices for the sales one.
- Select the documents.
- Press Export to a3. The link file downloads straight away.
- If you want to look it over first, use the same button's arrow for the review spreadsheet instead of the file.
- Load the file into a3:
- Save the file in a folder on your computer under the name SUENLACE.DAT, exactly that. If the browser has added anything, such as "SUENLACE (1).DAT", take it off.
- In a3, go to Utilidades › Importar-Exportar › Enlace contable.
- In Acceso, point it at the folder where you saved the file.
- Before linking, press Chequeo: a3 marks each line right or wrong and says which field is at fault.
- Press Enlazar.
There is no loading order to respect within one file, unlike Contasol: it is a single document with everything selected. What does have to be respected is not mixing a purchases file and a sales file in the same loading session without having imported the previous one, precisely because they share a name.
What each entry contains
The file does not list the document's items: for each invoice it holds the VAT breakdown from the header, one line per tax rate on the invoice, with its net and its tax, plus the header details that identify the entry: supplier or client, number, date and total.
The nominal accounts used are the ones the document has already settled: the supplier's or client's from their record, the expense or income one from the document's coding, and the VAT and withholding ones from the document itself. If a document is missing any of those accounts, sort it out before exporting: the file is generated with whatever is there, and an empty account in a3 can end up falling into one that does not belong.
The Canaries (IGIC)
Nothing special to do. The file carries each invoice's percentage and a3 treats it as IGIC because the company is set up that way in a3. The invoices count towards the 415 return on their own.
The review spreadsheet
The review spreadsheet button downloads a sheet for looking the entries over before loading them. It is not imported into a3 or anywhere else. It is a checking aid, not an interchange format.
It carries exactly the same records as the corresponding link file, but readable: it is for the checking that does not fit on a screen, sorting by account, adding up columns, seeing that the totals agree with what you expected, before it goes into the books.
It is this integration's best practice: download the spreadsheet first, go over it, and only then export and load the link file.
The risk of duplicating
Like every file export, Dijit.app has no way of knowing whether the file was ever loaded into a3, and therefore does not stop you exporting the same invoices twice.
Keep track of what you have already loaded. Exporting by closed periods, and noting it, is the simple way of not duplicating entries.
Things that come up
| What you see | Why | What to do |
|---|---|---|
| I cannot find the "Export to a3" button | Your company uses a3 ERP, or uses a3 asesor over the reseller's direct connector. Neither goes through the button. | That is correct: the sending happens on its own, with no screen in Dijit.app. |
| The entry went into the wrong company in a3 | The a3 code on that company's record is wrong. (Does not apply with the direct connector.) | Put it right in Account › Clients / Companies and export again. |
| Falta el código de empresa en a3 de… | The company those invoices belong to has no code. | Put it on its record in Account › Clients / Companies. |
| Las facturas seleccionadas son de varias empresas de a3 | One file can only carry one company code. | Export each client's invoices separately, loading each file into a3 before downloading the next. |
| a3 asks for "Acceso" on importing | That is the folder the file is in. | Point it at the folder where SUENLACE.DAT was saved. |
| The file comes out with no accounts, or a3 flags empty accounts | The invoices have no accounts set in Dijit. | Work through the three steps in "Before the first export". |
| I work in the Canaries, with IGIC | — | Nothing: a3 recognises it on its own, as in "The Canaries (IGIC)". |
| I do not know whether my documents are arriving properly over the direct connector | Dijit.app shows no status for that connection on screen. | Ask the certified a3 reseller, or Dijit.app support. |
| a3 does not recognise the spreadsheet | The spreadsheet is for reviewing: it is not imported. | Load the SUENLACE.DAT file. |
| The sales file replaced the purchases one in the downloads folder | Both files are called the same, SUENLACE.DAT. | Import each file into a3 before generating the next, or rename it as you download it. |
| There are no documents to export | Nothing is ticked, or it is not the right type for that list. | Tick purchase or sales documents from their own list. |
| The integration is not enabled for this company | It needs switching on. | Ask Dijit IA for it. |
| The entries go in with the wrong account inside the right company | The invoices left Dijit.app with that account. | Go over the accounting section before exporting. The review spreadsheet shows it. |
| Entries have been duplicated in a3 | The same file was loaded twice. | Keep a record of the periods already loaded. |
| I need to send to a3innuva | That connection is not available yet. | Ask support where it stands. |