How do I move documents to the Desktop ERP?
The Transfer to the desktop ERP screen prepares a file with the documents or records made here so that the Desktop ERP creates them there. It is used when the two programmes run side by side and part of the work is done in each one.
Which documents can be moved?
Sales quotes, orders, delivery notes, invoices and credit notes, and purchase orders, goods receipts and purchase invoices. Each one arrives in the Desktop ERP as one of its own documents, of the same type:
- Sales: the Desktop ERP gives it its own number, with its series, and stores the one from here as a reference.
- Sales invoices and credit notes: in addition, they arrive pending sending to the Tax Agency. The Desktop ERP sends them, since it is the one that keeps their numbering. A credit note arrives with the invoice it corrects.
- Purchases: it keeps the supplier’s invoice number, the one written in Supplier invoice no..
How do I do it?
Go to Tools › Transfer to the desktop ERP. On the Documents tab:
- Choose the dates in From and To. By default, the current month.
- If you want, narrow it down by Series, by number (From no., To no.), by Customer (from, to) or by Supplier (from, to). The number is the sequence within the series: invoice 340023 is series 34, number 23. The customer applies to sales and the supplier to purchases. With F2 or the magnifying glass you search for the code. In Origin you choose All, only those ‘Imported from PDF’ (the ones created by reading PDF invoices) or only those ‘Created in the ERP’.
- Tick the document types you want to move. They all start ticked.
- Click Prepare. At the top you see how many go in the file and how many aren’t transferred.
- Click Download the file.
- Put the file in the Desktop ERP’s document import folder and run the import there: it is the same one that reads PDF invoices. Next to the file another one appears, ending in
.resultado.txt, with what happened to each document.
Preparing doesn’t change anything in this ERP: you can repeat it as many times as you like.
And records without a document?
On the Records tab you move individual customers, suppliers and items. Tick which ones, and if you want only those Changed since a given day or a range of codes for each. Prepare says how many go and Download the file downloads it. It is put in the same Desktop ERP folder.
For an item, its code, name, description, barcode, item family, supplier and its reference, the VAT, the six sales prices and the purchase price travel. For a customer or a supplier, their code, legal name, Tax ID, address, town / city, province, postcode, phone, email, country and contact person.
Can it happen by itself, without downloading anything?
Yes. After Prepare, click Send to the desktop ERP instead of downloading. The send waits here and the Desktop ERP collects it when someone runs its document import there, the same one that reads PDF invoices: no file needs to be copied.
On the Sends to the desktop ERP tab you see each send: whether it is waiting, being imported, went in (how many documents imported, discarded and with errors) or could not be imported, with the Desktop ERP's report. One that is still waiting can be Withdrawn.
Sending needs a connection: on that same tab, Create connection gives a key that is entered in the Desktop ERP (the technician does it). It is shown only once. It is the transfer's connection: it has nothing to do with the consignment notes one.
Why isn’t a document transferred?
The What is not transferred, and why table gives the reason for each one:
| Reason | What to do |
|---|---|
| It is a draft | Confirm it and prepare again |
| It is voided | Nothing: a voided document isn’t taken |
| It has already been delivered or invoiced in the ERP | Nothing: in the Desktop ERP it would be left pending and could be invoiced twice |
| This ERP has already sent it to the Tax Agency, or has it queued to send | Nothing: if it travelled, it would go to the Tax Agency twice |
| It has no customer or supplier | Give it one |
| The purchase invoice doesn’t have the supplier’s number | Write it in Supplier invoice no.: it is how the Desktop ERP recognises it |
| It has expenses outside the tax base (disbursements) | Move it by hand: the Desktop ERP doesn’t tell them apart |
| It is a distance sale with the one-stop shop | Move it by hand: the Desktop ERP doesn’t have that scheme |
| It is in another currency | Move it by hand |
| It came from the desktop ERP in the migration: it already exists there | Nothing: if it went back, the Desktop ERP would have it twice |
Advance payment invoices aren’t transferred.
What happens with the customer or the supplier?
The Desktop ERP looks for them first by their code, if the Tax ID matches, then by the Tax ID and finally by the name. If it doesn’t find them, it creates the record with the name, the Tax ID, the address, the town / city, the province, the phone and the email from here.
The items on the lines are looked up by their exact code. A line whose code doesn’t exist in the Desktop ERP goes in anyway, with its description, its quantity and its price, but without an item.
What happens with the free text and the text of the lines?
The Desktop ERP has no formatted text. The document’s free text and the text written below each line arrive in the document’s notes, after the notes it already had: without bold or italics, with lists as rows with their bullet or number, and without the images. The text of a line is preceded by that line’s description. The lines and the amounts arrive as always.
What happens if I move the same document twice?
It isn’t duplicated. The Desktop ERP recognises a document it has already imported by its number from here (or the supplier’s invoice number) and its customer or supplier, and leaves it as it was. The file already imported is renamed with the ending .importado, so it isn’t read again either.
And what if I pick the wrong company?
The file carries the Tax ID of the company that prepared it. The Desktop ERP doesn’t import anything if the company it has open has a different Tax ID, and it says so in the .resultado.txt.