[GNC] How to set a customer "opening balance" for the Customer Report

[Adrien Monteleone]

Derek,

I could be mistaken, but I think the OP was referencing that they were moving *to* GnuCash from another system where they were already tracking the historical invoices.

GnuCash doesn’t have an official way to enter info for existing business transactions like it does simple opening balances for other accounts.

Regards,
Adrien

> On Oct 20, 2019 w43d293, at 6:21 AM, Derek Atkins <derek at ihtfp.com> wrote:
> 
> James,
> 
> James Thorpe <James at fusionsystems.co.za> writes:
> 
>> I didn't want to create invoices at all because
>> a) I didn't want to duplicate documents that existed in a different
>> financial period
>> b) I didn't want to create entries in the Income:Sales table because
>> these entries show up in the Trial Balance report even if they're not
>> in the current financial period.
> 
> How are you creating the new data file?  This actually begs the question
> of *WHY* you are creating a new data file, because GnuCash certainly
> does not require it.  Moreover, as you see, the business features don't
> really work well across split files.
> 
> However, IMHO, if you are creating a new data file then duplicating
> outstanding invoices in the new file would be perfectly appropriate.
> 
>> So what I was after was a way to create opening balance entries in
>> Accounts Receivable that also tied to a particular customer so they'd
>> be picked up in the various Customer Reports.
>> 
>> It seems this is not possible so I've settled for creating the
>> invoices as duplicates but "fixing" b) by also creating journal
>> entries in "Opening Balances" that cancel the entries in the
>> Income:Sales
> 
> As you surmised, this is not possible.  You will need to create an
> invoice to give your customer an opening balance.
> 
>> Provided I do that before the begining of my financial period start,
>> all reports look correct.
>> 
>> Thanks
>> James
> 
> -derek
> -- 
>       Derek Atkins                 617-623-3745
>       derek at ihtfp.com             www.ihtfp.com
>       Computer and Internet Security Consultant
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>