Re: [GNC] withholding tax (Liz Dodd)

[Maf. King]

Hi Paul,

A possible way to deal with this is to process the full payment to your bank 
account, then go an manually split the witholding portion out of the 
transaction as it appears in the bank account.

so step 1. process payment for the full £100

step 2. Go to the bank account, edit the transaction.  Reduce the split into 
the bank account to £80 and allocate the £20 to the WHT account.

(step 3 - check your work to see if it all makes sense for tax-return time!)

regards,
Maf.



On Friday, 2 October 2020 05:18:43 BST Paul W via gnucash-user wrote:
>  Stan,
> 
> I see what you are saying. Practically I think I need to process the invoice
> payment twice, first part payment (80) to Accounts Receivable then another
> payment (20) to Assets: WHT. But I don't seem to have this ability in
> gnucash because when I process an invoice payment in the 'post to' box only
> has Assets: Accounts Receivable as an option in the pull down menu. Help!
> 
> Paul
> 
> On 2020-10-01 19:14, Paul W via gnucash-user wrote:
> > Foreign Government A keeps this money and My Government B will credit this
> > amount against my corporation tax liability.
> > 
> > My invoice is for the full amount, £100.
> > 
> > Usually (without WHT) when the invoice is paid the full amount is
> > sent to my Accounts Receivable. In this case I think the way to do it
> > is for gnucash to send £100 to Accounts Receivable then £80 will go
> > from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
> > achieve this in gnucash?
> 
> Just to be clear, the answer to any question like this is always, "Think
> of GnuCash as a pen-and-ink ledger. First determine what entries you
> need to make, to cover your own accounting and tax needs. Once you know
> that, you can make those entries in GnuCash."
> 
> > Do you agree this is the way to do it?
> 
> I don't think so. Since you will collect 80 pounds not 100, the amount
> in receivables should, I think, be 80 pounds not 100. The 20 pounds is
> an asset, but it is a prepaid tax expense and not a receivable.
> 
> Debit: Assets: Receivable from {customer} 80
> Debit: Assets: Tax prepaid to {Foreign Government} 20
> Credit: Income: Sales 100
> 
> Then at the end of the year you make an adjusting entry:
> Debit: Liabilities: Tax payable to {My Government) {total for the year}
> Credit: Assets: Tax prepaid to {Foreign Government} {same amount}
> 
> That lets you track the amounts invoice by invoice or by annual totals.
> For strictly accounting purposes, that is what I would do. However, your
> country may mandate doing it in a particular way, so you may want to get
> local advice on that point. There's no need to bring GnuCash into that
> discussion; just ask how debits and credits should be recorded.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Accidentally hid two columns - can't get them back

[Maf. King]

Hi,

does the thread started by John Mansifield about one week ago, subject
"[GNC] Register columns:  The balance column is no longer visible"
offer you any help?

regards,
Maf.



On Friday, 2 October 2020 04:36:20 BST Daffy Duck wrote:
> Hello,
> 
> I was resizing some columns on a liability account, and now I can't see
> them or get them back
> 
> Increase
> 
> and
> 
> R
> 
> columns.
> 
> What to do?
> 
> gnucash-4.1-1.fc32.x86_64
> ___
> gnucash-user mailing list
> gnucash-user@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.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] withholding tax

[Paul W via gnucash-user]

 
Thanks Maf, that does seem to work. Shame there's not an automatic way to do 
this as WHT isn't a tax from Mars!



On Friday, 2 October 2020, 15:09:37 GMT+8, Maf. King wrote:


Hi Paul,

A possible way to deal with this is to process the full payment to your bank
account, then go an manually split the witholding portion out of the
transaction as it appears in the bank account.

so step 1. process payment for the full £100

step 2. Go to the bank account, edit the transaction. Reduce the split into
the bank account to £80 and allocate the £20 to the WHT account.

(step 3 - check your work to see if it all makes sense for tax-return time!)

regards,
Maf.



On Friday, 2 October 2020 05:18:43 BST Paul W via gnucash-user wrote:
> Stan,
>
> I see what you are saying. Practically I think I need to process the invoice
> payment twice, first part payment (80) to Accounts Receivable then another
> payment (20) to Assets: WHT. But I don't seem to have this ability in
> gnucash because when I process an invoice payment in the 'post to' box only
> has Assets: Accounts Receivable as an option in the pull down menu. Help!
>
> Paul
>
> On 2020-10-01 19:14, Paul W via gnucash-user wrote:
> > Foreign Government A keeps this money and My Government B will credit this
> > amount against my corporation tax liability.
> >
> > My invoice is for the full amount, £100.
> >
> > Usually (without WHT) when the invoice is paid the full amount is
> > sent to my Accounts Receivable. In this case I think the way to do it
> > is for gnucash to send £100 to Accounts Receivable then £80 will go
> > from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
> > achieve this in gnucash?
>
> Just to be clear, the answer to any question like this is always, "Think
> of GnuCash as a pen-and-ink ledger. First determine what entries you
> need to make, to cover your own accounting and tax needs. Once you know
> that, you can make those entries in GnuCash."
>
> > Do you agree this is the way to do it?
>
> I don't think so. Since you will collect 80 pounds not 100, the amount
> in receivables should, I think, be 80 pounds not 100. The 20 pounds is
> an asset, but it is a prepaid tax expense and not a receivable.
>
> Debit: Assets: Receivable from {customer} 80
> Debit: Assets: Tax prepaid to {Foreign Government} 20
> Credit: Income: Sales 100
>
> Then at the end of the year you make an adjusting entry:
> Debit: Liabilities: Tax payable to {My Government) {total for the year}
> Credit: Assets: Tax prepaid to {Foreign Government} {same amount}
>
> That lets you track the amounts invoice by invoice or by annual totals.
> For strictly accounting purposes, that is what I would do. However, your
> country may mandate doing it in a particular way, so you may want to get
> local advice on that point. There's no need to bring GnuCash into that
> discussion; just ask how debits and credits should be recorded.



-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542





  
___
gnucash-user mailing list
gnucash-user@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.

[GNC] Stock Levels

[Duikerbos]

Morning

I am starting a small Broiler project and using GnuCash to track 
transactions


Is it possible to track stock levels, birds purchased less birds sold?


Frederick


___
gnucash-user mailing list
gnucash-user@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.

[GNC] Anyone have a current gnc-vcs-info.h they can post here?

[B Wooster]

The githib .zip archive fails to build for what I think is a known issue -
tarballs, cmake, make does not work for gnucash build.

Can someone reply to this message with a currently valid gnc-vcs-info.h? I
hacked itup, but it fails in the version-info2env step.

  Manually hacked up gnc-vcs-info.h like this, but it will fail later in
version-info2env step:
#define GNC_VCS_REV "4.20"
#define GNC_VCS_REV_DATE "11"
#define GNC_VCS_REV_YEAR "2020"
#define GNC_VCS_REV_Y_M "2020-10"

I got around it by using make -i, and it built gnucash, so somewhat OK for
now. Just experimenting right now.

clean make error:
...
Scanning dependencies of target gnc-vcs-info
make[2]: *** No rule to make target
'.../gnucash-maint/libgnucash/core-utils/gnc-vcs-info.h', needed by
'libgnucash/core-utils/CMakeFiles/gnc-vcs-info'.  Stop.
make[1]: *** [CMakeFiles/Makefile2:5180:
libgnucash/core-utils/CMakeFiles/gnc-vcs-info.dir/all] Error 2
make: *** [Makefile:163: all] Error 2


[not a member of devel group so hoping someone from gnucash-user can reply!
thanks!]

Debian system, gnucash-maint zip archive 2020-Oct-1:

make -i
...
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
  list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
  .../gnucash-maint/cmake/configure-manpage.cmake:14 (versioninfo2env)


[ 50%] Built target gnucash-cli-manpage
[ 50%] Generating gnucash.1
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
  list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
  .../gnucash-maint/cmake/configure-manpage.cmake:14 (versioninfo2env)


[ 50%] Built target gnucash-manpage
...
[ 68%] Built target gnucash-cli
make[2]: *** No rule to make target '.../gnucash-maint/gnucash/gnome/
gnucash.appdata.xml.in', needed by 'gnucash/gnome/gnucash.appdata.xml'.
Stop.
[ 68%] Built target gnucash-appdata
[ 68%] Generating gnucash.desktop
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
  list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
  .../gnucash-maint/cmake/configure-gnucash-desktop.cmake:15
(versioninfo2env)
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Anyone have a current gnc-vcs-info.h they can post here?

[Derek Atkins]

Don't use github tarballs.
We would turn them off if they would let us!
Either use an official release tarball or fit clone.

-derek
Sent using my mobile device. Please excuse any typos.
On October 2, 2020 7:27:09 AM B Wooster  wrote:


The githib .zip archive fails to build for what I think is a known issue -
tarballs, cmake, make does not work for gnucash build.

Can someone reply to this message with a currently valid gnc-vcs-info.h? I
hacked itup, but it fails in the version-info2env step.

 Manually hacked up gnc-vcs-info.h like this, but it will fail later in
version-info2env step:
#define GNC_VCS_REV "4.20"
#define GNC_VCS_REV_DATE "11"
#define GNC_VCS_REV_YEAR "2020"
#define GNC_VCS_REV_Y_M "2020-10"

I got around it by using make -i, and it built gnucash, so somewhat OK for
now. Just experimenting right now.

clean make error:
...
Scanning dependencies of target gnc-vcs-info
make[2]: *** No rule to make target
'.../gnucash-maint/libgnucash/core-utils/gnc-vcs-info.h', needed by
'libgnucash/core-utils/CMakeFiles/gnc-vcs-info'.  Stop.
make[1]: *** [CMakeFiles/Makefile2:5180:
libgnucash/core-utils/CMakeFiles/gnc-vcs-info.dir/all] Error 2
make: *** [Makefile:163: all] Error 2


[not a member of devel group so hoping someone from gnucash-user can reply!
thanks!]

Debian system, gnucash-maint zip archive 2020-Oct-1:

make -i
...
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
 list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
 .../gnucash-maint/cmake/configure-manpage.cmake:14 (versioninfo2env)


[ 50%] Built target gnucash-cli-manpage
[ 50%] Generating gnucash.1
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
 list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
 .../gnucash-maint/cmake/configure-manpage.cmake:14 (versioninfo2env)


[ 50%] Built target gnucash-manpage
...
[ 68%] Built target gnucash-cli
make[2]: *** No rule to make target '.../gnucash-maint/gnucash/gnome/
gnucash.appdata.xml.in', needed by 'gnucash/gnome/gnucash.appdata.xml'.
Stop.
[ 68%] Built target gnucash-appdata
[ 68%] Generating gnucash.desktop
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
 list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
 .../gnucash-maint/cmake/configure-gnucash-desktop.cmake:15
(versioninfo2env)
___
gnucash-user mailing list
gnucash-user@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.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Stock Levels

[Derek Atkins]

Gnucash does not have inventory support.

If you only need to track a few items you can probably hack something 
together using a Stock account, but it is not a true inventory.


-derek
Sent using my mobile device. Please excuse any typos.
On October 2, 2020 5:17:09 AM Duikerbos  wrote:


Morning

I am starting a small Broiler project and using GnuCash to track
transactions

Is it possible to track stock levels, birds purchased less birds sold?


Frederick


___
gnucash-user mailing list
gnucash-user@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.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Accidentally hid two columns - can't get them back

[Adrien Monteleone]

I just did this intentionally as a test.

I had no problems re-expanding the columns.

But the key to remember is *drag right*. You only adjust a column using 
the right-hand header divider.


If you collapsed both the Debit (increase) column and the 'R' column 
(reconciliation status) then you'll see a thicker line in the header on 
each line. (Turn on View > Double Line to see the second line in the header)


Carefully hover to the right of that thick line till you get the 
left-right-arrow cursor and then click and drag right to expand.


In my test, this revealed the 'R' column first.

I then repeated this for the remaining thick divider and revealed the 
Debit/increase column.


Tip* - double click a header to auto-size that column to the contents.

If you end up with a horizontal scroll situation, click and drag the 
right-hand header divider of the Description column *far* to the left 
and let it go. It will auto-adjust and snap back to fill the difference.


Regards,
Adrien

On 10/1/20 11:43 PM, David Carlson wrote:

I was hoping another user who has experience with either release 4.1.or 4.2
could comment on the current state of register column recovery

On Thu, Oct 1, 2020 at 11:22 PM Daffy Duck  wrote:


So you have to keep using general journal view to deal with that account
till this is fixed, because I accidentally shrunk a column?

:(

On Thu, 2020-10-01 at 23:16 -0500, David Carlson wrote:

A temporary work-around would be to open the General Journal then search
for Account Matches Any Account then select that account in the drop down
list.  I am not sure about a better solution that is reliable for all
displays

On Thu, Oct 1, 2020 at 10:58 PM Daffy Duck 
wrote:

I can sort of get to it through tabbing, but not really.  CAn you please
tell me what to do?

On Thu, 2020-10-01 at 22:56 -0500, David Carlson wrote:

This question or some variation comes up often enough that it might be a
good idea to have a button somewhere to reset that register view to the
default column widths.  What do others think?

On Thu, Oct 1, 2020 at 10:38 PM Daffy Duck 
wrote:

Hello,

I was resizing some columns on a liability account, and now I can't see
them or get them back

Increase

and

R

columns.

What to do?

gnucash-4.1-1.fc32.x86_64


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Accidentally hid two columns - can't get them back

[Adrien Monteleone]

I would agree. The Business tabs have this as an option in the Window menu.

Even if the register tabs don't get the option to set custom defaults as 
originally planned, implementing the 'reset' option for them now would 
be very helpful.


Regards,
Adrien

On 10/1/20 10:56 PM, David Carlson wrote:

This question or some variation comes up often enough that it might be a
good idea to have a button somewhere to reset that register view to the
default column widths.  What do others think?


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Accidentally hid two columns - can't get them back

[Adrien Monteleone]

Follow up, you can also double-click the Description header rather than 
drag and release for the same effect.


Regards,
Adrien

On 10/2/20 8:25 AM, Adrien Monteleone wrote:

I just did this intentionally as a test.

I had no problems re-expanding the columns.

But the key to remember is *drag right*. You only adjust a column using 
the right-hand header divider.


If you collapsed both the Debit (increase) column and the 'R' column 
(reconciliation status) then you'll see a thicker line in the header on 
each line. (Turn on View > Double Line to see the second line in the 
header)


Carefully hover to the right of that thick line till you get the 
left-right-arrow cursor and then click and drag right to expand.


In my test, this revealed the 'R' column first.

I then repeated this for the remaining thick divider and revealed the 
Debit/increase column.


Tip* - double click a header to auto-size that column to the contents.

If you end up with a horizontal scroll situation, click and drag the 
right-hand header divider of the Description column *far* to the left 
and let it go. It will auto-adjust and snap back to fill the difference.


Regards,
Adrien


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Accidentally hid two columns - can't get them back

[Stan Brown]

On 2020-10-01 20:56, David Carlson wrote:
> This question or some variation comes up often enough that it might be a
> good idea to have a button somewhere to reset that register view to the
> default column widths.  What do others think?
> 
> On Thu, Oct 1, 2020 at 10:38 PM Daffy Duck  wrote:
>> I was resizing some columns on a liability account, and now I can't see
>> them or get them back

Sounds like a good idea to me!

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
https://OakRoadSystems.com
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Accidentally hid two columns - can't get them back

[Daffy Duck]

That did it, thanks!

On Fri, 2020-10-02 at 08:25 -0500, Adrien Monteleone wrote:
> I just did this intentionally as a test.
> I had no problems re-expanding the columns.
> But the key to remember is *drag right*. You only adjust a column
> using the right-hand header divider.
> If you collapsed both the Debit (increase) column and the 'R' column
> (reconciliation status) then you'll see a thicker line in the header
> on each line. (Turn on View > Double Line to see the second line in
> the header)
> Carefully hover to the right of that thick line till you get the
> left-right-arrow cursor and then click and drag right to expand.
> In my test, this revealed the 'R' column first.
> I then repeated this for the remaining thick divider and revealed the
> Debit/increase column.
> Tip* - double click a header to auto-size that column to the
> contents.
> If you end up with a horizontal scroll situation, click and drag the
> right-hand header divider of the Description column *far* to the left
> and let it go. It will auto-adjust and snap back to fill the
> difference.
> Regards,Adrien
> On 10/1/20 11:43 PM, David Carlson wrote:
> > I was hoping another user who has experience with either release
> > 4.1.or 4.2could comment on the current state of register column
> > recovery
> > On Thu, Oct 1, 2020 at 11:22 PM Daffy Duck  > > wrote:
> > > So you have to keep using general journal view to deal with that
> > > accounttill this is fixed, because I accidentally shrunk a
> > > column?
> > > :(
> > > On Thu, 2020-10-01 at 23:16 -0500, David Carlson wrote:
> > > A temporary work-around would be to open the General Journal then
> > > searchfor Account Matches Any Account then select that account in
> > > the drop downlist.  I am not sure about a better solution that is
> > > reliable for alldisplays
> > > On Thu, Oct 1, 2020 at 10:58 PM Daffy Duck <
> > > suffsuccot...@gmail.com>wrote:
> > > I can sort of get to it through tabbing, but not really.  CAn you
> > > pleasetell me what to do?
> > > On Thu, 2020-10-01 at 22:56 -0500, David Carlson wrote:
> > > This question or some variation comes up often enough that it
> > > might be agood idea to have a button somewhere to reset that
> > > register view to thedefault column widths.  What do others think?
> > > On Thu, Oct 1, 2020 at 10:38 PM Daffy Duck <
> > > suffsuccot...@gmail.com>wrote:
> > > Hello,
> > > I was resizing some columns on a liability account, and now I
> > > can't seethem or get them back
> > > Increase
> > > and
> > > R
> > > columns.
> > > What to do?
> > > gnucash-4.1-1.fc32.x86_64
> 
> ___gnucash-user mailing 
> listgnucash-u...@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.
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] withholding tax (Liz Dodd)

[Michael or Penny Novack]

On 10/2/2020 12:18 AM, Paul W via gnucash-user wrote:

  Stan,

I see what you are saying. Practically I think I need to process the invoice 
payment twice, first part payment (80) to Accounts Receivable then another 
payment (20) to Assets: WHT. But I don't seem to have this ability in gnucash 
because when I process an invoice payment in the 'post to' box only has Assets: 
Accounts Receivable as an option in the pull down menu. Help!

Paul


I don't use the business features so don't know if this is your problem.

BUT -- it is always harder to enter a split transaction when starting 
from the "wrong" place. By wrong, in this case, I mean in the case of a 
one sided split, starting in an account other than the non-split side.


When you are processing an invoice payment (when entering that) CAN you 
split? << others using the business features need to jump in here and 
say one way or the other -- for example, if you received one check from 
a customer that was intended to cover two invoices, could you enter 
that, and did that involve "split"? >>


If the answer is yes, then what I suggest is that you learn how to enter 
a split transaction when you are starting from the "wrong place". Those 
of us who are keeping books for non-profits that sell "stuff" 
(fundraising) probably know how to do that since in entering the 
transaction involves "cash", "sales", "cost of goods sold", and "goods 
inventory" << split on BOTH sides  so there can be no "right" place to 
start >>


Michael D Novack

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] withholding tax

[Michael or Penny Novack]

On 10/2/2020 4:17 AM, Paul W via gnucash-user wrote:
  
Thanks Maf, that does seem to work. Shame there's not an automatic way to do this as WHT isn't a tax from Mars!



Doing in two transactions simply avoids the complexity of entering a 
split from the "wrong" account. It's just a little more work entering a 
split when not starting from where easiest.


THAT is what my question about "can you do a split" at this point using 
the business features. If so, that IS the "automatic way"


Michael D Novack


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] withholding tax (Liz Dodd)

[Christopher Lam]

While experimenting this problem, I found it exposes a subtle
behaviour/bug... I was hoping to do the following manual assignment: create
a transaction with 3 splits -
 - asset:bank +80
 - a/receivable -100
 - asset:WHT +20
 then right-click the transaction, assign $80 as payment for the invoice.
But this will assign the 100 to the invoice then 20 as overpayment to the
same customer. This is not what we want.

Therefore your *only *currently available steps is (IMHO):  process payment
as usual, for $80 only. This creates a regular transaction:
 - asset:bank +100
 - a/receivable -100 (to clear the invoice)

Then you will do *two* further modifications:
1. modify to include split to asset:WHT
 - asset:bank +80
 - a/receivable -100 (linked to invoice)
 - asset:WHT +20
2. import OFX/QIF from the bank, and match the OFX transaction to your
asset:bank split. Thus:
 - asset:bank +80 (linked to OFX online_id)
 - a/receivable -100 (linked to invoice)
 - asset:WHT +20

On Fri, 2 Oct 2020 at 04:25, Paul W via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  Stan,
>
> I see what you are saying. Practically I think I need to process the
> invoice payment twice, first part payment (80) to Accounts Receivable then
> another payment (20) to Assets: WHT. But I don't seem to have this ability
> in gnucash because when I process an invoice payment in the 'post to' box
> only has Assets: Accounts Receivable as an option in the pull down menu.
> Help!
>
> Paul
>
>
> On 2020-10-01 19:14, Paul W via gnucash-user wrote:
> > Foreign Government A keeps this money and My Government B will credit
> this amount against my corporation tax liability.
> >
> > My invoice is for the full amount, £100.
> >
> > Usually (without WHT) when the invoice is paid the full amount is
> > sent to my Accounts Receivable. In this case I think the way to do it
> > is for gnucash to send £100 to Accounts Receivable then £80 will go
> > from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
> > achieve this in gnucash?
>
> Just to be clear, the answer to any question like this is always, "Think
> of GnuCash as a pen-and-ink ledger. First determine what entries you
> need to make, to cover your own accounting and tax needs. Once you know
> that, you can make those entries in GnuCash."
>
>
> > Do you agree this is the way to do it?
>
>
> I don't think so. Since you will collect 80 pounds not 100, the amount
> in receivables should, I think, be 80 pounds not 100. The 20 pounds is
> an asset, but it is a prepaid tax expense and not a receivable.
>
> Debit: Assets: Receivable from {customer} 80
> Debit: Assets: Tax prepaid to {Foreign Government} 20
> Credit: Income: Sales 100
>
> Then at the end of the year you make an adjusting entry:
> Debit: Liabilities: Tax payable to {My Government) {total for the year}
> Credit: Assets: Tax prepaid to {Foreign Government} {same amount}
>
> That lets you track the amounts invoice by invoice or by annual totals.
> For strictly accounting purposes, that is what I would do. However, your
> country may mandate doing it in a particular way, so you may want to get
> local advice on that point. There's no need to bring GnuCash into that
> discussion; just ask how debits and credits should be recorded.
>
> --
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.com
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] withholding tax (Liz Dodd)

[Christopher Lam]

Typo in middle section:

Therefore your *only *currently available steps is (IMHO):  process payment
as usual, for *$100 *only. This creates a regular transaction:
 - asset:bank +100
 - a/receivable -100 (to clear the invoice)

On Fri, 2 Oct 2020 at 15:26, Christopher Lam 
wrote:

> While experimenting this problem, I found it exposes a subtle
> behaviour/bug... I was hoping to do the following manual assignment: create
> a transaction with 3 splits -
>  - asset:bank +80
>  - a/receivable -100
>  - asset:WHT +20
>  then right-click the transaction, assign $80 as payment for the invoice.
> But this will assign the 100 to the invoice then 20 as overpayment to the
> same customer. This is not what we want.
>
> Therefore your *only *currently available steps is (IMHO):  process
> payment as usual, for $80 only. This creates a regular transaction:
>  - asset:bank +100
>  - a/receivable -100 (to clear the invoice)
>
> Then you will do *two* further modifications:
> 1. modify to include split to asset:WHT
>  - asset:bank +80
>  - a/receivable -100 (linked to invoice)
>  - asset:WHT +20
> 2. import OFX/QIF from the bank, and match the OFX transaction to your
> asset:bank split. Thus:
>  - asset:bank +80 (linked to OFX online_id)
>  - a/receivable -100 (linked to invoice)
>  - asset:WHT +20
>
> On Fri, 2 Oct 2020 at 04:25, Paul W via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>>  Stan,
>>
>> I see what you are saying. Practically I think I need to process the
>> invoice payment twice, first part payment (80) to Accounts Receivable then
>> another payment (20) to Assets: WHT. But I don't seem to have this ability
>> in gnucash because when I process an invoice payment in the 'post to' box
>> only has Assets: Accounts Receivable as an option in the pull down menu.
>> Help!
>>
>> Paul
>>
>>
>> On 2020-10-01 19:14, Paul W via gnucash-user wrote:
>> > Foreign Government A keeps this money and My Government B will credit
>> this amount against my corporation tax liability.
>> >
>> > My invoice is for the full amount, £100.
>> >
>> > Usually (without WHT) when the invoice is paid the full amount is
>> > sent to my Accounts Receivable. In this case I think the way to do it
>> > is for gnucash to send £100 to Accounts Receivable then £80 will go
>> > from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
>> > achieve this in gnucash?
>>
>> Just to be clear, the answer to any question like this is always, "Think
>> of GnuCash as a pen-and-ink ledger. First determine what entries you
>> need to make, to cover your own accounting and tax needs. Once you know
>> that, you can make those entries in GnuCash."
>>
>>
>> > Do you agree this is the way to do it?
>>
>>
>> I don't think so. Since you will collect 80 pounds not 100, the amount
>> in receivables should, I think, be 80 pounds not 100. The 20 pounds is
>> an asset, but it is a prepaid tax expense and not a receivable.
>>
>> Debit: Assets: Receivable from {customer} 80
>> Debit: Assets: Tax prepaid to {Foreign Government} 20
>> Credit: Income: Sales 100
>>
>> Then at the end of the year you make an adjusting entry:
>> Debit: Liabilities: Tax payable to {My Government) {total for the year}
>> Credit: Assets: Tax prepaid to {Foreign Government} {same amount}
>>
>> That lets you track the amounts invoice by invoice or by annual totals.
>> For strictly accounting purposes, that is what I would do. However, your
>> country may mandate doing it in a particular way, so you may want to get
>> local advice on that point. There's no need to bring GnuCash into that
>> discussion; just ask how debits and credits should be recorded.
>>
>> --
>> Regards,
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.com
>> https://OakRoadSystems.com
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
>>
>
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] GnuCash 4.2 Released

[Jamestk]

flatpaks seem to be the way to go, thanks for the heads up.


GnuCash - User mailing list wrote
> Hi,
> I have Ubuntu 20.04 With Flatpak and Gnome Software installed in addition
> to the Ubuntu Software package manager. I started with GnuCash 4.1 and
> updated to 4.2 seamlessly with Flatpak. I only have one icon for
> GnuCash to launch as expected. This is the behavior I expected to get from
> Flatpak. I am not set to update automatically, and the update did not take
> place until I initiated it. I did not use the command line to update
> GnuCash and used Flatpak via Gnome Software. That’s the behavior in the
> latest Ubuntu with Gnome Software installed. I don’t have Linux
> Mint installed to test at the moment, So I can’t speak for the behavior in
> Linux Mint. I hope that helps the discussion at least from the perspective
> of Ubuntu.
> 
> Thanks,
> Life0riley 
> 
> Sent from Yahoo Mail for iPhone
> 
> 
> On Wednesday, September 30, 2020, 11:58 AM, Jamestk <

> davidjamestk@.co

> > wrote:
> 
> Frank, its Linux Mint 19.1 Cinnamon, please see Adrien reply below for
> solution. 
> 
> 
> Frank H. Ellenberger-3 wrote
>> Which OS/Distri, version?
>> 
>> Am 30.09.20 um 17:25 schrieb Jamestk:
>>> Here we go, dollar sign as opposed to 'G'
>>> 
>>> The updates I checked were from system, i.e the periodic updates
>>> triggered
>>> by shield symbol in sys tray, it must have come down as an update during
>>> this process.
>>> 
>>> 
>>>  
>>> 
>>> 
>>> 
>>> --
>>> Sent from:
>>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> ___
>>> gnucash-user mailing list
>>> 
> 
>> gnucash-user@
> 
>>> 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.
>>> 
>> ___
>> gnucash-user mailing list
> 
>> gnucash-user@
> 
>> 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.
> 
> 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list

> gnucash-user@

> 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.
> 
> 
> 
> ___
> gnucash-user mailing list

> gnucash-user@

> 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.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[Jamestk]

Is it worth reporting this as a bug?

I did try but got bogged down in endless wiki pages.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] withholding tax (Liz Dodd)

[Adrien Monteleone]

The normal process payment function only splits for the invoices/bills 
selected. So if you are paying one invoice, you get one payment split 
and one AR/AP split.


If you are paying multiple invoices, you'll still only have one payment 
split, but one AR/AP split for each invoice/bill.


If additional splits were part of the real-world transaction, you have 
to add them manually, ideally from the payment (source) account 
register. (not AR/AP)


For example, I keep a jar of loose change and don't count that as part 
of my 'cash in wallet'.


When I pay a bill in cash, I use the usual Process Payment for the exact 
amount.


Then I edit the transaction to change the cash split to be the actual 
whole dollar amount I tendered, then add a debit split to my coin jar 
for the loose change. I've had some issue in the past with tracking down 
some cash discrepancies, so I record the actual tender amount, and I add 
a cash debit split for any cash change received. Now I can trace the 
actual currency flow if needed. This has helped me resolve a few errors 
or lapses in memory if I don't get to enter transactions right away.


-
And I agree on the 'starting point' and always enter any transaction 
from the source account register. Life is much simpler that way.



Regards,
Adrien

On 10/2/20 10:10 AM, Michael or Penny Novack wrote:

On 10/2/2020 12:18 AM, Paul W via gnucash-user wrote:

  Stan,

I see what you are saying. Practically I think I need to process the 
invoice payment twice, first part payment (80) to Accounts Receivable 
then another payment (20) to Assets: WHT. But I don't seem to have 
this ability in gnucash because when I process an invoice payment in 
the 'post to' box only has Assets: Accounts Receivable as an option in 
the pull down menu. Help!


Paul


I don't use the business features so don't know if this is your problem.

BUT -- it is always harder to enter a split transaction when starting 
from the "wrong" place. By wrong, in this case, I mean in the case of a 
one sided split, starting in an account other than the non-split side.


When you are processing an invoice payment (when entering that) CAN you 
split? << others using the business features need to jump in here and 
say one way or the other -- for example, if you received one check from 
a customer that was intended to cover two invoices, could you enter 
that, and did that involve "split"? >>


If the answer is yes, then what I suggest is that you learn how to enter 
a split transaction when you are starting from the "wrong place". Those 
of us who are keeping books for non-profits that sell "stuff" 
(fundraising) probably know how to do that since in entering the 
transaction involves "cash", "sales", "cost of goods sold", and "goods 
inventory" << split on BOTH sides  so there can be no "right" place to 
start >>


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[Adrien Monteleone]

Up to you. I think the intended behavior is to run the iterative search 
from the search results, this way you can refine them. The second time 
you click Find the search function will be to "Refine Current Search" 
which you can of course change.


That works well if the first search was more generalized and you want to 
narrow it down.


If you got undesired results all together, then do a new search.

If the results window is empty (or I think < 3 results), a subsequent 
search from that result tab will reset the search function to 'new search'.


Otherwise for bug reporting:

1. Create account on bugs.gnucash.org

2. Search to see if the bug is already filed (requires creative 
alternative terminology searches)


3. If not found, file your bug.

Regards,
Adrien

On 10/2/20 10:33 AM, Jamestk wrote:

Is it worth reporting this as a bug?

I did try but got bogged down in endless wiki pages.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[Jamestk]

Thats sounds ideal Adrien but unsure how it works, let me describe what
happens.

>From the main accounts tree I clicked edit, find which brings up the
following window. From here I select 'value' as it works well finding
transactions, at this point these is no other option as greyed out.

 

Hitting enter it takes brings up the results, from this windows there
doesn't appear to be any other edit functions available?  


Adrien Monteleone-2 wrote
> Up to you. I think the intended behavior is to run the iterative search 
> from the search results, this way you can refine them. The second time 
> you click Find the search function will be to "Refine Current Search" 
> which you can of course change.
> 
> That works well if the first search was more generalized and you want to 
> narrow it down.
> 
> If you got undesired results all together, then do a new search.
> 
> If the results window is empty (or I think < 3 results), a subsequent 
> search from that result tab will reset the search function to 'new
> search'.
> 
> Otherwise for bug reporting:
> 
> 1. Create account on bugs.gnucash.org
> 
> 2. Search to see if the bug is already filed (requires creative 
> alternative terminology searches)
> 
> 3. If not found, file your bug.
> 
> Regards,
> Adrien
> 
> On 10/2/20 10:33 AM, Jamestk wrote:
>> Is it worth reporting this as a bug?
>> 
>> I did try but got bogged down in endless wiki pages.
> 
> ___
> gnucash-user mailing list

> gnucash-user@

> 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.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[David Carlson]

I am not at a good place to check the help, but I recall that it is vague.
If you click on the Add button on the left it should be possible to enter a
second criterion, etc. I would expect that to work once the first criterion
is completely entered,  I think this new GTK3 stuff sometimes greys out
buttons that still work.

On Fri, Oct 2, 2020 at 11:56 AM Jamestk  wrote:

> Thats sounds ideal Adrien but unsure how it works, let me describe what
> happens.
>
> From the main accounts tree I clicked edit, find which brings up the
> following window. From here I select 'value' as it works well finding
> transactions, at this point these is no other option as greyed out.
>
> 
>
> Hitting enter it takes brings up the results, from this windows there
> doesn't appear to be any other edit functions available?
>
>
> Adrien Monteleone-2 wrote
> > Up to you. I think the intended behavior is to run the iterative search
> > from the search results, this way you can refine them. The second time
> > you click Find the search function will be to "Refine Current Search"
> > which you can of course change.
> >
> > That works well if the first search was more generalized and you want to
> > narrow it down.
> >
> > If you got undesired results all together, then do a new search.
> >
> > If the results window is empty (or I think < 3 results), a subsequent
> > search from that result tab will reset the search function to 'new
> > search'.
> >
> > Otherwise for bug reporting:
> >
> > 1. Create account on bugs.gnucash.org
> >
> > 2. Search to see if the bug is already filed (requires creative
> > alternative terminology searches)
> >
> > 3. If not found, file your bug.
> >
> > Regards,
> > Adrien
> >
> > On 10/2/20 10:33 AM, Jamestk wrote:
> >> Is it worth reporting this as a bug?
> >>
> >> I did try but got bogged down in endless wiki pages.
> >
> > ___
> > gnucash-user mailing list
>
> > gnucash-user@
>
> > 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.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[Jamestk]

Tried that David although not sure what to put into second criteria, either
way it does the same as above.

I can't be the first person to spot this surely, since using GNC it's always
been the same so that must be nudging 7-8 years or more.

For good measure I tried all the options available from drop down list,
description, notes and so on can you try it when convenient - thanks



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Stock Levels

[doncram]

Hi Frederick & others -- It has often been said in this email forum that
GnuCash doesn't support inventory, but I think that's basically wrong.
What I mean is that while GnuCash has no separate inventory module as are
available in some versions of Quickbooks, say, one can use GnuCash + a
supporting spreadsheet (in Excel or freeware LibreOffice Calc which both
have some database features) perfectly well for accounting for a business
with inventory.  A few demonstrations/examples are needed to provide for
arriving potential users though.

A simple approach which might work especially if there are not too many
transactions could work as follows:

*When purchasing inventory, perhaps of a few different types*:
a) enter transaction into GnuCash as increasing one big Inventory account
and decreasing cash without any detail about numbers of units of what
types, just reference the invoice or sales receipt which you file into a
Vendor file.
b) in the spreadsheet create rows as needed for each the different types of
inventory (say Barnevelder chickens and Chantecler chickens) and in three
new columns for the purchases record the numbers and prices paid and total
dollars paid for each
Repeat as new transactions happen, adding 3 columns each time.
Keep one column carrying the sum of all purchases as an estimate of current
value of each type, with a sum at bottom reporting the total value of
inventory.

*At the end of a month or other accounting period*, do an inventory
inspection and record in a new set of 3 columns the number of each type
which you count, a price per unit (perhaps use the original or the last
purchase price, or a new estimate of your own based on what you see and
know), and a calculated current total dollars value.  Perhaps some units
will have been lost or some new chicks have been hatched and some prices
will have changed, so the sum of value of current inventory will be lower
or higher.  Then update your financial value in Quickbooks to reflect the
amount of that change:  increase or decrease "Inventory" value and
recognize a gain (say "Gain from Inventory growth") as income or a loss
(say "Loss from Inventory decline") as expense.

Also *whenever you sell any units*, add three columns for the numbers sold,
the price per unit, the dollars yielded.  In GnuCash enter an increase in
cash and recognize "Revenue from sale of chickens" or whatever.

In your business, you will also record expenses for operating costs, and
any revenues from sales of eggs say, and in the Income Statement for a
given period you will see whether you have made a profit or loss on the
period.  In this approach, with your counting and revaluing your inventory
to roughly a current market value each period, profit can be shown due to
gains in value even if there have not been any sales.  As suggested here,
the spreadsheet would tend to expand to the right.  But perhaps that is
fine, as after all there is no shortage of empty columns available in any
spreadsheet nowadays.

Note there are many possible different implementations.  One could have
GnuCash inventories for each type of chicken, so values for each type would
appear in your Balance Sheet, though at cost of requiring many more GnuCash
transaction entries.  One could use "inventory valuation" approaches other
than the current market value estimation approach suggested above,
variations that may be legally allowed in financial accounting (e.g. First
In First Out (FIFO), LIFO, Average Cost, Specific Identification), but are
probably not worth bothering with.  These variations might allow for some
gaming to advance or defer taxes due, or to manipulate reported earnings of
your firm sooner or later, but such gaming is generally not worthwhile.
Also a more database-oriented approach to organizing the information might
be possible, say with columns for each type of chicken and one row for each
transaction or re-valuation or new total value.  Perhaps that would allow
for some different types of reports using DCOUNT and DSUM type formulas.

But perhaps the above approach would work for you?  Maybe you could
explain a bit more about what you want to do?

In my opinion, Quickbooks' inventory feature is cumbersome, requiring one
to go through multiple screens to create a new inventory type, and
requiring application of just one type of valuation (I think requiring
every unit to be valued at same price per unit always, i.e. this is suited
only to situations where suppliers are unrealistically required to sell to
you at the same price forever).  It does not allow one to choose other
valuation approaches.  It probably fails to provide reports that you want
suited to your application.  It fails to support useful calculations that
are often wanted (such as for when inventory of each type should next be
purchased and what order quantity should be used, based on "Economic Order
Quantity" theory or similar).  I know of manufacturing firms which use
Quickbooks for accounting but absolutely woul

Re: [GNC] 8.1.1. Find Transaction

[David Carlson]

OK, in release 3.8 in Linux Lite 5.0 with whatever theme i have currently
selected for system graphics that search box has grey buttons with black
text, and they 'glow' when I mouse over them if they are active. The box
that is set to receive keyboard text is white with a black border until I
click on it then the border turns blue and the text curser appears therein.
If I click on the Add button when the criterion does not have a valid
selection I get an error message "You need to enter some search text."

Thus, I think the mechanics of criteria entry actually works better than
before.  I suspect, however, the interpretation of how to enter the key to
get the results that you really want is probably just as cryptic as it was
before.  I did not try iterative searches, but I suspect they behave as
described by others here, which is AFAIK the same as before.

On Fri, Oct 2, 2020 at 3:30 PM Jamestk  wrote:

> Tried that David although not sure what to put into second criteria, either
> way it does the same as above.
>
> I can't be the first person to spot this surely, since using GNC it's
> always
> been the same so that must be nudging 7-8 years or more.
>
> For good measure I tried all the options available from drop down list,
> description, notes and so on can you try it when convenient - thanks
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

[GNC] Customer Listing Report and Receivable Aging Report Error

[Bob Jenkins]

I recently updated from version 3.9 to 4.2. Version 4.2 seems to have an
error in the "total" column for some customers that have made prepayments
on both the Customer Listing Report and Receivable Aging Report. The amount
in the "total" column does not agree with the "total due" balance on that
customer's individual Customer Report. I did not observe this error with
version 3.9.

Is there any way to get a customer Listing Report that shows the "total
due" amount shown on the individual Customer Report?

Thanks
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Stock Levels

[David Carlson]

doncram, I think that you contradicted yourself when you said GnuCash
supports inventory control then described how difficult it is to emulate a
few of the most basic features of inventory control.

On Fri, Oct 2, 2020 at 4:21 PM doncram  wrote:

> Hi Frederick & others -- It has often been said in this email forum that
> GnuCash doesn't support inventory, but I think that's basically wrong.
> What I mean is that while GnuCash has no separate inventory module as are
> available in some versions of Quickbooks, say, one can use GnuCash + a
> supporting spreadsheet (in Excel or freeware LibreOffice Calc which both
> have some database features) perfectly well for accounting for a business
> with inventory.  A few demonstrations/examples are needed to provide for
> arriving potential users though.
>
> A simple approach which might work especially if there are not too many
> transactions could work as follows:
>
> *When purchasing inventory, perhaps of a few different types*:
> a) enter transaction into GnuCash as increasing one big Inventory account
> and decreasing cash without any detail about numbers of units of what
> types, just reference the invoice or sales receipt which you file into a
> Vendor file.
> b) in the spreadsheet create rows as needed for each the different types of
> inventory (say Barnevelder chickens and Chantecler chickens) and in three
> new columns for the purchases record the numbers and prices paid and total
> dollars paid for each
> Repeat as new transactions happen, adding 3 columns each time.
> Keep one column carrying the sum of all purchases as an estimate of current
> value of each type, with a sum at bottom reporting the total value of
> inventory.
>
> *At the end of a month or other accounting period*, do an inventory
> inspection and record in a new set of 3 columns the number of each type
> which you count, a price per unit (perhaps use the original or the last
> purchase price, or a new estimate of your own based on what you see and
> know), and a calculated current total dollars value.  Perhaps some units
> will have been lost or some new chicks have been hatched and some prices
> will have changed, so the sum of value of current inventory will be lower
> or higher.  Then update your financial value in Quickbooks to reflect the
> amount of that change:  increase or decrease "Inventory" value and
> recognize a gain (say "Gain from Inventory growth") as income or a loss
> (say "Loss from Inventory decline") as expense.
>
> Also *whenever you sell any units*, add three columns for the numbers sold,
> the price per unit, the dollars yielded.  In GnuCash enter an increase in
> cash and recognize "Revenue from sale of chickens" or whatever.
>
> In your business, you will also record expenses for operating costs, and
> any revenues from sales of eggs say, and in the Income Statement for a
> given period you will see whether you have made a profit or loss on the
> period.  In this approach, with your counting and revaluing your inventory
> to roughly a current market value each period, profit can be shown due to
> gains in value even if there have not been any sales.  As suggested here,
> the spreadsheet would tend to expand to the right.  But perhaps that is
> fine, as after all there is no shortage of empty columns available in any
> spreadsheet nowadays.
>
> Note there are many possible different implementations.  One could have
> GnuCash inventories for each type of chicken, so values for each type would
> appear in your Balance Sheet, though at cost of requiring many more GnuCash
> transaction entries.  One could use "inventory valuation" approaches other
> than the current market value estimation approach suggested above,
> variations that may be legally allowed in financial accounting (e.g. First
> In First Out (FIFO), LIFO, Average Cost, Specific Identification), but are
> probably not worth bothering with.  These variations might allow for some
> gaming to advance or defer taxes due, or to manipulate reported earnings of
> your firm sooner or later, but such gaming is generally not worthwhile.
> Also a more database-oriented approach to organizing the information might
> be possible, say with columns for each type of chicken and one row for each
> transaction or re-valuation or new total value.  Perhaps that would allow
> for some different types of reports using DCOUNT and DSUM type formulas.
>
> But perhaps the above approach would work for you?  Maybe you could
> explain a bit more about what you want to do?
>
> In my opinion, Quickbooks' inventory feature is cumbersome, requiring one
> to go through multiple screens to create a new inventory type, and
> requiring application of just one type of valuation (I think requiring
> every unit to be valued at same price per unit always, i.e. this is suited
> only to situations where suppliers are unrealistically required to sell to
> you at the same price forever).  It does not allow one to choose other
> valuation approache

Re: [GNC] 8.1.1. Find Transaction

[Adrien Monteleone]

You didn't click the 'Edit' button from the Accounts tab, that would 
have given you a window to edit that selected account.


You must mean you clicked on Edit > Find. (a menu option)

-

What are you ultimately trying to find?

If you have more than one criteria, say all transactions to Wal-Mart 
equal to 66.00, then I'd make the first criteria:


Description, contains, "Wal"

(don't spell it out entirely in case sometimes you put "Wal-mart" or 
"Walmart", for example)


Then Click the Add button at the top left and make the second criteria:

Value, has credits or debits, equal to, "66.00"

That way, you do the search in one shot.

I put the description first, but it could be either way. Though if the 
value search is more vague (like greater than or equal to) the results 
might return faster with description first.



An iterative search works a bit differently.

Take that Value=66.00 again, From the Search results tab, click Edit > 
Find, (or use cmd/ctrl+F) leave the radio button for 'Refine current 
search' selected, and put in a new criteria.


You'll then get a new results tab with the smaller result set that 
matched both conditions.


The end results *should* be the same either method.

The Find window also has an option for 'all' or 'any' criteria which 
would be an 'and' or an 'or' type search respectively.


You can also do some interesting iterative searches using the 'Delete 
results from current search' if you end up with a very large set or 
there isn't an easy way to exclude some transactions with the 
multi-criteria method.


Regards,
Adrien

On 10/2/20 11:54 AM, Jamestk wrote:

Thats sounds ideal Adrien but unsure how it works, let me describe what
happens.

 From the main accounts tree I clicked edit, find which brings up the
following window. From here I select 'value' as it works well finding
transactions, at this point these is no other option as greyed out.



Hitting enter it takes brings up the results, from this windows there
doesn't appear to be any other edit functions available?



___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[Jamestk]

Thanks David

Does the box remain after pressing enter ?

I think that's the key here for me as if results return nil (which is often
the case) then I can try again using perhaps description.

Tried on my Linux box which has two versions of GNC, 4.2 and 2.6.19 both
same as above, box closes preventing a second or edited search.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Customer Listing Report and Receivable Aging Report Error

[Christopher Lam]

Hi, there have been some changes in the reports to fix errors. It is
possible that other errors may have crept in. Please submit screenshots,
suitably anonymised, in Bugzilla.

On Sat, 3 Oct 2020, 5:31 am Bob Jenkins,  wrote:

> I recently updated from version 3.9 to 4.2. Version 4.2 seems to have an
> error in the "total" column for some customers that have made prepayments
> on both the Customer Listing Report and Receivable Aging Report. The amount
> in the "total" column does not agree with the "total due" balance on that
> customer's individual Customer Report. I did not observe this error with
> version 3.9.
>
> Is there any way to get a customer Listing Report that shows the "total
> due" amount shown on the individual Customer Report?
>
> Thanks
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[David Carlson]

Geoff,

Thank you for the very nice description of how to implement the mechanics
of an iterative search.  Now all we need is an easy to understand
description of how each of the search criteria work, including (especially,
with examples) exactly what regex means to those of us that went to school
before that term existed, how to know exactly which split lines are
searched and which split lines just come along for the ride into the
results, and perhaps why the search dialog disappears, which was the
original problem that started this thread.

I can't seem to make the help for that dialog appear from the help button
in that dialog.  I finally found the actual help in the F1 Help manual
under Tools and Assistants > Find which completely glosses over the
subjects in the previous paragraph.

On Fri, Oct 2, 2020 at 7:49 PM Geoff  wrote:

> Regardless of whether the search box disappears or not, GnuCash's
> "search within search results" feature is still pretty nifty.
>
> I've attached a screenshot showing four consecutive searches illustrating:
> New search (the other options are always disabled on the initial search)
> Add results to current search
> Refine current search
> Delete results from current search
>
> First search is to locate transactions with value less than 200.
> Second search is to add in transactions with value more than 800.
> Third search is to restrict to description containing "gnucash".
> Fourth search is to remove transactions posted on 26th September.
>
> (Harking back to our school days, I think we can say that GnuCash search
> provides the Set Theory equivalents of Union, Intersection, and
> Complement
> https://www.britannica.com/science/set-theory/Operations-on-sets.  But I
> digress.)
>
> The trick is to invoke the second and subsequent searches from the
> "Search Results" tab and not the Chart of Accounts.
>
> This is, of course, a simple example.  Any given search operation also
> lets you specify multiple criteria ("Add" button), and whether "all
> criteria" must be met or just "any criteria" ie AND or OR logic.
>
> James, I hope this tip improves your search results.
>
> Regards
>
> Geoff
> =
> Version: 4.1
> Build ID: 4.1+(2020-07-25)
> Finance::Quote: 1.49
> Windows 10
>
>
> On Sat, 26 Sep 2020 13:47:10 -0500 (CDT), Jamestk wrote:
> Hello good folks,
>
> I wanted to check if there was a simpler way when using the 'find
> transaction'feature repeatedly.
>
> When searching for transactions it normally involves a batch of invoices or
> receipts which are not showing withing reports, most often this is due to
> me
> selecting incorrect accounts or similar, easy way is to use find feature -
>
> Searches are basic, Select find from edit menu then opt for 'value' setting
> leaving all other criteria std, often this works but if it returns nil
> results you have to start over, is there anyway of saving the search or to
> edit and re-run the original without having to start from scratch?
>
> 8.1 help file is okay but a bit technical in parts.
>
> Thanks,
> >
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[Derek Atkins]

You must be in your 60s or 70s (or older) if you think you were around 
before the term regex was created.
The term regex (REGular EXpression) has been around at least since the 80s 
if not earlier.  It is a way to search for, well, a regular expression.
There are several resources for regex examples, and regex has been 
standardized for many decades.

Happy hacking.

-derek
Sent using my mobile device. Please excuse any typos.
On October 2, 2020 10:50:45 PM David Carlson  
wrote:



Geoff,

Thank you for the very nice description of how to implement the mechanics
of an iterative search.  Now all we need is an easy to understand
description of how each of the search criteria work, including (especially,
with examples) exactly what regex means to those of us that went to school
before that term existed, how to know exactly which split lines are
searched and which split lines just come along for the ride into the
results, and perhaps why the search dialog disappears, which was the
original problem that started this thread.

I can't seem to make the help for that dialog appear from the help button
in that dialog.  I finally found the actual help in the F1 Help manual
under Tools and Assistants > Find which completely glosses over the
subjects in the previous paragraph.

On Fri, Oct 2, 2020 at 7:49 PM Geoff  wrote:


Regardless of whether the search box disappears or not, GnuCash's
"search within search results" feature is still pretty nifty.

I've attached a screenshot showing four consecutive searches illustrating:
New search (the other options are always disabled on the initial search)
Add results to current search
Refine current search
Delete results from current search

First search is to locate transactions with value less than 200.
Second search is to add in transactions with value more than 800.
Third search is to restrict to description containing "gnucash".
Fourth search is to remove transactions posted on 26th September.

(Harking back to our school days, I think we can say that GnuCash search
provides the Set Theory equivalents of Union, Intersection, and
Complement
https://www.britannica.com/science/set-theory/Operations-on-sets.  But I
digress.)

The trick is to invoke the second and subsequent searches from the
"Search Results" tab and not the Chart of Accounts.

This is, of course, a simple example.  Any given search operation also
lets you specify multiple criteria ("Add" button), and whether "all
criteria" must be met or just "any criteria" ie AND or OR logic.

James, I hope this tip improves your search results.

Regards

Geoff
=
Version: 4.1
Build ID: 4.1+(2020-07-25)
Finance::Quote: 1.49
Windows 10


On Sat, 26 Sep 2020 13:47:10 -0500 (CDT), Jamestk wrote:
Hello good folks,

I wanted to check if there was a simpler way when using the 'find
transaction'feature repeatedly.

When searching for transactions it normally involves a batch of invoices or
receipts which are not showing withing reports, most often this is due to
me
selecting incorrect accounts or similar, easy way is to use find feature -

Searches are basic, Select find from edit menu then opt for 'value' setting
leaving all other criteria std, often this works but if it returns nil
results you have to start over, is there anyway of saving the search or to
edit and re-run the original without having to start from scratch?

8.1 help file is okay but a bit technical in parts.

Thanks,
>
___
gnucash-user mailing list
gnucash-user@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.




--
David Carlson
___
gnucash-user mailing list
gnucash-user@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.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] 8.1.1. Find Transaction

[David Carlson]

There you are, I graduated college in 1968.

Anyway I just created *Bug 797965*
 which is a RFE to a path
that would resolve the core problem of this thread, and I invite comments
there.

On Fri, Oct 2, 2020 at 10:02 PM Derek Atkins  wrote:

> You must be in your 60s or 70s (or older) if you think you were around
> before the term regex was created.
> The term regex (REGular EXpression) has been around at least since the 80s
> if not earlier.  It is a way to search for, well, a regular expression.
> There are several resources for regex examples, and regex has been
> standardized for many decades.
> Happy hacking.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
> On October 2, 2020 10:50:45 PM David Carlson 
> wrote:
>
> Geoff,
>>
>> Thank you for the very nice description of how to implement the mechanics
>> of an iterative search.  Now all we need is an easy to understand
>> description of how each of the search criteria work, including
>> (especially,
>> with examples) exactly what regex means to those of us that went to school
>> before that term existed, how to know exactly which split lines are
>> searched and which split lines just come along for the ride into the
>> results, and perhaps why the search dialog disappears, which was the
>> original problem that started this thread.
>>
>> I can't seem to make the help for that dialog appear from the help button
>> in that dialog.  I finally found the actual help in the F1 Help manual
>> under Tools and Assistants > Find which completely glosses over the
>> subjects in the previous paragraph.
>>
>> On Fri, Oct 2, 2020 at 7:49 PM Geoff  wrote:
>>
>> Regardless of whether the search box disappears or not, GnuCash's
>>> "search within search results" feature is still pretty nifty.
>>>
>>> I've attached a screenshot showing four consecutive searches
>>> illustrating:
>>> New search (the other options are always disabled on the initial search)
>>> Add results to current search
>>> Refine current search
>>> Delete results from current search
>>>
>>> First search is to locate transactions with value less than 200.
>>> Second search is to add in transactions with value more than 800.
>>> Third search is to restrict to description containing "gnucash".
>>> Fourth search is to remove transactions posted on 26th September.
>>>
>>> (Harking back to our school days, I think we can say that GnuCash search
>>> provides the Set Theory equivalents of Union, Intersection, and
>>> Complement
>>> https://www.britannica.com/science/set-theory/Operations-on-sets.  But I
>>> digress.)
>>>
>>> The trick is to invoke the second and subsequent searches from the
>>> "Search Results" tab and not the Chart of Accounts.
>>>
>>> This is, of course, a simple example.  Any given search operation also
>>> lets you specify multiple criteria ("Add" button), and whether "all
>>> criteria" must be met or just "any criteria" ie AND or OR logic.
>>>
>>> James, I hope this tip improves your search results.
>>>
>>> Regards
>>>
>>> Geoff
>>> =
>>> Version: 4.1
>>> Build ID: 4.1+(2020-07-25)
>>> Finance::Quote: 1.49
>>> Windows 10
>>>
>>>
>>> On Sat, 26 Sep 2020 13:47:10 -0500 (CDT), Jamestk wrote:
>>> Hello good folks,
>>>
>>> I wanted to check if there was a simpler way when using the 'find
>>> transaction'feature repeatedly.
>>>
>>> When searching for transactions it normally involves a batch of invoices
>>> or
>>> receipts which are not showing withing reports, most often this is due to
>>> me
>>> selecting incorrect accounts or similar, easy way is to use find feature
>>> -
>>>
>>> Searches are basic, Select find from edit menu then opt for 'value'
>>> setting
>>> leaving all other criteria std, often this works but if it returns nil
>>> results you have to start over, is there anyway of saving the search or
>>> to
>>> edit and re-run the original without having to start from scratch?
>>>
>>> 8.1 help file is okay but a bit technical in parts.
>>>
>>> Thanks,
>>>

 ___
>>> gnucash-user mailing list
>>> gnucash-user@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.
>>>
>>>
>>
>> --
>> David Carlson
>> ___
>> gnucash-user mailing list
>> gnucash-user@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 R