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

2019-10-21 Thread Derek Atkins
Adrien Monteleone writes: > How does one enter opening balances, *per customer* or *per vendor*? You don't. You have to enter all outstanding invoices (or bills). > So far that we’ve figured out, the only method is to enter a payment > assigned to Equity:Opening Balances. > > While this does a

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

2019-10-20 Thread Adrien Monteleone
How does one enter opening balances, *per customer* or *per vendor*? So far that we’ve figured out, the only method is to enter a payment assigned to Equity:Opening Balances. While this does accomplish the intended result, it is neither obvious or easily discoverable when first moving to GnuCas

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

2019-10-20 Thread 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 bala

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

2019-10-20 Thread Derek Atkins
Stan Brown writes: > On 2019-10-16 12:10, Adrien Monteleone wrote: >> Also, the Opening Balance entry *is* editable, even in 2.6.x. I’ve >> done it myself. It is just a regular transaction. > > I believe you, but I must say that that was very far from obvious to > this new user. I couldn't unders

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

2019-10-20 Thread Derek Atkins
James, James Thorpe 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 i

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

2019-10-16 Thread Stan Brown
On 2019-10-16 14:54, Adrien Monteleone wrote: > I can see it being offered for ease of use, but I agree, it should be either > editable from that dialog or maybe at least a tool-tip offered explaining to > edit it in one of the respective registers. > > Certainly, this is a usability bug. >

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

2019-10-16 Thread Adrien Monteleone
I can see it being offered for ease of use, but I agree, it should be either editable from that dialog or maybe at least a tool-tip offered explaining to edit it in one of the respective registers. Certainly, this is a usability bug. Regards, Adrien > On Oct 16, 2019 w42d289, at 1:27 PM, Stan

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

2019-10-16 Thread Stan Brown
On 2019-10-16 12:10, Adrien Monteleone wrote: > Also, the Opening Balance entry *is* editable, even in 2.6.x. I’ve done it > myself. It is just a regular transaction. I believe you, but I must say that that was very far from obvious to this new user. I couldn't understand why the Account dialog d

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

2019-10-16 Thread Adrien Monteleone
Also, the Opening Balance entry *is* editable, even in 2.6.x. I’ve done it myself. It is just a regular transaction. Regards, Adrien > On Oct 16, 2019 w42d289, at 9:42 AM, Stan Brown > wrote: > > It sounds like you have just one Accounts Receivable account, and you > put all customers' invoic

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

2019-10-16 Thread Adrien Monteleone
That admonition is true for the special AR/AP accounts used by the Business Features. Technically you *can* make manual entries there, but the various Business functions won’t be cognizant of them and if you aren’t careful you might forget you made them manually and then wonder later why report

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

2019-10-16 Thread Adrien Monteleone
That would likely work, but then you can’t use the business features. Everything has to be manual. The ‘one Accounts Receivable account’ is what the Business Features uses. And you can certainly easily report by customer using it. There are reports specifically built to work that way. Creating

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

2019-10-16 Thread Christopher Lam
On Wed, 16 Oct 2019 at 14:45, Stan Brown wrote: > However, I believe it's possible to accomplish the same thing by > creating a transaction of this form, dated the day before the beginning > of your first GC accounting period: > > Debit: AR:Customer 1 - Balance forward x.xx > Debit: AR:Customer 2

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

2019-10-16 Thread Stan Brown
It sounds like you have just one Accounts Receivable account, and you put all customers' invoices in that one account. I hope I'm misinterpreting you, because I think that would make it a lot harder down the road to run reports by customer. I'll assume you have one account for each customer, all un

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

2019-10-16 Thread James Thorpe
-- Message: 1 Date: Mon, 14 Oct 2019 20:49:53 +0200 From: James Thorpe To: GnuCash users group Subject: [GNC] How to set a customer "opening balance" for the Customer Report Message-ID:<02aeab3e-e0aa-8b70-7625-110c46862...@fusionsystems.co.za> Content-Type: text/plain; cha

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

2019-10-14 Thread Adrien Monteleone
Delete the opening balance transaction to get you back to zero. Then two options: 1. Create a single invoice with the balance forward and post it as of the original ‘opening balance’ date. 2. If the balance forward is from multiple invoices, import them into GnuCash, either with their real dat

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

2019-10-14 Thread James Thorpe
Hi All My financial year started on 1st March 2019. My customer at that stage, owed 67,765.23. I tried to seed this amount in my Equity:Opening Balances account with the corresponding account being Assets:Accounts Receivable. This seemed like a sensible way of opening the accounts. However