Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
Lines of code | 258 |
Technical Name |
quadra_export_ascii |
License | LGPL-3 |
Website | http://www.auneor-conseil.fr |
Versions | 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 |
Quadratus Export ASCII
Odoo expert
Integrator since 2012
>
T
h
i
s
m
o
d
u
l
e
a
l
l
o
w
t
o
e
x
p
o
r
t
a
c
c
o
u
n
t
m
o
v
e
l
i
n
e
s
i
n
a
n
A
S
C
I
I
f
o
r
m
a
t
a
c
c
e
p
t
e
d
b
y
Q
u
a
d
r
a
t
u
s
a
p
p
l
i
c
a
t
i
o
n
.
N
o
t
e
:
T
h
e
p
a
r
t
n
e
r
i
n
t
e
r
n
a
l
r
e
f
e
r
e
n
c
e
i
s
u
s
e
d
i
n
s
t
e
a
d
o
f
a
c
c
o
u
n
t
c
o
d
e
f
o
r
r
e
c
e
i
v
a
b
l
e
/
p
a
y
a
b
l
e
a
c
c
o
u
n
t
s
s
t
r
o
n
g
>
/
s
t
r
o
n
g
>
/
p
>
p
>
/
p
>
p
>
s
t
r
o
n
g
>
U
s
a
g
e
:
/
s
t
r
o
n
g
>
/
p
>
u
l
c
l
a
s
s
=
"
s
i
m
p
l
e
"
>
l
i
>
G
o
t
o
t
o
A
c
c
o
u
n
t
i
n
g
&
g
t
;
R
e
p
o
r
t
&
g
t
;
Q
u
a
d
r
a
&
g
t
;
E
x
p
o
r
t
A
S
C
I
I
/
l
i
>
l
i
>
F
i
l
l
s
t
a
r
t
a
n
d
e
n
d
d
a
t
e
/
l
i
>
l
i
>
C
l
i
c
k
o
n
"
G
e
n
e
r
a
t
e
"
b
u
t
t
o
n
/
l
i
>
l
i
>
A
w
a
r
n
i
n
g
i
s
d
i
s
p
l
a
y
e
d
t
o
a
l
e
r
t
i
f
t
h
e
r
e
i
s
m
i
s
s
i
n
g
"
I
n
t
e
r
n
a
l
R
e
f
e
r
e
n
c
e
"
o
n
p
a
r
t
n
e
r
a
s
s
o
c
i
a
t
e
d
t
o
"
R
e
c
e
i
v
a
b
l
e
"
/
"
P
a
y
a
b
l
e
"
a
c
c
o
u
n
t
s
/
l
i
>
l
i
>
D
o
w
n
l
o
a
d
y
o
u
r
A
S
C
I
I
f
i
l
e
a
n
d
i
m
p
o
r
t
i
t
o
n
Q
u
a
d
r
a
/
l
i
>
/
u
l
>
p
>
s
t
r
o
n
g
>
/
s
t
r
o
n
g
>
/
p
>
p
>
s
t
r
o
n
g
>
C
o
n
f
i
g
u
r
a
t
i
o
n
:
/
s
t
r
o
n
g
>
/
p
>
p
>
I
n
A
c
c
o
u
n
t
i
n
g
/
C
o
n
f
i
g
u
r
a
t
i
o
n
/
S
e
t
t
i
n
g
s
y
o
u
h
a
v
e
a
n
o
p
t
i
o
n
"
Q
u
a
d
r
a
E
x
p
o
r
t
G
r
o
u
p
L
i
n
e
s
"
,
t
h
i
s
a
l
l
o
w
t
o
g
r
o
u
p
t
h
e
m
o
v
e
l
i
n
e
s
b
y
a
c
c
o
u
n
t
/
j
o
u
r
n
a
l
e
n
t
r
y
/
p
a
r
t
n
e
r
d
u
r
i
n
g
t
h
e
e
x
p
o
r
t
.
/
p
>
p
>
I
n
C
o
n
t
a
c
t
s
f
o
r
m
v
i
e
w
,
2
f
i
e
l
d
s
a
d
d
e
d
:
/
p
>
u
l
c
l
a
s
s
=
"
s
i
m
p
l
e
"
>
l
i
>
"
C
u
s
t
o
m
e
r
R
e
f
Q
u
a
d
r
a
"
/
l
i
>
l
i
>
"
S
u
p
p
l
i
e
r
R
e
f
Q
u
a
d
r
a
"
/
l
i
>
/
u
l
>
p
>
I
n
o
r
d
e
r
t
o
u
s
e
a
d
i
f
f
e
r
e
n
t
r
e
f
f
o
r
p
a
r
t
n
e
r
w
h
i
c
h
a
r
e
c
u
s
t
o
m
e
r
a
n
d
s
u
p
p
l
i
e
r
,
w
h
e
n
a
n
a
c
c
o
u
n
t
l
i
n
e
i
s
e
x
p
o
r
t
e
d
,
w
e
u
s
e
:
/
p
>
u
l
c
l
a
s
s
=
"
s
i
m
p
l
e
"
>
l
i
>
T
h
e
"
C
u
s
t
o
m
e
r
R
e
f
Q
u
a
d
r
a
"
o
f
t
h
e
p
a
r
t
n
e
r
i
f
d
e
f
i
n
e
d
a
n
d
a
c
c
o
u
n
t
t
y
p
e
i
s
"
R
e
c
e
i
v
a
b
l
e
"
/
l
i
>
l
i
>
T
h
e
"
S
u
p
p
l
i
e
r
R
e
f
Q
u
a
d
r
a
"
o
f
t
h
e
p
a
r
t
n
e
r
i
f
d
e
f
i
n
e
d
a
n
d
a
c
c
o
u
n
t
t
y
p
e
i
s
"
P
a
y
a
b
l
e
"
/
l
i
>
l
i
>
T
h
e
"
R
e
f
e
r
e
n
c
e
"
f
i
e
l
d
(
a
l
s
o
u
s
e
d
b
y
t
h
e
F
E
C
)
i
f
d
e
f
i
n
e
d
a
n
d
t
h
e
a
c
c
o
u
n
t
t
y
p
e
i
s
"
P
a
y
a
b
l
e
"
o
r
"
R
e
c
e
i
v
a
b
l
e
"
/
l
i
>
l
i
>
O
t
h
e
r
w
i
s
e
,
w
e
u
s
e
t
h
e
a
c
c
o
u
n
t
c
o
d
e
/
l
i
>
/
u
l
>
-
Features :






Vous pouvez envoyer un mail à l’adresse : support@auneor-conseil.fr en précisant dans l’objet du mail le nom du module ou nous joindre par téléphone. Il faudra également nous joindre une copie de la facture d’achat du module Odoo apps.
- Le support est-il compris dans le module ?
Non, seul les dysfonctionnements sont pris en compte dans le support, sinon vous devez avoir un contrat de support Aunéor Conseil.
- L’hébergement est-il compris dans le module ?
Non. Si vous souhaitez être hébergé chez Aunéor Conseil ou chez Odoo, alors vous pouvez souscrire un
contrat auprès d’Aunéor Conseil ou d’Odoo mais ce contrat d’hébergement sera indépendant du présent module.
Pour plus d’informations sur notre contrat d’hébergement :
https://www.auneor-conseil.fr/page/integration-et-hebergement
Plus d’informations sur le contrat d’hébergement Odoo.sh :
https://www.odoo.sh
Pour tout autre question, si vous ne trouvez pas la réponse dans les FAQS, contactez-nous par mail ou par téléphone.
This module allow to export account move lines in an ASCII format accepted by Quadratus application. Note: The partner internal reference is used instead of account code for receivable/payable accounts
Usage :
- Go to to Accounting > Report > Quadra > Export ASCII
- Fill start and end date
- Click on "Generate" button
- A warning is displayed to alert if there is missing "Internal Reference" on partner associated to "Receivable"/"Payable" accounts
- Download your ASCII file and import it on Quadra
Configuration :
In Accounting/Configuration/Settings you have an option "Quadra Export Group Lines", this allow to group the move lines by account/ journal entry / partner during the export.
In Contacts form view, 2 fields added:
- "Customer Ref Quadra"
- "Supplier Ref Quadra"
In order to use a different ref for partner which are customer and supplier, when an account line is exported, we use:
- The "Customer Ref Quadra" of the partner if defined and account type is "Receivable"
- The "Supplier Ref Quadra" of the partner if defined and account type is "Payable"
- The "Reference" field (also used by the FEC) if defined and the account type is "Payable" or "Receivable"
- Otherwise, we use the account code
-
Features :
- export account move lines
- grouping of moving lines by account/entry/partner during export
- Added of two fields : Customer Ref Quadra and Supplier Ref Quadra
How to configure

Go to to Invocing or Accounting > Reporting > Quadra > Export ASCII

Fill start and end date and click on generate button

Select the journals you want to export (all journals are exported if left empty)

Choose the state (draft and /or posted) of the items you want to export (posted by default)

Allow to enter the quantity to be reserved when clicking

Download your ASCII file and import it on Quadra
This module allow to group the move lines by account/ journal entry / partner during the export
You can send an email to the address: support@auneor-conseil.fr specifying the name of the module in the subject of the email or contact us by phone. You will also need to attach a copy of the purchase invoice for the Odoo apps module.
- Is the support included in the module ?
No, only malfunctions are taken into account in the support, otherwise you must have an Auneor Conseil support contract.
- Is accommodation included in the module ?
No. If you wish to be hosted by Auneor Conseil or Odoo, then you can sign a contract with Auneor Conseil or Odoo but this hosting contract will be independent of this module.
For more information on our hosting contract:
https://www.auneor-conseil.fr/page/integration-et-hebergement
For more information on Odoo.sh hosting contract :
https://www.odoo.sh
For any other questions, if you cannot find the answer in the FAQs, please contact us by email or phone.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedSaving a lot of time
It's working perfectly, and it saved us a lot of time.
Only problem is that export is running for the user default company.
So we can't export multi-companies, and we have to go on our own user profile, and change default company to export operations of another company.
Re: Saving a lot of time
Hello Mr Guimier,
Thank you for your remark and for downloading the module. We are currently considering making an adaptation of this module to export multi-companies. So, could we contact us by tel : 09 72 63 50 88 or by mail : support@auneor-conseil.fr, in order to explain us your need ?
There are no comments yet!