Re: [GNC] Getting Report Error

2020-04-10 Thread Tom Balaban
xperimental versions of the aging reports, but this was deemed a mess to handle at the moment. So the workflow for running owner reports is not as simple, but doable in the interim. Regards, Adrien On Apr 10, 2020 w15d101, at 8:22 AM, Tom Balaban wrote: Hi Adrien, 1st, many thanks for you

Re: [GNC] Getting Report Error

2020-04-10 Thread Tom Balaban
ee if it works. (I think it first appeared in v3.8) Regards, Adrien On Apr 8, 2020 w15d99, at 3:39 PM, Tom Balaban wrote: Hi All, It's been a while since I've needed any help but that ship has sailed. Today I posted a new invoice to a customer. I then tried to run a customer report and

[GNC] Getting Report Error

2020-04-09 Thread Tom Balaban
account. I can run the report on other customers just fine. I would appreciate any suggestions on how fix this. Many thanks in advance. Best wishes and hoping all of you are staying healthy. Tom Balaban ___ gnucash-user mailing list gnucash-user

Re: [GNC] Equity Calculation on the Balance Sheet

2019-04-16 Thread Tom Balaban
her liability type. The AR and AP types are special and are only to be used by the special Business Feature accounts. Regards, Adrien On Apr 16, 2019, at 10:41 AM, Tom Balaban wrote: Hi Adrien, Thanks for that explanation. On the issue of different amounts in the BS and the aged payables

Re: [GNC] Equity Calculation on the Balance Sheet

2019-04-16 Thread Tom Balaban
sed an actual Equity account here. It would show "Equity:Retained Earnings" as "-$38.61". Regards, Adrien On Apr 15, 2019, at 9:20 PM, Tom Balaban wrote: For reasons that I haven't Yet figured out, AR and AP balances are often incorrect on my Balance Sheet but are corre

[GNC] Equity Calculation on the Balance Sheet

2019-04-15 Thread Tom Balaban
For reasons that I haven't Yet figured out, AR and AP balances are often incorrect on my Balance Sheet but are correct on the Payables and Receivable Aging reports. This forces me to recast the Balance Sheet in a spreadsheet using the correct AP & AR balances. The math is basic but our

Re: [GNC] HELP! No lock!?

2019-03-13 Thread Tom Balaban
Simple fix. Close GNUCash. Use File Explorer to navigate to your GC data folder. Near the bottom you'll see a file with type LCK. Delete it. Open GC and enjoy. -- Original Message -- From: "Jack Slater" To: gnucash-user@gnucash.org Sent: 3/13/2019 2:09:12 PM Subject: [GNC] HELP! No

[GNC] A/R, A/P and Balance Sheet Discrepancies

2019-03-05 Thread Tom Balaban
Hello, I am experiencing some strange behavior with my Aged A/R, Aged A/P and Balance Sheet. When I run the three reports using "Today" the amounts showing in the Balance Sheet completely agrees with what appears on the respective aging reports. When I change the date on all 3 to the "End

Re: [GNC] How To Handle Prepayments

2018-12-15 Thread Tom Balaban
Many thanks Adrien. I think your explanation works except for a minor detail, after the initial payment is exhausted all payments are after the fact. Each month I submit a report of participant count for the prior month. They will then send me a bill for the amount due. I don't think there

Re: [GNC] How To Handle Prepayments

2018-12-15 Thread Tom Balaban
Thanks Elvis. Because of the casual way the insurance company handles this highly specialized business, only had 5 transactions to post for the entire year. While report monthly I often don't get bills for 2 or 3 months. I ended up doing the Pre-Paid thing for the initial payment, then

Re: [GNC] How to Reclassify Invoice Amounts

2018-12-09 Thread Tom Balaban
Many thanks, Diane. I was able to accurately reconcile both PayPal and our checking account monthly using the old method as I would post each transaction from the respective statement. It worked until we started getting payments from a 3rd-party servicer. Then I end up with a overpayment or a

Re: [GNC] How to Reclassify Invoice Amounts

2018-12-09 Thread Tom Balaban
8, 2018, at 1:18 PM, Tom Balaban wrote: Many thanks, Adrien. You have confirmed what I was thinking I had to do. The remaining issue I'll have to deal with is PayPal. They automatically withhold their service fee so we never see the full payment. Their statement for reconciliation