[GNC] Fwd: What's the actual usage of "Default Chargeback Project"?

[BrianHsu]

Found that I sent the reply to gnucash-dev instead of gnucash-user
accidentally. Re-posting here.

Thanks, so the "Job" seems a work in progress feature, and the
"Default Chargeback Project" didn't do anything useful in its current
form?

Also, since I'm reviewing the GnuCash translation of my native
language, I have another question regarding the "Extra Payments" /
"Addition to Card" field when creating an expense voucher.

From what I understand, when this field is filled, it means that some
amount in the expense voucher is actually paid by credit card, even
it's entered as paid by cash.

For example, if I have the following entries in my expense voucher:

Desc  Accounts   Subtotal   Payment
PenExpense:Office Supplies   $30   Cash
Glue   Expense:Office Supplies   $20   Charge

And I set "Addition to Card" to 5, GnuCash will create a split in
A/Payable with $25 (30-5), and another $5 into credit card account ,
which means parts of the "Pen" expense are actually already charged by
credit card.

My question is in what context one will use the "Extra Payments" /
"Addition to Card" instead of just selecting "Charge" in the entries? If
there is an example, it would be really useful to help me understand
the concept here, since the online manual has no information on this
field.

Thanks for the help.

Adrien Monteleone  於 2023年5月14日 週日 上午3:04寫道：
>
> That's a great question. Over the years as I've read threads on this my
> understanding is that 'job for customer A' is *not* the same 'job' as
> 'job for Vendor B' regardless of the name of the job. They are distinct
> data elements.
>
> My other understanding is that the feature was supposed to be for making
> it easier to pass vendor charges on to a customer. (as you're trying to
> do) but the above issue appears to make that not possible.
>
> Perhaps someone who uses this feature can expound.
>
> *note, 'job' is a poor word choice in the UI as it has been more
> accurately described by its creator as a 'purchase order'. I've filed a
> bug on this but no action so far as I'm sure it is low priority.
> Additionally there are limitations on Jobs as they cannot cover more
> than one Vendor or more than one Customer. (so individual line items
> from a single PO from a regular Vendor/supplier can't be charged back to
> different customers - you'd have to artificially split it up to use the
> feature)
>
> As for where Job info is used, there is a limited report that shows
> Vendor charges vs. Customer charges. (Reports > Business > Job Report)
> but at least as of 5.1, that is useless because there is no Option to
> select the Job you want to report on.
>
> Regards,
> Adrien
>
> On 5/13/23 10:25 AM, BrianHsu wrote:
> > Hi,
> >
> > I'm trying to understand of the "Default Chargeback Project" field
> > when creating a bill or an expense voucher from the Business module.
> >
> >  From the online manual
> > (https://www.gnucash.org/docs/v5/C/gnucash-manual/busnss-ap-bills1.html),
> > it I understand it correctly, it should be something like that:
> >
> > 1. I have a "Project XYZ" for "Customer A".
> > 2. I outsourced some programming job of "Project XZY" to "Vendor B"
> > 3. I created a bill for "Vendor B", as they charged me USD $1000
> > 4. In the that bill, I would record that the "Default Chargeback
> > Project" is "Customer A" / "Project XYZ". So I know that this cost is
> > for support that project.
> >
> > If that's the case, I'm wondering where exactly these two field will be 
> > used?
> >
> > It seems that I couldn't find any usage of these two field, except
> > when I create / edit a bill or an expense voucher.
> >
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



--
Best regards,

許洛豪（Brian Hsu）


-- 
Best regards,

許洛豪（Brian Hsu）
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Finance:Quote again [sorry]

[Kalpesh Patel]

So you now at least have the F::Q module for Perl installed that works from GNC 
and that mean you have some ability to download prices.

 

Now comes the tricky and rinse-repeat part—you will have to ascertain by 
experiment which F::Q source provides price for the security of interest. For 
this, go into security definition (via ‘Tools‘ à ‘Security Editor’; get to 
security by clicking the arrow in front of list entry in the ‘Namespace’ column 
which will unfurl all securities defined underneath that name space; double 
click on the one that is of interest to bring up the finer grain definition of 
the security) and at the bottom portion of that security definition you will 
see ‘Quote Source Information’ section. This section defines source from where 
to get the price for that security from. You will now here need to experiment 
to see which source provides prices by selecting different one, then run 
through getting prices process (from ‘Tools’ à ‘Price Database’ à ‘Get Quotes’ 
button) and review whether the price was retrieved or not. If not then change 
the source to different one and run through getting prices process – 
rinse-&-repeat for all security of the interest in this fashion. You can speed 
up this if you are able to navigate around  with scripts. See 
https://wiki.gnucash.org/wiki/Online_Quotes#Command_line_interface (as Geert 
and others have pointed out). Scroll down to ‘gnucash-cli --quotes dump’ 
section slightly further down to utilize that to quickly get to the source that 
has price for the security that interest you. Then you can update the security 
definition in GNC to get prices from that ascertained source going forward.  

 

I deal with US domiciled equities so yahoo_json had (has?!) been great source 
until recently and that is the only one I have dealt with. Each source has its 
own nuances and restriction so of course you will have to learn to stay within 
those bounds and they change over time. For example Alphavantage limits how 
many you can retrieve in one shot using the free method. Given that all these 
sources in F::Q from what I can tell is free ones so your mileage is likely to 
very and change over time.

 

I hope this puts you on to the right path… 

 

From: David Carlson  
Sent: Saturday, May 13, 2023 7:32 AM
To: Graham 
Cc: Kalpesh Patel ; gnucash-user 

Subject: Re: [GNC] Finance:Quote again [sorry]

 

You are not providing enough information.

 

For those stocks, when you set them up, which price source did you select?

 

What do you mean by selecting a stock?

 

On Sat, May 13, 2023 at 6:19 AM Graham mailto:graham.ba...@gmail.com> > wrote:

On 12/05/2023 17:23, Kalpesh Patel wrote:
Thanks Kalpesh - my replies in-line
> That is all tell-tale sign of barfed up path for the env...
>
> Additional steps to debug:
>
> 1 - Launch normal Command Prompt
>
> 2 - Type in following to know which perl binary you are actually executing:
>
>   where perl
>
> --> this should display 'C:\Strawberry\perl\bin\perl.exe'
It did.
>
> 3 - type following at the command prompt (let's validate if the env is setup
> correctly or not):
>
>   perl --version
>
> --> this step should display perl 5, version 28 (your might very in the
> version but should be around '28')
version 32
> 4 - type following at the command prompt (let's validate if the F::Q is
> setup and working correctly):
>
>   perl -MFinance::Quote -e "print $Finance::Quote::VERSION .\"\n\";"
>
> --> this step should display 1.54 (your might be different version)

After turning off antivirus and re-running the installer, it did display 
1.54.

However,on re-starting GNC, and clicking 'get quotes' when i had 
selected AAL.L, it did return yesterday's closing price for AAL, but not 
for anything else. I tried selecting 'LSE' and running 'get quotes' but 
that did nothing. I then tried selecting another single stock and 
running it, but that did nothing either.

Any thoughts?

[Many thanks to everyone who has replied]

-- 
--
Cheerio,

Graham

___
gnucash-user mailing list
gnucash-user@gnucash.org  
To update your subscription preferences or to unsubscribe:
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.



-- 

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issue with Current Assets?

[Don Gray]

> , but if you set Current Assets to a placeholder account, it should be hidden 
> from the selection list when posting invoices to avoid this issue in the 
> future.

Current Assets for should be a place holder account. It was not set to Place 
Holder. It is now set to Place Holder.

I started an invoice and Current Assets does not show in the Income Account 
drop down.

Sincerely,

Don Gray - Exploring Human Systems in Action
+1 (336) 414-4645

‌The greatest discovery of my generation is that a human being can alter his 
life by altering his attitudes of mind.‌
William James
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Issue with Current Assets?

[Adrien Monteleone]

I could be mistaken, but if you set Current Assets to a placeholder 
account, it should be hidden from the selection list when posting 
invoices to avoid this issue in the future.


If that doesn't work, I'd consider it a bug.

Regards,
Adrien

On 5/15/23 12:31 PM, Don Gray wrote:



If it's the former, you might have transactions in Current Assets.


I found two invoices that had the income account set to Current Assets, not the 
actual income account. Unposting, fixing, reposting and then processing the 
payment fixed the “odd” number.

Current Assets now equal Checking Account which is what I would expect.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Issue with Current Assets?

[Stan Brown]

On 2023-05-15 09:57, Adrien Monteleone wrote:
> Alternatively, you might have hidden child accounts. Those will get
> rolled up but aren't individually visible.

If the OP is talking about a report, those child accounts might have
been added after the last time accounts were selected in Report Options.
Whether hidden or not, they would be ignored by the report. I know
you're aware of the following, but it might be helpful to others:

When you select accounts for a report in Report Options and save the
report, Saved Reports remembers the selected accounts along with the
other report options. If you add an account later, you must remember to
reselect accounts for the report and save the new configuration. GnuCash
won't automatically add a new account to the account selection for any
report, even if the new account is a subaccount of an account that is
already in the report along with all of the older subaccounts.

There was a fairly active thread about this some months ago. While
people understood the issue, as I recall no one could think of a
solution that wouldn't create other problems.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issue with Current Assets?

[Don Gray]

> If it's the former, you might have transactions in Current Assets. 

I found two invoices that had the income account set to Current Assets, not the 
actual income account. Unposting, fixing, reposting and then processing the 
payment fixed the “odd” number.

Current Assets now equal Checking Account which is what I would expect.

Sincerely,

Don Gray - Exploring Human Systems in Action
+1 (336) 414-4645

‌A new scientific truth does not triumph by convincing its opponents and making 
them see the light, but rather because its opponents eventually die, and a new 
generation grows up that is familiar with it.‌
Max Planck
‌

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Issue with Current Assets?

[David T. via gnucash-user]

I'll assume that "some number" <> $6,621.66, first. 

Next, is that from the Chart of Accounts, or a report? 

If it's the former, you might have transactions in Current Assets. 

If it's the latter, there may be other accounts beneath Current Assets that 
haven't been selected for display, but which affect a roll up value. 

⁣David T. ​

On May 15, 2023, 7:40 PM, at 7:40 PM, Don Gray  wrote:
>I may have missed something, or maybe got creative with entering data.
>
>My account structure
>
>Assets
>   Accounts Receivable - $ 0.00
>   Current Assets - -$6,621.66
>   Checking Account - $ some number
>   Petty Cash - $0.00
>   Savings Account - $ 0.00
>  
>The $ some number in the checking account is correct as it balances
>with the bank statements.
>
>How is the value in Current Assets computed?
>
>I did a Check & Repair all. It did not change the Current Assets value.
>
>Sincerely,
>
>Don Gray - Exploring Human Systems in Action
>+1 (336) 414-4645
>
>‌No plan survives contact with the enemy.‌
>von Moltke the Elder
>‌
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>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
To update your subscription preferences or to unsubscribe:
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: [GNC] Issue with Current Assets?

[Adrien Monteleone]

Arguably, AR is 'current', but of course, you can organize any way you want.

As to the question, I'm guessing you are looking at the Total column on 
the Accounts tab. (if you see these figures somewhere else, please advise)


That *should* be simply a roll-up total of the child accounts.

An exception would be if that 'Current Assets' parent contains 
transactions, thus it would be the value of itself + sum-of-children. 
(it should instead be an empty placeholder account)


Alternatively, you might have hidden child accounts. Those will get 
rolled up but aren't individually visible.


Regards,
Adrien

On 5/15/23 11:38 AM, Don Gray wrote:

I may have missed something, or maybe got creative with entering data.

My account structure

Assets
Accounts Receivable - $ 0.00
Current Assets - -$6,621.66
Checking Account - $ some number
Petty Cash - $0.00
Savings Account - $ 0.00
   
The $ some number in the checking account is correct as it balances with the bank statements.


How is the value in Current Assets computed?

I did a Check & Repair all. It did not change the Current Assets value.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Issue with Current Assets?

[Don Gray]

I may have missed something, or maybe got creative with entering data.

My account structure

Assets
Accounts Receivable - $ 0.00
Current Assets - -$6,621.66
Checking Account - $ some number
Petty Cash - $0.00
Savings Account - $ 0.00
  
The $ some number in the checking account is correct as it balances with the 
bank statements.

How is the value in Current Assets computed?

I did a Check & Repair all. It did not change the Current Assets value.

Sincerely,

Don Gray - Exploring Human Systems in Action
+1 (336) 414-4645

‌No plan survives contact with the enemy.‌
von Moltke the Elder
‌

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Tax report options

[flywire]

The intention was to highlight the response used accounts, not the built-in
tax report, rather than suggest the tax report should be available to
Australians. I imagine the report allows tax codes to be attached to
accounts and sums all accounts for the same code. I was taught to align
accounts to tax items. I expect the tax code table would need to be user
accessible so users could change it if needed, even if it involved editing
a system table, instead of relying on a maintenance release.

I don't know if it would be feasible, the Australian Taxation Office has
heaps of forms and there are 13 annual returns on
https://www.ato.gov.au/Forms/Consolidated-list-of-approved-forms-by-tax-topic/?anchor=H13#H13
and
more regular forms like the Business Activity Statement. Increasingly the
forms are being replaced by online systems but the data still needs to be
collated.

Others might see it differently. Commercial finance software connects
directly to the tax office demonstrating it is possible.

Regards

>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.