Fwd: Re: 1 payment, two jobs - job report error

Geert Janssens geert.gnucash at kobaltwit.be
Sat May 7 09:17:21 EDT 2016


Please remember to copy your replies on list, so everybody can follow.

As for the content of your message: it's not appalling to me to have the check recorded twice 
(with partial amounts). I was mostly pointing this out for others following the thread.

And I'm afraid I don't understand exactly what you are saying about "going into the second 
invoice to add a discount mount".

The system is designed to cope with one payment for multiple invoices (except for the bug in 
the job report that was discovered just now).

The proper way to handle this depends on whether both invoices already exist at the time of 
the payment or not.

If they do, you can
- Select Business->Customer->Process Payment
- choose the correct customer (and A/R account if you have multiple)
- select both invoices to pay (with ctrl-click)
- optionally adjust the payment amount to what was actually received
- select the account which received the payment (eg checking account)
- click ok

If only one invoice exists at the time of the payment and the other one will only be entered 
later, this becomes:
- Select Business->Customer->Process Payment
- choose the correct customer (and A/R account if you have multiple)
- select the first invoice to pay (with ctrl-click)
- adjust the payment amount to what was actually received
- select the account which received the payment (eg checking account)
- click ok
Then when the second invoice gets entered:
- Select Business->Customer->Process Payment
- choose the correct customer (and A/R account if you have multiple)
- select the second invoice to pay together with the pre-payment that has been created while 
paying the first invoice (with ctrl-click)
- optionally adjust the payment amount the difference if the total payment didn't match the 
total amount of the two invoices together
- select the account which received the payment (eg checking account)
- click ok

I *think* this second method is what you are trying to achieve, but it looks like you didn't know 
you can select more than one line in the list of invoices/pre-payments. When you select both an 
invoice and a pre-payment, the amount to pay/refund should be adjusted automatically to the 
difference between the two. You usually don't have to change that amount.


Note that both methods will get a buggy job report due to a bug in that report. Your first 
proposed method is a good workaround.

Regards,

Geert

----------  Forwarded Message  ----------

Subject: Re: 1 payment, two jobs - job report error
Date: Saturday 07 May 2016, 07:42:41
From: Godaddy Personal <dave at davegillam.org>
To: Geert Janssens <geert.gnucash at kobaltwit.be>

I *think* the proper way to do this is:

Record the full payment amount against one of the invoices.  The overage will show as an A/R 
credit for the customer.
When paying the second invoice, refund the overage amount.

In my testing, you'll still need to go into the second invoice to add a discount mount equal to 
the refund amount.  Perhaps this was just because I tested with an overage that was the same 
as the invoice amount.

My workaround seems to me to be simpler and more direct, but if having the check recorded 
twice in the register is appalling to you, the above method should overcome it.  ;-)

Dave Gillam
dave at davegillam.org <mailto:dave at davegillam.org>
> On May 7, 2016, at 4:15 AM, Geert Janssens <geert.gnucash at kobaltwit.be> wrote:
> 
> It looks like a bug to me as well. Thanks Katie for making the bug report.
>  
> Dave's way of recording the payment is a reasonable workaround. The only disadvantage is 
that the payment is recorded in two separate transactions in the checking register instead of 
one.
>  
> Regards,
>  
> Geert
>  
> On Friday 06 May 2016 07:34:30 Godaddy Personal wrote:
> > Perhaps I do it incorrectly, but when I get one payment that covers
> > two invoices, I pay the first and make the amount just the total of
> > the invoice.  I do the same for the second invoice.  I use the memo
> > field to explain the situation.  Both payments reflect the same
> > payment number (check #) and other payment details.  This way, the
> > full amount of the payment is recorded, with no phantom overage, and
> > both invoices are properly paid.
> > 
> > Example:
> > 
> > Invoice 1 = $15.00
> > Invoice 2 = $23.00
> > Payment A = $38.00
> > 
> > Pay Invoice 1 = Check A, Amount $15.00, Memo = "Total Amount $38.00,
> > for invoices 1 & 2" Pay Invoice 2 = Check A, Amount $23.00, Memo =
> > "Total Amount $38.00, for invoices 1 & 2"
> > 
> > Dave Gillam
> > dave at davegillam.org
> > 
> > > On May 6, 2016, at 3:39 AM, Katie Eldridge
> > > <eldridgetideswell-katie at yahoo.co.uk> wrote:
> > > 
> > > I think this is a bug - I can replicate the error.  I'm using 2.6.9
> > > on Linux Mint 17.3. Katie
> > > 
> > > On 06/05/16 07:58, __ wrote:
> > >> still have this problem ... maybe there is new insight in the
> > >> community about how to tackle this?
> > >> 
> > >> I receive 1 payment to cover 2 due invoices. They belong to 2
> > >> different jobs of one customer.
> > >> 
> > >> Now when I make job reports for each of these jobs the total
> > >> payment amount is being listed on each report (which results into
> > >> a big credit Total for each job because the amount due to job A is
> > >> being calculated in the reports for job B and vice versa). So
> > >> these reports are plain wrong.
> > >> 
> > >> After I did "assign payment" on the Journal entry for this payment
> > >> 2 splits where created by GC, so in generally it seems to be
> > >> 'aware' of distributing the funds to 2 different invoices.
> > >> 
> > >> bug or did I make it wrong?
> > >> 


More information about the gnucash-user mailing list