Re: [GNC] GNC] Question about Assemblies

[Derek Atkins]

David,

On Tue, March 22, 2022 2:32 am, David Long wrote:
> Best to use system which has inventory accounting as then you won't have
> to
> worry about accounting double entry as system will generate it for you
> automatically.

Perhaps...

> When you enter a purchase invoice it will have a quantity purchase field
> so
> item will be put into stock at cost and quantity. Then there will be a
> manufacturing transaction which will take it out of raw materials and into
> finished stock (assemblies) at cost and quantity.. When it's sold it there
> will be a sales transaction in quantity and price which will generate an
> invoice and take item out of finished product stock in quantity and cost,
> and then calculate the sales less cost of goods sold so you know your
> margins
>
> Hardly any of this can be done by GnuCash so you will need to use spread
> sheets and have a course in accounting.

I would argue this statement is incorrect and misleading.  Indeed, I would
say *MOST* of this can be done in GnuCash, although it might not be as
seamless as it could be.  For example, when you make a Vendor Bill in
GnuCash, you can send it into an Asset instead of an Expense (which
includes Stock/Mutual accounts).  Similarly, when you make a Customer
Invoice, you can pull from an Asset instead of Income.

The difference in the sale and purchase of the asset is your Income (margin).

I agree that this is not as seamless as it could be in GnuCash (I admit,
when I originally wrote the business features I did it from the point of
view of running a consulting company, not a manufacturing company -- but I
did attempt to add the features to make the latter *possible*, if not
necessarily seamless).

> Plus ,a half decent accounting system which has inventory accounting would
> also have sales and purchase order management and a bill of material
> system
> to hold your soap recipes.

So having an inventory system is a requisite for an accounting package to
be "half-decent"?  Huh?

The "Job" feature of GnuCash was an attempt as a purchase-order solution. 
There was also the concept of an "Order" (which was an attempt at
something between a PO and a Quote), but those were never completely
finished and I believe have since been removed.   That notwithstanding, I
would argue an accounting program is NOT the right place to maintain
recipes.

> David

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] GNC] Question about Assemblies

[davidvernonlong]

Hi Derek,
I meant that a half decent accounting system which has an inventory system 
would have those features, and am sorry if my statement was misunderstood. I 
use GnuCash to maintain a set of accounts for a boat club with nearly 100 
members and it is excellent for that, and I use the business aspects as I have 
members as customers for service/fees etc.
On your points, of course GnuCash can track costs of inventory in its G/L, but 
when it comes to recording inventory levels to manage a manufacturing business, 
quantities are really needed ,either in the system , or in an external system.  
Then you would need to link the 2 systems, either automatically or manually. If 
manually then ,to move raw materials after manufacture to finished product, 
calculations would have to be done outside GnuCash to multiply  quantity and 
unit cost of each item consumed to provide total cost , and then manual 
postings to GnuCah General Ledger for total cost (Cr raw materials/ Dr finished 
goods) and the same for sales to move from finished inventory to cost of sales 
(Cr finished goods/Dr Cost of goods sold). 
To make it more complicated this has to be done on as FIFO or average cost 
basis, depending on the jurisdiction, as particular items will be purchased 
many times for inventory and taken out of inventory for consumption, at 
different times and different quantities. An accounting system with inventory 
management does this for you. To do this semi manually in Excel and then use 
the result to make a journal to GnuCash could  be a lot of work depending on 
the number of transactions.

When you say "Similarly, when you make a Customer Invoice, you can pull from an 
Asset instead of Income", this would not be correct. The sale must still be an 
income account, (Cr Income/ Dr Receivables)and you would need a further  entry, 
the one I describe above, to calculate the cost of the inventory reduction and 
record cost of sales as an expense.

On the maintenance of recipes , all major accounting/ERP systems designed for 
manufacturing have bill of materials, sometimes called recipes or formulations 
in process industries. Just replace no of items with litres, kg or whatever. 
However, GnuCash makes no pretence to be an ERP system in a manufacturing 
environment, and is great at what it does.

I do see though that SAGE has a Bill of Materials System:
" Bill of Materials
Monitor, control, and cost your manufacturing processes for businesses involved 
in light manufacturing assembly, helping to simplify complex process and 
analysis. Includes using multiple BOMs with different options for sub-assembly 
builds, stock, or multiple units of measure."

Thanks for your work on developing the business aspects of GnuCash, which is 
much appreciated, in my boat club now I have retired from the Chemical Industry.
Best
David




-Original Message-
From: Derek Atkins  
Sent: Tuesday, 22 March, 2022 11:40 AM
To: David Long 
Cc: D. via gnucash-user 
Subject: Re: [GNC] GNC] Question about Assemblies

David,

On Tue, March 22, 2022 2:32 am, David Long wrote:
> Best to use system which has inventory accounting as then you won't 
> have to worry about accounting double entry as system will generate it 
> for you automatically.

Perhaps...

> When you enter a purchase invoice it will have a quantity purchase 
> field so item will be put into stock at cost and quantity. Then there 
> will be a manufacturing transaction which will take it out of raw 
> materials and into finished stock (assemblies) at cost and quantity.. 
> When it's sold it there will be a sales transaction in quantity and 
> price which will generate an invoice and take item out of finished 
> product stock in quantity and cost, and then calculate the sales less 
> cost of goods sold so you know your margins
>
> Hardly any of this can be done by GnuCash so you will need to use 
> spread sheets and have a course in accounting.

I would argue this statement is incorrect and misleading.  Indeed, I would say 
*MOST* of this can be done in GnuCash, although it might not be as seamless as 
it could be.  For example, when you make a Vendor Bill in GnuCash, you can send 
it into an Asset instead of an Expense (which includes Stock/Mutual accounts).  
Similarly, when you make a Customer Invoice, you can pull from an Asset instead 
of Income.

The difference in the sale and purchase of the asset is your Income (margin).

I agree that this is not as seamless as it could be in GnuCash (I admit, when I 
originally wrote the business features I did it from the point of view of 
running a consulting company, not a manufacturing company -- but I did attempt 
to add the features to make the latter *possible*, if not necessarily seamless).

> Plus ,a half decent accounting system which has inventory accounting 
> would also have sales and purchase order management and a bill of 
> material system to hold your soap recipes.

So having an inventory system is a requisite for an accou

Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

[Fran_3 via gnucash-user]

 Glad to see your are still active Adrien. You and the others here are an asset 
to the community and we are thankful for your participation in the gnuCash 
email list.

On Monday, March 21, 2022, 10:53:03 PM EDT, Adrien Monteleone 
 wrote:  
 
 Yeah, I got one too.

I'm still here of course. I took a break last fall, but have been fairly 
active since returning.

Regards,
Adrien

On 3/21/22 3:17 PM, David Carlson wrote:
> Fran_3,
> 
> I did not see your original message.  Did you send it directly to
> Christopher instead of the list?  That is seriously discouraged, and the
> primary reason that I thought that was phishing.

___
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] GNC] Question about Assemblies

[Adrien Monteleone]

On 3/22/22 8:46 AM, davidvernonl...@gmail.com wrote:

On your points, of course GnuCash can track costs of inventory in its G/L, but 
when it comes to recording inventory levels to manage a manufacturing business, 
quantities are really needed ,either in the system , or in an external system.


As some have noted, you can possibly use one of the investment type 
accounts to fudge quantity tracking, though it of course isn't designed 
for this and doesn't work like other software in this regard. It also 
takes a little bit of mental gymnastics to grok it.


Then you would need to link the 2 systems, either automatically or 
manually. If manually then ,to move raw materials after manufacture to 
finished product, calculations would have to be done outside GnuCash to 
multiply  quantity and unit cost of each item consumed to provide total 
cost , and then manual postings to GnuCah General Ledger for total cost 
(Cr raw materials/ Dr finished goods) and the same for sales to move 
from finished inventory to cost of sales (Cr finished goods/Dr Cost of 
goods sold).


Depending on the inventory and assembly 'recipe' complexity, this can be 
done in a spreadsheet. GnuCash can import transactions, so this 
spreadsheet can create an 'import sheet' version of the final data as 
transactions to be imported - no need for manual entry.



To make it more complicated this has to be done on as FIFO or average cost 
basis, depending on the jurisdiction, as particular items will be purchased 
many times for inventory and taken out of inventory for consumption, at 
different times and different quantities. An accounting system with inventory 
management does this for you. To do this semi manually in Excel and then use 
the result to make a journal to GnuCash could  be a lot of work depending on 
the number of transactions.


Yes, *if* it includes inventory management though GnuCash does not. But 
that doesn't mean it can't handle the accounting of inventory.


Stand-alone inventory management software will generate the necessary 
transactions according to the above considerations to import to any 
accounting package as will point of sale software.


Sometimes, all three functions (as well as Payroll, and other features) 
are shoehorned into one piece of software. Those either cost a small 
fortune, if not a hefty subscription, and/or turn out to be not so great 
at one or more of those 'modules'.




When you say "Similarly, when you make a Customer Invoice, you can pull from an 
Asset instead of Income", this would not be correct. The sale must still be an 
income account, (Cr Income/ Dr Receivables)and you would need a further  entry, the one I 
describe above, to calculate the cost of the inventory reduction and record cost of sales 
as an expense.


Correct. You're describing a Point of Sale (POS) system, another entity 
entirely. Some may have integrated G/L accounting, but not all, and the 
better systems simply offer the relevant transactions for export/import 
to real accounting software.


GnuCash's Business Features are somewhat flexible in the use cases they 
can serve, but they don't shine as a retail/manufacturing POS and are 
geared more toward 'service' type industries.



On the maintenance of recipes , all major accounting/ERP systems designed for 
manufacturing have bill of materials, sometimes called recipes or formulations 
in process industries. Just replace no of items with litres, kg or whatever. 
However, GnuCash makes no pretence to be an ERP system in a manufacturing 
environment, and is great at what it does.

I do see though that SAGE has a Bill of Materials System:
" Bill of Materials
Monitor, control, and cost your manufacturing processes for businesses involved in 
light manufacturing assembly, helping to simplify complex process and analysis. 
Includes using multiple BOMs with different options for sub-assembly builds, stock, 
or multiple units of measure."


What you have described above is really separate software:

-General Ledger Accounting

GnuCash is this.

Other related software would handle separately:

-Payables & Receivables
-Payroll
-Investments
-Loans & Notes
-Budgeting

GnuCash includes these in some form, but maybe not full-fledged.

Then there are packages like:

-Customer Relationship Management (CRM)
-Managerial Analysis
-E-commerce
etc.

GnuCash doesn't include those at all.

And those are just the generic types. Consider that a service business 
might want to track service calls/tickets, time spent on the job, time 
spent in travel, expenses for travel and incidentals, etc. Now, we 
wouldn't think GnuCash should include all of that industry-specific 
related functionality, right?


This is analogous to the retail/manufacturing specific functions:

Purchases & Acquisitions
Inventory Management
Manufacturing & Production
Point of Sale

All separate., though interrelated, functions, that sometimes are in the 
same software package, sometimes not, and not included in GnuCash.

Re: [GNC] GNC] Question about Assemblies

[john]

David,

Derek described a way to handle a (simple) retail business with GnuCash. 
Manufacturing is another matter entirely and involves an accounting specialty 
named Cost Accounting. Enterprise resource planning, or ERP, is one flavor of 
cost accounting widely used in many industries. There are others, for example 
the integrated circuits industry uses a system called standard cost accounting. 
ERP doesn't work because aside from the wafers only tiny amounts of some of the 
process inputs actually end up in the product so it's not possible to create a 
meaningful BOM. In standard cost accounting each step in the process is 
assigned a standard cost and WIP accumulates the standard costs for each step 
in the process.

There are a few open-source ERP packages available. GnuCash is definitely not 
one of them and doesn't aspire to be.

Regards,
John Ralls



> On Mar 22, 2022, at 6:46 AM, davidvernonl...@gmail.com wrote:
> 
> Hi Derek,
> I meant that a half decent accounting system which has an inventory system 
> would have those features, and am sorry if my statement was misunderstood. I 
> use GnuCash to maintain a set of accounts for a boat club with nearly 100 
> members and it is excellent for that, and I use the business aspects as I 
> have members as customers for service/fees etc.
> On your points, of course GnuCash can track costs of inventory in its G/L, 
> but when it comes to recording inventory levels to manage a manufacturing 
> business, quantities are really needed ,either in the system , or in an 
> external system.  Then you would need to link the 2 systems, either 
> automatically or manually. If manually then ,to move raw materials after 
> manufacture to finished product, calculations would have to be done outside 
> GnuCash to multiply  quantity and unit cost of each item consumed to provide 
> total cost , and then manual postings to GnuCah General Ledger for total cost 
> (Cr raw materials/ Dr finished goods) and the same for sales to move from 
> finished inventory to cost of sales (Cr finished goods/Dr Cost of goods 
> sold). 
> To make it more complicated this has to be done on as FIFO or average cost 
> basis, depending on the jurisdiction, as particular items will be purchased 
> many times for inventory and taken out of inventory for consumption, at 
> different times and different quantities. An accounting system with inventory 
> management does this for you. To do this semi manually in Excel and then use 
> the result to make a journal to GnuCash could  be a lot of work depending on 
> the number of transactions.
> 
> When you say "Similarly, when you make a Customer Invoice, you can pull from 
> an Asset instead of Income", this would not be correct. The sale must still 
> be an income account, (Cr Income/ Dr Receivables)and you would need a further 
>  entry, the one I describe above, to calculate the cost of the inventory 
> reduction and record cost of sales as an expense.
> 
> On the maintenance of recipes , all major accounting/ERP systems designed for 
> manufacturing have bill of materials, sometimes called recipes or 
> formulations in process industries. Just replace no of items with litres, kg 
> or whatever. However, GnuCash makes no pretence to be an ERP system in a 
> manufacturing environment, and is great at what it does.
> 
> I do see though that SAGE has a Bill of Materials System:
> " Bill of Materials
> Monitor, control, and cost your manufacturing processes for businesses 
> involved in light manufacturing assembly, helping to simplify complex process 
> and analysis. Includes using multiple BOMs with different options for 
> sub-assembly builds, stock, or multiple units of measure."
> 
> Thanks for your work on developing the business aspects of GnuCash, which is 
> much appreciated, in my boat club now I have retired from the Chemical 
> Industry.
> Best
> David
> 
> 
> 
> 
> -Original Message-
> From: Derek Atkins  
> Sent: Tuesday, 22 March, 2022 11:40 AM
> To: David Long 
> Cc: D. via gnucash-user 
> Subject: Re: [GNC] GNC] Question about Assemblies
> 
> David,
> 
> On Tue, March 22, 2022 2:32 am, David Long wrote:
>> Best to use system which has inventory accounting as then you won't 
>> have to worry about accounting double entry as system will generate it 
>> for you automatically.
> 
> Perhaps...
> 
>> When you enter a purchase invoice it will have a quantity purchase 
>> field so item will be put into stock at cost and quantity. Then there 
>> will be a manufacturing transaction which will take it out of raw 
>> materials and into finished stock (assemblies) at cost and quantity.. 
>> When it's sold it there will be a sales transaction in quantity and 
>> price which will generate an invoice and take item out of finished 
>> product stock in quantity and cost, and then calculate the sales less 
>> cost of goods sold so you know your margins
>> 
>> Hardly any of this can be done by GnuCash so you will need to use 
>> spread sheets and

[GNC] new subaccounts and updating saved reports

[George Riner]

I am learning that when I add another subaccount to an account already 
has subaccounts and the account is already in several "saved report 
configurations" that I now have to go back through each and every one of 
my "saved report configurations" and update its Options to include that 
new subaccount.  It won't automatically include that new subaccount just 
because it's a subaccount of an account that's already selected in the 
options for those saved report configurations.


Is there a way to make it work that way?

:George
Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
Gnucash: 4.9+(2021-12-18) English
Finance Quote: 1.51a

___
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] One of my account disappeared

[Heide Wang]

Hello,

I finally got a chance to upgraded my old version of Gnucash to 3 and to 4.9 as 
some of you suggested. Everything looks and works fine. Thank you all. 
But today when I look for one of my credit card account, Citibank Visa account, 
I can’t find it. It was a sub-account listed under Liability before. it has 
zero balance. Can someone tell me where to look and change the setting? Thanks 
again.

Heide
___
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] new subaccounts and updating saved reports

[davidcousens49]

George

Have you tried changing the number of sub-account levels in the report options?
(Edit->Report Options with the report open). It may be possible that changing
from the default level of 3 and/or changing the option to flatten the account
structure (you can always change it back again if the result is not desirable)
may force a reevaluation of the included accounts. Not sure if this will work
but it may be worth a try. If you get the report showing the added accounts then
resave the report.

David Cousens


 On Tue, 2022-03-22 at 11:53 -0700, George Riner wrote:
> I am learning that when I add another subaccount to an account already 
> has subaccounts and the account is already in several "saved report 
> configurations" that I now have to go back through each and every one of 
> my "saved report configurations" and update its Options to include that 
> new subaccount.  It won't automatically include that new subaccount just 
> because it's a subaccount of an account that's already selected in the 
> options for those saved report configurations.
> 
> Is there a way to make it work that way?
> 
> :George
> Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
> Gnucash: 4.9+(2021-12-18) English
> Finance Quote: 1.51a
> 
> ___
> 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] One of my account disappeared

[Timothy B. Taylor]

Try clicking View
and then Filter By...
and then Other
and make sure Show zero total accounts is checked
and then OK

Tim


On Tue, Mar 22, 2022 at 3:24 PM Heide Wang  wrote:

> Hello,
>
> I finally got a chance to upgraded my old version of Gnucash to 3 and to
> 4.9 as some of you suggested. Everything looks and works fine. Thank you
> all.
> But today when I look for one of my credit card account, Citibank Visa
> account, I can’t find it. It was a sub-account listed under Liability
> before. it has zero balance. Can someone tell me where to look and change
> the setting? Thanks again.
>
> Heide
> ___
> 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] GNC] Question about Assemblies

[Michael or Penny Novack]

On 3/22/2022 9:46 AM, davidvernonl...@gmail.com wrote:

Hi Derek,
I meant that a half decent accounting system which has an inventory system 
would have those features, and am sorry if my statement was misunderstood. I 
use GnuCash to maintain a set of accounts for a boat club with nearly 100 
members and it is excellent for that, and I use the business aspects as I have 
members as customers for service/fees etc.
On your points, of course GnuCash can track costs of inventory in its G/L, but 
when it comes to recording inventory levels to manage a manufacturing business, 
quantities are really needed ,either in the system , or in an external system.  
Then you would need to link the 2 systems, either automatically or manually. If 
manually then ,to move raw materials after manufacture to finished product, 
calculations would have to be done outside GnuCash to multiply  quantity and 
unit cost of each item consumed to provide total cost , and then manual 
postings to GnuCah General Ledger for total cost (Cr raw materials/ Dr finished 
goods) and the same for sales to move from finished inventory to cost of sales 
(Cr finished goods/Dr Cost of goods sold).
To make it more complicated this has to be done on as FIFO or average cost 
basis, depending on the jurisdiction, as particular items will be purchased 
many times for inventory and taken out of inventory for consumption, at 
different times and different quantities. An accounting system with inventory 
management does this for you. To do this semi manually in Excel and then use 
the result to make a journal to GnuCash could  be a lot of work depending on 
the number of transactions.


A business operation needs all sorts of record keeping. The accounting 
package is just part of that. Gnucash is an accounting package. If 
inventory is involved, then also an inventory package, if employees, a 
payroll/human resources package, etc.


Yes, these systems interact, and if only manually a lot of work. If they 
can send and accept "feeds" between the parts, a LOT less as that part 
of it can be automated << and that's where my professional days were 
spent -- in my case, at a "financial">>


You are missing that a proper inventory system needs/should have MUCH 
more than the part that would interact with general ledger. Where 
shelved, what';s the reorder level, who is the supplier, who are 
alternate suppliers, etc. Similarly the payroll system/HR needs more 
than what interacts with general ledger. Who is the emergency contact, 
who is the bene on the employee insurance policy, etc. .


From MY point of view, all that gnucash is missing in this regard is 
the ability to accept "feeds" << normally "general ledger" accepts feeds 
but does not send feds to other parts of the business system -- most of 
them send feeds to general ledger and send to and accept form each other 
>> If gnucash can do THAT, then it is up to other teams to create 
inventory systems, POS systems, payroll systems, etc. that will pay well 
with gnucash handling general ledger.


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] new subaccounts and updating saved reports

[David T. via gnucash-user]

My experience matches that of George, and I don't see how changing the levels 
could gather a new account into the report. 

The issue has been raised before recently, although I couldn't track it down. 
Short of rewriting the report code to re-evaluate the account set every time a 
report is run, I can't see how to fix the problem-- and even then, how would 
gnucash know when a given account should be added to any given report or not? 

There are plenty of use cases where a saved report includes a subset of 
accounts on purpose-- for example, when one wants a report that includes 
expenses for an isolated cost area (think rental properties). I might even 
hazard a guess that this would be one of the primary features of saved report 
configurations. The lists here have countless threads advising users to do just 
that. So automatically adding new subaccounts to existing reports could be 
detrimental for many users with saved reports. 

That's not to say that I haven't wished for some way to automate this aspect. I 
just don't see how you would implement it. 

David T.

On March 22, 2022 6:49:25 PM EDT, davidcousen...@gmail.com wrote:
>George
>
>Have you tried changing the number of sub-account levels in the report options?
>(Edit->Report Options with the report open). It may be possible that changing
>from the default level of 3 and/or changing the option to flatten the account
>structure (you can always change it back again if the result is not desirable)
>may force a reevaluation of the included accounts. Not sure if this will work
>but it may be worth a try. If you get the report showing the added accounts 
>then
>resave the report.
>
>David Cousens
>
>
> On Tue, 2022-03-22 at 11:53 -0700, George Riner wrote:
>> I am learning that when I add another subaccount to an account already 
>> has subaccounts and the account is already in several "saved report 
>> configurations" that I now have to go back through each and every one of 
>> my "saved report configurations" and update its Options to include that 
>> new subaccount.  It won't automatically include that new subaccount just 
>> because it's a subaccount of an account that's already selected in the 
>> options for those saved report configurations.
>> 
>> Is there a way to make it work that way?
>> 
>> :George
>> Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
>> Gnucash: 4.9+(2021-12-18) English
>> Finance Quote: 1.51a
>> 
>> ___
>> 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.
___
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] One of my account disappeared

[Heide Wang]

Find it, Thanks a million.

> On Mar 22, 2022, at 4:04 PM, Timothy B. Taylor  wrote:
> 
> Try clicking View
> and then Filter By...
> and then Other
> and make sure Show zero total accounts is checked
> and then OK
> 
> Tim
> 
> 
> On Tue, Mar 22, 2022 at 3:24 PM Heide Wang  > wrote:
> Hello,
> 
> I finally got a chance to upgraded my old version of Gnucash to 3 and to 4.9 
> as some of you suggested. Everything looks and works fine. Thank you all. 
> But today when I look for one of my credit card account, Citibank Visa 
> account, I can’t find it. It was a sub-account listed under Liability before. 
> it has zero balance. Can someone tell me where to look and change the 
> setting? Thanks again.
> 
> Heide
> ___
> 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] new subaccounts and updating saved reports

[Adrien Monteleone]

Precisely.

There's no way to know the user didn't intend to keep the new sub 
account out of the report.


Certainly, the assumption should never be made to automatically include it.

The best implementation I can think of would be to check if new accounts 
have been added since report last run, and then ask the user.


But that's expensive code for 'what if'.

I don't think there is a clean solution, but the pain might be lessened 
with an easier custom report system. Unfortunately, that won't be 
possible for some time.


Regards,
Adrien

On 3/22/22 9:00 PM, David T. via gnucash-user wrote:

My experience matches that of George, and I don't see how changing the levels 
could gather a new account into the report.

The issue has been raised before recently, although I couldn't track it down. 
Short of rewriting the report code to re-evaluate the account set every time a 
report is run, I can't see how to fix the problem-- and even then, how would 
gnucash know when a given account should be added to any given report or not?

There are plenty of use cases where a saved report includes a subset of 
accounts on purpose-- for example, when one wants a report that includes 
expenses for an isolated cost area (think rental properties). I might even 
hazard a guess that this would be one of the primary features of saved report 
configurations. The lists here have countless threads advising users to do just 
that. So automatically adding new subaccounts to existing reports could be 
detrimental for many users with saved reports.

That's not to say that I haven't wished for some way to automate this aspect. I 
just don't see how you would implement it.


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