How to Process Payment after import of bank transactions

Mon May 9 07:52:19 EDT 2016

Thanks to Keith for his suggestion / work around for using a clearing 
account.
This means the original import data is retained and ensures no deletions are 
required, which is open to errors.
However this is still not ideal and I would like to submit a development 
request if possible, assuming it is not possible to post directly from the 
imported transaction.

Many thanks,
John

-----Original Message----- 
From: gnucash-user-request at gnucash.org
Sent: Thursday, May 5, 2016 5:00 PM
To: gnucash-user at gnucash.org
Subject: gnucash-user Digest, Vol 158, Issue 14

Send gnucash-user mailing list submissions to
gnucash-user at gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-request at gnucash.org

You can reach the person managing the list at
gnucash-user-owner at gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."

Today's Topics:

   1. How to Process Payment after import of bank transactions (John)
   2. Re: How to Process Payment after import of bank transactions
      (kjbean+keith)
   3. Re: Customer report (Wendell)
   4. Re: Projected Balances? (Phil Longstaff)

----------------------------------------------------------------------

Message: 1
Date: Thu, 5 May 2016 11:17:53 +0100
From: John <hoppejrjr at gmail.com>
To: <gnucash-user at gnucash.org>
Subject: How to Process Payment after import of bank transactions
Message-ID: <3679E826ECE748CEA9D6CD7D2FF70BF1 at johnR>
Content-Type: text/plain; charset="iso-8859-1"

I import bank transactions using the standard QIF file and under the 
Transfer column the entries require to be allocated to accounts.
For a lot of entries I then want to allocate various payments and receipts 
to Vendors and Customers (matching to invoices so the Ageing reports work),
but the only way I can see how to do this is manually enter the bank 
transaction again via Business> Customer / Vendor>Process Payment and delete 
the imported entry!
There must be an easier way!
Nb. allocating just to Accounts Receivable or Payable is insufficient as no 
matching to a specific customer / vendor invoice takes place.
Can you please help.

------------------------------

Message: 2
Date: Thu, 05 May 2016 12:05:54 +0100
From: kjbean+keith <keith at kjbean.plus.com>
To: <gnucash-user at gnucash.org>
Subject: Re: How to Process Payment after import of bank transactions
Message-ID: <a93ebd4dfb6f1c4851638b042f0feac9 at imap.plus.net>
Content-Type: text/plain; charset=UTF-8; format=flowed

I created a current asset called Cash and Cheque Clearing Account.
All receipts are posted to this account when imported. The clearing
account can then be used as the source of funds when allocating the
money to invoices.

Regards
Keith

  On 05.05.2016 11:17, John wrote:
> I import bank transactions using the standard QIF file and under the
> Transfer column the entries require to be allocated to accounts.
> For a lot of entries I then want to allocate various payments and
> receipts to Vendors and Customers (matching to invoices so the Ageing
> reports work),
> but the only way I can see how to do this is manually enter the bank
> transaction again via Business> Customer / Vendor>Process Payment and
> delete the imported entry!
> There must be an easier way!
> Nb. allocating just to Accounts Receivable or Payable is insufficient
> as no matching to a specific customer / vendor invoice takes place.
> Can you please help.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

------------------------------

Message: 3
Date: Thu, 5 May 2016 06:18:02 -0600
From: Wendell <wkrause at ncodesys.com>
To: Lewis Balentine <lewis at keywild.com>
Cc: gnucash-user at gnucash.org
Subject: Re: Customer report
Message-ID: <572B39FA.6000102 at ncodesys.com>
Content-Type: text/plain; charset=windows-1252; format=flowed

Hello Lewis,

Thank you.
I use Ubuntu 14.4 and the Open Office suite including all updates. I
have a dual boot with Winders 8 which I haven't booted to in a couple of
years.

Wendell

On 05/04/2016 08:53 PM, Lewis Balentine wrote:
> OK Wendell ...
> A little information, then:
> What Operating System are you using?
> What Office Suite are you using?
> Fair warning ... I not set hands on an Apple MAC in more than two
> decades ...
>
> Lewis
>
>
> On 05/04/2016 11:25 AM, Wendell wrote:
>> Hello all,
>> I find it odd that I cannot generate a customer or vendor list.
>> The customer ID has separators in it to differentiate the town they
>> live in. I would like to be able to separate specific towns to
>> receive emails pertaining to their location.
>> That and the ability to print updated customer lists.
>> Has anyone found a solution to this? If so, is there a tutorial for
>> dummies that I can go to?
>>
>> Thanks in advance,
>> Wendell
>
>
>

------------------------------

Message: 4
Date: Thu, 5 May 2016 09:19:00 -0400
From: Phil Longstaff <phil.longstaff at gmail.com>
To: Gnucash user list <gnucash-user at gnucash.org>
Subject: Re: Projected Balances?
Message-ID:
<CAJcsxFHOxAzovoBUAkiyQKRvnpMW=CrqHtFQArVcODZWFmvu6w at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

On Wed, May 4, 2016 at 11:13 PM, Lewis Balentine <lewis at keywild.com> wrote:

> I was just looking at the DB tables. There is one "schedxactions" but
> there is no data in it for the transaction itself. There is one field
> labelled "template_act_guid" (32 character text). I am going to make a 
> wild
> guess that it is using a previous transaction as its template ... thus
> editing the 'template' would lead to other problems.
>

No, I think that's the template transaction that you can edit using the
Sched Transaction editor. When you apply a scheduled transaction, gnucash
uses that transaction to create the new instance.

------------------------------

Subject: Digest Footer

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user

------------------------------

End of gnucash-user Digest, Vol 158, Issue 14
********************************************* 