Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread Amish 



On Tuesday 10 October 2017 09:20 PM, Maf. King wrote:

On Tuesday, 10 October 2017 16:20:28 BST Amish wrote:


So I would like to know if there is way to have customized saved-reports
file per gnucash file? Name and location of which can be stored in that
gnucash file itself.

So that I do not have to keep re-selecting accounts everytime and
reports related to company A does not show when gnucash of company B is
opened and vice versa.



Hi Amish.

Not that I know of.  I've dealt with this by calling the reports CompanyA-Foo
and CompanyB-Foo

Although, I must say that I think the report saved accounts by name, not ID,
so one report could be used as the basis for the second company, with only a
little tweaking.

Maf.


I know thats how I have done it right now.

But I am from India where recently GST taxatio was introduced.

I have managed to configure Gnucash for the same.

For GST return filing Government needs many types of reporting every month.

Report for 3 types of taxes (IGST/CGST/SGST)
Report for trade payable (purchase+tax)
Report for trade receivable (sale+tax)
Report for taxable sales
Report for taxable purchase
Then there are reports for sale/purchase to/from GST dealers
And then same reports for dealers not registered under GST

As you can see there are almost 11-12 types of reports that we have 
provide to Government at end of every month


Now if I create customized reports I will have:
CompanyA-Sale, CompanyA-Purchase, ... 11-12 reports
same way 11-12 reports for company B

I have 2 more companies which I have still not migrated to GST

So you can see the report list will be too long when I open "Saved 
report configuration"


That is why I was asking if it is possible to have:
1) saved-reports per company
2) OR saved-reports storing FULL account name - for example 
Assets:Purchase:IGST insted of account ID.


I believe 2nd option would be much better as then we dont need to create 
separate reports for each company.


Infact both 1 and 2 can be implemened, if possible that would allow to 
store reports in a better way and also make them REUSABLE.


Thanks and regards,

Amish
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread Dave H 
Default location for saved reports on Windows 10 is
"C:\Users\\.gnucash\saved-reports-2.4"  I'm pretty sure I've just
copied that same file across to my Ubuntu Linux installation as well - will
check tonight and see where it is for Linux.

Cheers Dave H.

On 11 October 2017 at 09:23, David Carlson 
wrote:

> There is a section in the GnuCash FAQ about what files are where for the
> various OS's.  IIRC there is a .gnucash directory under ~user or some such
> which can be copied and pasted into another machine, even under a different
> OS but that would overwrite whatever is there.  Do not try that without
> backing up whatever is already there.  For Windows it might get more
> complicated, as some stuff is now in the Registry.
>
> David C
>
>
> On Tue, Oct 10, 2017 at 4:26 PM, Matthew Pounsett 
> wrote:
>
> > On 10 October 2017 at 15:15, Carsten Rinke  wrote:
> >
> > > Hi Ben,
> > >
> > > what do you mean by machine specific?
> > >
> > > If you transfer your gnucash data file between machines, I thought it
> > > should also possible to transfer the saved-reports-2.x file between the
> > > machines.
> > >
> >
> > It probably is, but it's not trivial.  The data file is saved to an
> > arbitrary location, which can easily be some sort of shared media.  The
> > saved reports get saved... somewhere... by the application, and that
> > somewhere is very likely platform-specific, and doesn't seem to be
> > configurable.  Add to that the documentation about where GnuCash saves
> > certain state files seems to be out of date (at least for the Mac) and
> it's
> > enough to make the saved reports files less portable just because they're
> > that much more difficult to find.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread David Carlson 
There is a section in the GnuCash FAQ about what files are where for the
various OS's.  IIRC there is a .gnucash directory under ~user or some such
which can be copied and pasted into another machine, even under a different
OS but that would overwrite whatever is there.  Do not try that without
backing up whatever is already there.  For Windows it might get more
complicated, as some stuff is now in the Registry.

David C


On Tue, Oct 10, 2017 at 4:26 PM, Matthew Pounsett 
wrote:

> On 10 October 2017 at 15:15, Carsten Rinke  wrote:
>
> > Hi Ben,
> >
> > what do you mean by machine specific?
> >
> > If you transfer your gnucash data file between machines, I thought it
> > should also possible to transfer the saved-reports-2.x file between the
> > machines.
> >
>
> It probably is, but it's not trivial.  The data file is saved to an
> arbitrary location, which can easily be some sort of shared media.  The
> saved reports get saved... somewhere... by the application, and that
> somewhere is very likely platform-specific, and doesn't seem to be
> configurable.  Add to that the documentation about where GnuCash saves
> certain state files seems to be out of date (at least for the Mac) and it's
> enough to make the saved reports files less portable just because they're
> that much more difficult to find.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread Carsten Rinke 

Hi Ben,

what do you mean by machine specific?

If you transfer your gnucash data file between machines, I thought it 
should also possible to transfer the saved-reports-2.x file between the 
machines.
Agreed, a combined file would make the transfer handling easier, but if 
you keep in mind always to transfer both files, it should work already now.


BTW: The accounts are stored by ID, and I am not aware that this can be 
switch somehow -> I would not recommend tweaking.


Carsten

On 10.10.2017 18:08, Benjamin Smith wrote:

Add that to the wish list. I often switch from one computer to another
and keep the same version of GnuCash on each machine, however, the
saved reports are machine specific. It would be nice to  link the
reports to the gnucash data file. Not sure how it works internally
right now.

ben

On Tue, Oct 10, 2017 at 10:50 AM, Maf. King  wrote:

On Tuesday, 10 October 2017 16:20:28 BST Amish wrote:


So I would like to know if there is way to have customized saved-reports
file per gnucash file? Name and location of which can be stored in that
gnucash file itself.

So that I do not have to keep re-selecting accounts everytime and
reports related to company A does not show when gnucash of company B is
opened and vice versa.



Hi Amish.

Not that I know of.  I've dealt with this by calling the reports CompanyA-Foo
and CompanyB-Foo

Although, I must say that I think the report saved accounts by name, not ID,
so one report could be used as the basis for the second company, with only a
little tweaking.

Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread Benjamin Smith 
Add that to the wish list. I often switch from one computer to another
and keep the same version of GnuCash on each machine, however, the
saved reports are machine specific. It would be nice to  link the
reports to the gnucash data file. Not sure how it works internally
right now.

ben

On Tue, Oct 10, 2017 at 10:50 AM, Maf. King  wrote:
> On Tuesday, 10 October 2017 16:20:28 BST Amish wrote:
>
>> So I would like to know if there is way to have customized saved-reports
>> file per gnucash file? Name and location of which can be stored in that
>> gnucash file itself.
>>
>> So that I do not have to keep re-selecting accounts everytime and
>> reports related to company A does not show when gnucash of company B is
>> opened and vice versa.
>>
>
>
> Hi Amish.
>
> Not that I know of.  I've dealt with this by calling the reports CompanyA-Foo
> and CompanyB-Foo
>
> Although, I must say that I think the report saved accounts by name, not ID,
> so one report could be used as the basis for the second company, with only a
> little tweaking.
>
> Maf.
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

2017-10-10 Thread David Carlson 
Geert,

I should be sorry for exposing you and others to my rant about Google, but
it was the third time in a week that their software did something
unexpected that was not making me happy.


David C

On Oct 10, 2017 10:26 AM, "Geert Janssens" 
wrote:

> Heh, sorry. I'm not near a computer to verify my directions and won't be
> until next week...
>
> Glad you managed to decode my terse answer.
>
> Geert
>
> Elmar  schreef op 9 oktober 2017 21:37:57 GMT+01:00:
> >Perfect!  Thanks, although I had to translate this to the menu entry
> >"edit/find" (not "search")
> >
> >- elmar
> >
> >On 10/09/2017 04:16 PM, David Carlson wrote:
> >> Geert,
> >>
> >> Gmail used those ing triple dots to hide your reply in my mail
> >> folder.  Lucky for me I suspected as much when there appeared to be
> >no
> >> reply .
> >>
> >> David C
> >>
> >>
> >> On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens
> >> >
> >wrote:
> >>
> >> Start with a search from the account hierarchy page and then open
> >> an account report on the search results tab.
> >>
> >> Regards,
> >> Geert
> >>
> >> Elmar > schreef op 9
> >> oktober 2017 20:35:06 GMT+01:00:
> >> >Good afternoon to the list
> >> >
> >> >I seem to be having a brain fart.  I am trying to retrieve all
> >the
> >> >transactions (all dates) with a certain payee in the description
> >> field,
> >> >
> >> >and only those transactions.  Somehow I cannot make the
> >transaction
> >> >report do this - what am I missing?  It should be easy, which
> >> tells me
> >> >I'm at fault.
> >> >
> >> >- Elmar
> >> >
> >> >
> >> >___
> >> >gnucash-user mailing list
> >> >gnucash-user@gnucash.org 
> >> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> 
> >> >-
> >> >Please remember to CC this list on all your replies.
> >> >You can do this by using Reply-To-List or Reply-All.
> >>
> >> Sent from my smartphone. Please excuse my brevity.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org 
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> 
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >>
> >
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >-
> >Please remember to CC this list on all your replies.
> >You can do this by using Reply-To-List or Reply-All.
>
> --
> Verzonden van mijn Android telefoon met K-9 Mail.
> Sent from my smartphone. Please excuse my brevity.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread Maf. King 
On Tuesday, 10 October 2017 16:20:28 BST Amish wrote:

> So I would like to know if there is way to have customized saved-reports
> file per gnucash file? Name and location of which can be stored in that
> gnucash file itself.
> 
> So that I do not have to keep re-selecting accounts everytime and
> reports related to company A does not show when gnucash of company B is
> opened and vice versa.
> 


Hi Amish.

Not that I know of.  I've dealt with this by calling the reports CompanyA-Foo 
and CompanyB-Foo

Although, I must say that I think the report saved accounts by name, not ID, 
so one report could be used as the basis for the second company, with only a 
little tweaking.

Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

2017-10-10 Thread Geert Janssens 
Heh, sorry. I'm not near a computer to verify my directions and won't be until 
next week...

Glad you managed to decode my terse answer.

Geert

Elmar  schreef op 9 oktober 2017 21:37:57 GMT+01:00:
>Perfect!  Thanks, although I had to translate this to the menu entry 
>"edit/find" (not "search")
>
>- elmar
>
>On 10/09/2017 04:16 PM, David Carlson wrote:
>> Geert,
>>
>> Gmail used those ing triple dots to hide your reply in my mail 
>> folder.  Lucky for me I suspected as much when there appeared to be
>no 
>> reply .
>>
>> David C
>>
>>
>> On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens 
>> >
>wrote:
>>
>> Start with a search from the account hierarchy page and then open
>> an account report on the search results tab.
>>
>> Regards,
>> Geert
>>
>> Elmar > schreef op 9
>> oktober 2017 20:35:06 GMT+01:00:
>> >Good afternoon to the list
>> >
>> >I seem to be having a brain fart.  I am trying to retrieve all
>the
>> >transactions (all dates) with a certain payee in the description
>> field,
>> >
>> >and only those transactions.  Somehow I cannot make the
>transaction
>> >report do this - what am I missing?  It should be easy, which
>> tells me
>> >I'm at fault.
>> >
>> >- Elmar
>> >
>> >
>> >___
>> >gnucash-user mailing list
>> >gnucash-user@gnucash.org 
>> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 
>> >-
>> >Please remember to CC this list on all your replies.
>> >You can do this by using Reply-To-List or Reply-All.
>>
>> Sent from my smartphone. Please excuse my brevity.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

-- 
Verzonden van mijn Android telefoon met K-9 Mail.
Sent from my smartphone. Please excuse my brevity.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Report - Items sold, quantity and value

2017-10-10 Thread Maf. King 
On Tuesday, 10 October 2017 14:59:08 BST Eduardo Estefano Neto wrote:
> Hi there everyone. Does anyone know how to extract a list of items sold? I
> would like to have a listing of items inside the invoices. Something like:
> 
> Client | Invoice Nr | Item | Quantity | Value
> 
> Thanks in advance
> 
> Eduardo

Hi Eduardo,

That report layout doesn't sound familiar to me - I don't think Gnucash has a 
report that extracts that information.

Probably it would be possible to create one either in Scheme, but I can't help 
with any more detail than that.

good luck
Maf.


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

2017-10-10 Thread Colin Law 
Are there any of the backups there somename.gnucash.nnn?  The
number string is the date/time that it was taken. These will be mixed
up with the log files so you may not have noticed them.

Colin

On 10 October 2017 at 14:30, Frankie Raney  wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
>
> On Oct 10, 2017 2:50 AM, "Liz"  wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney  wrote:
>>
>> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
>> > awayI saved it after importing, and looked at it with file
>> > browserit was therethen I went back, run GC and started
>> > editing..when GC crashed, the file went to lala land. Only the
>> > log file was left.
>>
>> basic idea, but in case lala land is still on your hard drive, a search
>> for *.gnucash is worthwhile
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Report - Items sold, quantity and value

2017-10-10 Thread Eduardo Estefano Neto 
Hi there everyone. Does anyone know how to extract a list of items sold? I
would like to have a listing of items inside the invoices. Something like:

Client | Invoice Nr | Item | Quantity | Value

Thanks in advance

Eduardo
-- 
Eduardo Estefano Neto
eduardo.estefano.n...@gmail.com
(11) 9.9481-3450
Linkedin: https://br.linkedin.com/pub/eduardo-estefano-neto/b/877/793
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

2017-10-10 Thread Maf. King 
On Tuesday, 10 October 2017 14:30:41 BST Frankie Raney wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
> 

Hi Frankie,

Don't know much about importing, 'cos I've never done it, but trashing the 
data file is a worry!

AFAIK,when GC does a save (or autosave) it doesn't delete the data file - it 
renames the old one to [name].timestamp.gnucash, and then creates a new 
[name].gnucash  -  which I know doesn't help much...

are you on Windows?  Try looking for hidden files?  What was the full path to 
the folder the file disappeared from ?  Were you using the XML or SQLite file 
backend (or a full-on database)? 

- fully appreciate that as a new user, you may not know the answers to these, 
especially the last question!

HTH,
Maf.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

2017-10-10 Thread Frankie Raney 
Did a search, that's how I know it went to lala land.  Can't remember ever
having this happen before.

On Oct 10, 2017 2:50 AM, "Liz"  wrote:

> On Mon, 9 Oct 2017 20:39:34 -0700
> Frankie Raney  wrote:
>
> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
> > awayI saved it after importing, and looked at it with file
> > browserit was therethen I went back, run GC and started
> > editing..when GC crashed, the file went to lala land. Only the
> > log file was left.
>
> basic idea, but in case lala land is still on your hard drive, a search
> for *.gnucash is worthwhile
>
> Liz
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

2017-10-10 Thread Liz 
On Mon, 9 Oct 2017 20:39:34 -0700
Frankie Raney  wrote:

> Yes, yes, and yes. It was, is the only filewhen it crashed it went
> awayI saved it after importing, and looked at it with file
> browserit was therethen I went back, run GC and started
> editing..when GC crashed, the file went to lala land. Only the
> log file was left.

basic idea, but in case lala land is still on your hard drive, a search
for *.gnucash is worthwhile

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.