Skip to Content
This question has been flagged
2 Replies
4651 Rodiniai
Portretas
Fern wealth

I want to import thousands of invoices to Odoo however it won't work correctly as my customers all have only one receivable account (which defaults to our reporting currency).

This results in a sold product correctly booked to a revenue account in EUR for instance but with in debit a receivable in CHF, instead of EUR.  I want to avoid having to manually alter each invoice after import.

When I try to add the journal line in my import, I get this message on the import test "The account selected on your journal entry forces to provide a secondary currency. You should remove the secondary currency on the account"
How can I configure my import template to avoid this?


Portretas
Atmesti
Portretas
Yurimer Calderón
Best Answer

Hello Patricia. 

In the accounting entry to be imported into Odoo, the amount expressed in the secondary currency must be positive when the account is debit and negative when the account is credit. In addition, the currency field must be empty when the amount is expressed in the company's currency, otherwise it generates the error you indicate.
Example import template:Second Part:
After reviewing your use case, I understand that you want to import the invoices and segment the accounting account receivable according to the currency of the invoice, be it USD, EUR or any other currency.
It is important to remember that this way you separate the account receivable according to the foreign currency (currency), Odoo records the balances in your local currency.

Based on your need, I explain the steps you can take
1. Go to your chart of accounts and create separate accounts receivable according to currency as shown in the following image:

When creating the accounting account you can select the currency:

2. The accounting entry once you import the invoices should be shown in Odoo as in the following image:

Example Invoice in USD and Invoice in EUR for the same customer
In the data import template you should consider in addition to the currencies, the accounting accounts that you mentioned you created. This import template is from the entry shown above, for two invoices from the same customer.


I show you the fields contained in the import template:

Reporting:
Aged Receivable 

General Ledger:

You have many ways to build the migration template. It will also depend on how you want to view the invoices in the accounting reports.

Additional note:

When you want to create an invoice to the customer in Odoo, you can in the invoice in "draft" status directly select the account receivable of your preference, for the accounting entry.

 

Portretas
Atmesti
Fern wealth
Autorius

Thank you but the issue is with the customer set up, I think

Portretas
Fern wealth
Autorius Best Answer

Hello and thank you for your reply :-)

I have made some changes to my import spreadsheet, now I don't have the secondary currency error message any more but my journal lines are still incorrect. Here is a sample of what I am trying to import: 


But here is how the first invoice looks on Odoo:  
I expected the account I have circled in red to be "1101 Receivables EUR" as per my chart of account.


I think it is because the customer is set up with this CHF Receivable account, hence my question "how to add multiple receivables account to a customer", see:


I just changed the customer setting to 1101 Receivables EUR and now my accounting entry is correct:


Unfortunately, this client does not only pay invoices in EUR but also in GBP, USD or CHF and it is not possible to add more than one account receivable to a customer... so what to do?  A manual correction of the invoice seems to work but that is not efficient with thousands of invoice lines to upload :-((


Portretas
Atmesti
Yurimer Calderón

Hi Patricia.

Add additional information in my answer. I hope it can help you.

Greetings!