# Offset sales to and purchases from one party
**URL:** https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462
**Category:** User
**Tags:** accounting
**Created:** [August 22, 2023, 7:02am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462 "2023-08-22T07:02:41Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [August 22, 2023, 7:02am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/1 "2023-08-22T07:02:41Z")
Hello everybody,
I have a customer who normally purchases good from us; now they have some goods we purchase from them. So I created a purchase which creates a separate supplier’s invoice. It would be nice to find this position as a subtraction (offset) at my customers’ invoice for the party in question. Do we have a module - or another procedure - for this task? This is not a big deal, just a “nice-to-have”.
Cheers,
Wolf
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [August 22, 2023, 7:04am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/2 "2023-08-22T07:04:55Z")
You should create both a customer and supplier invoice.
Once you have the payable and receivable lines, there is a wizard to create a balance move, which will move the balance to the payable or receivable amount (the one bigger) and mark the invoice with less amount paid.
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [August 22, 2023, 7:19am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/3 "2023-08-22T07:19:54Z")
> [@pokoli](#):
>
> there is a wizard to create a balance move,
Thank you. Guess, the invoices should not be posted yet? Where can I find that wizard mentioned - it seems to be under none of the propeller icons?
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [August 22, 2023, 7:24am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/4 "2023-08-22T07:24:36Z")
The invoices should be posted as the wizard is on the account lines. It is called Group lines and it is under the actions icon in the receivable/payable view of the party (or any move lines view).
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [August 22, 2023, 10:45am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/5 "2023-08-22T10:45:19Z")
Thank you. Is this the view you’re talking about:
Under the propeller icon, I see “erase, replace, check VIES, and translate view”.
Do I still need a particular module? - I’m in my 6.4 testing.
Cheers,
Wolf
---
### Author:  [@acaubet](https://discuss.tryton.org/u/acaubet)
#### Post date: [August 22, 2023, 11:33am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/6 "2023-08-22T11:33:35Z")
At the party, navigate to the “Relate” button (located to the right of the propeller icon). Choose “Payable/Receivable Lines”. Once in that view, you can select multiple account move lines. Using the propeller icon, you can then access and run various wizards, such as “Group”.
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [August 22, 2023, 3:03pm UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/7 "2023-08-22T15:03:34Z")
Thank you very much. Right, I found out how to group lines.
But what I wanted is in the end a customer invoice which says something like
```auto
Our deliveries:
xxx
yyy
zzz
subtotal: 500.-
--------------------------------------------
Your deliveries:
aaa
bbb
ccc
subtotal -70.-
============================================
total: 430.-
```
Can that be done in Tryton ?
Cheers,
Wolf
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [August 22, 2023, 4:02pm UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/8 "2023-08-22T16:02:20Z")
It is possible but it is not managed by any standard module.
So you must create a custom code which “converts” the supplier invoice lines into customer invoice lines with the right quantities.
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [August 22, 2023, 5:55pm UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/9 "2023-08-22T17:55:48Z")
Allright. Thank you to both of you.
It’s not really important. Many other features I’d regard as much more important.
Cheers,
Wolf
---
### Author:  [@SISalp](https://discuss.tryton.org/u/SISalp)
#### Post date: [August 23, 2023, 7:04am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/10 "2023-08-23T07:04:45Z")
I’m not convinced this invoice would be legal in France.
There is a difference between party payment balance and invoicing.
In particular this seems to be in contradiction with tax regulations.
From my point of view, the problem should be addressed in this way:
* * *
xxx
yyy
zzz
Total: 500.-
VAT: 100
Early payment : 0
TOTAL tax included 600
* * *
Previous situation
Your Invoice n° 12345, date : yy/mm/ff -84
Net to pay on yy/mm/dd:
total: 514
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [August 23, 2023, 7:12am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/11 "2023-08-23T07:12:20Z")
This sounds a little bit like dunning.
I’ve already done such customization of the invoice template (display customer payable/receivable) but I dislike it because then we store temporary data in the invoice archive. But probably a module that append the customer balance as a next page to the invoice report like [Account Invoice Watermark Module](https://docs.tryton.org/projects/modules-account-invoice-watermark/en/latest/#account-invoice-watermark-module) will be great.
---
### Author:  [@SISalp](https://discuss.tryton.org/u/SISalp)
#### Post date: [August 23, 2023, 7:22am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/12 "2023-08-23T07:22:05Z")
It sounds correct as we do not justify taxes to be paid by the supplier by a local invoice as previously proposed.
How would payment terms be considered ?
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [August 23, 2023, 7:24am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/13 "2023-08-23T07:24:51Z")
> [@SISalp](#):
>
> How would payment terms be considered ?
I guess like with dunning, a list of date, amount and origin with a total at the end.
---
### Author:  [@system](https://discuss.tryton.org/u/system)
#### Post date: [September 22, 2023, 7:25am UTC](https://discuss.tryton.org/t/offset-sales-to-and-purchases-from-one-party/6462/14 "2023-09-22T07:25:13Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.