[GNC] Bill - Book Item lines to different Customers.
OP, Have you looked at other software? Next you'll be looking for Bug 113772 - Add categories for more reporting flexibility, https://bugs.gnucash.org/show_bug.cgi?id=113772 . ___ 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 import QIF issue
When Gnucash crashes during an import the first thing to suspect is bad data in the import file. GnuCash is very picky about date format and will crash if the date format in the import file doesn't match. Next, it is well known that Quicken data does not always import cleanly, so it may help to start by importing a small chunk of data first into a disposable test Gnucash data file. Good luck. On Mon, Jan 10, 2022, 5:45 PM wrote: > Trace files were just where the URL > https://wiki.gnucash.org/wiki/Tracefile said they would be. The > datestamp is from the time I tried to import the QIF. > > Pity, I hoped all the 'errors' and 'warns' in the files would help. > > I will look at doing the stack_trace file tomorrow. > > Robert Nock > 01600 580807 > > > -Original Message- > From: Jean Laroche [mailto:rip...@gmail.com] > Sent: 10 January 2022 23:28 > To: subscr...@nock.org.uk > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Gnucash import QIF issue > > How did you create these traces? > > They don't seem to indicate a crash. Did you get them right after the > crash happened? > > Jean > > On 1/10/22 2:22 PM, subscr...@nock.org.uk wrote: > > Thanks very much for your quick response and assistance. > > > > Tracefiles attached and hopefully these will help. > > > > Bearing in mind what it says about the difficulty in getting the > Stack_Trace > > files I hope this will do but if you do need more then I will get them to > > you once you let me know. > > > > Using latest version of Gnucash downloaded this morning i.e. 4.9 on > Windows > > 10 Home with all updates 19043.1415 > > > > RAM 32GB > > Processor Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz 3.50 GHz > > > > Robert Nock > > 01600 580807 > > > > -Original Message- > > From: gnucash-user > > [mailto:gnucash-user-bounces+subscribe=nock.org...@gnucash.org] On > Behalf Of > > Jean L > > Sent: 10 January 2022 16:52 > > To: gnucash-user@gnucash.org > > Subject: Re: [GNC] Gnucash import QIF issue > > > > Can you do a bit of debugging? > > https://wiki.gnucash.org/wiki/Stack_Trace > > https://wiki.gnucash.org/wiki/Tracefile > > That way we can get a chance to see where the crash happens. Another > > option is to send your qif file to one of us for us to repro the issue, > > but that's probably not something you want to do for privacy reasons. > > > > Jean > > > > > > On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote: > >> I am trying to import a QIF file from Quicken XG 2004 for the UK. > >> > >> > >> > >> Loading the file etc seems to be fine and I can get through all the > option > >> windows. It. > >> > >> > >> > >> The import starts OK and gets about half way (having taken many minutes > as > >> the QIF file is 11MB with transactions back decades) and then just > closes > >> leaving no Gnucash window. > >> > >> > >> > >> Restarting Gnucash just takes me back to the beginning option to import > a > >> file etc. > >> > >> > >> > >> Have tried twice and both times with same result though I have not > > actually > >> seen the moment the window closes. > >> > >> > >> > >> Any ideas? What can I do to work out what the problem is? > >> > >> > >> > >> Thanks a lot, > >> > >> > >> > >> Bob > >> > >> ___ > >> 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. > ___ 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
Re: [GNC] Bill - Book Item lines to different Customers.
Hi, On Mon, January 10, 2022 6:22 pm, Michael or Penny Novack wrote: > > > >> Exactly.. So you don't know how the features work. > And that might actually be an advantage >> GnuCash has a chargeback feature that allows you to select items from a >> vendor bill and automatically charge them back to a customer. Selected >> line-items from the bill to auto-populate into the invoice(s) for that >> customer (until you select them to apply to a specific invoice). >> >> This works great if there is a 1:1 mapping of vendor bill -> customer, >> because you can only assign a SINGLE Customer to the Bill. > > Ah yes, but how did we get to this single bill? Where did this bill get > separate lines? > > In other words, let's change this slightly. The farrier comes to my > stable and shoes three horses, my horse and the horses of two of my > customers << I am boarding horses >>. The farrier didn't give me an > invoice with separate lines for horse a, horse b, and horse c. She gave > me an invoice with a single line; shoed three horses, $X That was not my reading from the OP -- my reading is that the farrier left an invoice with three line items, one for horse A, one for B, and one for C. > In other words, it looks to me that what is described below comes from > MY creating a bill with those separated into separate lines and I > suppose the objection about what is lacking is the ability to do that > rather than merging three separate bills. > > And the example we are working with is simple (I mean the invoice from > the vendor). It could be far more complex, have "lines", but those not > corresponding to a customer. Thus from the vendor an invoice for: > > 12 type A widgets @$10 $120 > > 8 type B widgets @$5 $40 > > 3 type C widgets @&17 $51 > > -- > > $211 > > NOW --- of these, 4 of the type A widgets are to be charged back to > customer #1 and 5 to customer #2 and 3 to inventory > > 6 of the type B widgets are to be > charged back to customer #1 and 2 to customer #2 > > 2 of the type C widgets are to be > charged back to customer #1 and one to inventory > > So obviously I'd have to be doing the breaking up, into lines if not > separate bills.. BUT don't I also want to wend up with something that > bears some resemblance to what arrived? In other words, if this WERE > done as three bills that were then merged into a "vendor job" what does > that look like? It looks like three vendor bills, one to "Ferrier Job " with a line-item of "Shod Horse A", one with a line-item of B, and one with a line-item of C. The only benefit of using a Job is to tie the bills together by something *other* that the post date and the Ferrier vendor. > Michael D Novack > -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] Gnucash import QIF issue
Trace files were just where the URL https://wiki.gnucash.org/wiki/Tracefile said they would be. The datestamp is from the time I tried to import the QIF. Pity, I hoped all the 'errors' and 'warns' in the files would help. I will look at doing the stack_trace file tomorrow. Robert Nock 01600 580807 -Original Message- From: Jean Laroche [mailto:rip...@gmail.com] Sent: 10 January 2022 23:28 To: subscr...@nock.org.uk Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Gnucash import QIF issue How did you create these traces? They don't seem to indicate a crash. Did you get them right after the crash happened? Jean On 1/10/22 2:22 PM, subscr...@nock.org.uk wrote: > Thanks very much for your quick response and assistance. > > Tracefiles attached and hopefully these will help. > > Bearing in mind what it says about the difficulty in getting the Stack_Trace > files I hope this will do but if you do need more then I will get them to > you once you let me know. > > Using latest version of Gnucash downloaded this morning i.e. 4.9 on Windows > 10 Home with all updates 19043.1415 > > RAM 32GB > Processor Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz 3.50 GHz > > Robert Nock > 01600 580807 > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+subscribe=nock.org...@gnucash.org] On Behalf Of > Jean L > Sent: 10 January 2022 16:52 > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Gnucash import QIF issue > > Can you do a bit of debugging? > https://wiki.gnucash.org/wiki/Stack_Trace > https://wiki.gnucash.org/wiki/Tracefile > That way we can get a chance to see where the crash happens. Another > option is to send your qif file to one of us for us to repro the issue, > but that's probably not something you want to do for privacy reasons. > > Jean > > > On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote: >> I am trying to import a QIF file from Quicken XG 2004 for the UK. >> >> >> >> Loading the file etc seems to be fine and I can get through all the option >> windows. It. >> >> >> >> The import starts OK and gets about half way (having taken many minutes as >> the QIF file is 11MB with transactions back decades) and then just closes >> leaving no Gnucash window. >> >> >> >> Restarting Gnucash just takes me back to the beginning option to import a >> file etc. >> >> >> >> Have tried twice and both times with same result though I have not > actually >> seen the moment the window closes. >> >> >> >> Any ideas? What can I do to work out what the problem is? >> >> >> >> Thanks a lot, >> >> >> >> Bob >> >> ___ >> 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] Gnucash import QIF issue
How did you create these traces? They don't seem to indicate a crash. Did you get them right after the crash happened? Jean On 1/10/22 2:22 PM, subscr...@nock.org.uk wrote: Thanks very much for your quick response and assistance. Tracefiles attached and hopefully these will help. Bearing in mind what it says about the difficulty in getting the Stack_Trace files I hope this will do but if you do need more then I will get them to you once you let me know. Using latest version of Gnucash downloaded this morning i.e. 4.9 on Windows 10 Home with all updates 19043.1415 RAM 32GB Processor Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz 3.50 GHz Robert Nock 01600 580807 -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+subscribe=nock.org...@gnucash.org] On Behalf Of Jean L Sent: 10 January 2022 16:52 To: gnucash-user@gnucash.org Subject: Re: [GNC] Gnucash import QIF issue Can you do a bit of debugging? https://wiki.gnucash.org/wiki/Stack_Trace https://wiki.gnucash.org/wiki/Tracefile That way we can get a chance to see where the crash happens. Another option is to send your qif file to one of us for us to repro the issue, but that's probably not something you want to do for privacy reasons. Jean On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote: I am trying to import a QIF file from Quicken XG 2004 for the UK. Loading the file etc seems to be fine and I can get through all the option windows. It. The import starts OK and gets about half way (having taken many minutes as the QIF file is 11MB with transactions back decades) and then just closes leaving no Gnucash window. Restarting Gnucash just takes me back to the beginning option to import a file etc. Have tried twice and both times with same result though I have not actually seen the moment the window closes. Any ideas? What can I do to work out what the problem is? Thanks a lot, Bob ___ 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] Bill - Book Item lines to different Customers.
Exactly.. So you don't know how the features work. And that might actually be an advantage GnuCash has a chargeback feature that allows you to select items from a vendor bill and automatically charge them back to a customer. Selected line-items from the bill to auto-populate into the invoice(s) for that customer (until you select them to apply to a specific invoice). This works great if there is a 1:1 mapping of vendor bill -> customer, because you can only assign a SINGLE Customer to the Bill. Ah yes, but how did we get to this single bill? Where did this bill get separate lines? In other words, let's change this slightly. The farrier comes to my stable and shoes three horses, my horse and the horses of two of my customers << I am boarding horses >>. The farrier didn't give me an invoice with separate lines for horse a, horse b, and horse c. She gave me an invoice with a single line; shoed three horses, $X In other words, it looks to me that what is described below comes from MY creating a bill with those separated into separate lines and I suppose the objection about what is lacking is the ability to do that rather than merging three separate bills. And the example we are working with is simple (I mean the invoice from the vendor). It could be far more complex, have "lines", but those not corresponding to a customer. Thus from the vendor an invoice for: 12 type A widgets @$10 $120 8 type B widgets @$5 $40 3 type C widgets @&17 $51 -- $211 NOW --- of these, 4 of the type A widgets are to be charged back to customer #1 and 5 to customer #2 and 3 to inventory 6 of the type B widgets are to be charged back to customer #1 and 2 to customer #2 2 of the type C widgets are to be charged back to customer #1 and one to inventory So obviously I'd have to be doing the breaking up, into lines if not separate bills.. BUT don't I also want to wend up with something that bears some resemblance to what arrived? In other words, if this WERE done as three bills that were then merged into a "vendor job" what does that look like? Michael D Novack Unfortunately GnuCash does not currently support mapping individual line-items to different customers. And that's the crux of the question. SO.. The only way to do it within the confines of what GnuCash currently does, unfortunately, would be to enter three individual bills (one for each customer) -- but then you can "merge" them into a single "Vendor Job" and you can pay them all at once via Process Payment. Each vendor bill would allow you to charge-back to a different customer. As I posted in my initial response -- this has been an outstanding issue since 2002. Thanks, Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ 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 import QIF issue
Thanks very much for your quick response and assistance. Tracefiles attached and hopefully these will help. Bearing in mind what it says about the difficulty in getting the Stack_Trace files I hope this will do but if you do need more then I will get them to you once you let me know. Using latest version of Gnucash downloaded this morning i.e. 4.9 on Windows 10 Home with all updates 19043.1415 RAM 32GB Processor Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz 3.50 GHz Robert Nock 01600 580807 -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+subscribe=nock.org...@gnucash.org] On Behalf Of Jean L Sent: 10 January 2022 16:52 To: gnucash-user@gnucash.org Subject: Re: [GNC] Gnucash import QIF issue Can you do a bit of debugging? https://wiki.gnucash.org/wiki/Stack_Trace https://wiki.gnucash.org/wiki/Tracefile That way we can get a chance to see where the crash happens. Another option is to send your qif file to one of us for us to repro the issue, but that's probably not something you want to do for privacy reasons. Jean On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote: > I am trying to import a QIF file from Quicken XG 2004 for the UK. > > > > Loading the file etc seems to be fine and I can get through all the option > windows. It. > > > > The import starts OK and gets about half way (having taken many minutes as > the QIF file is 11MB with transactions back decades) and then just closes > leaving no Gnucash window. > > > > Restarting Gnucash just takes me back to the beginning option to import a > file etc. > > > > Have tried twice and both times with same result though I have not actually > seen the moment the window closes. > > > > Any ideas? What can I do to work out what the problem is? > > > > Thanks a lot, > > > > Bob > > ___ > 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.trace.735UF1.log Description: Binary data gnucash.trace.HXODF1.log Description: Binary data gnucash.trace.5QTSF1.log Description: Binary data ___ 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 import QIF issue
Also, can you tell us which version you're using, and which OS? On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote: I am trying to import a QIF file from Quicken XG 2004 for the UK. Loading the file etc seems to be fine and I can get through all the option windows. It. The import starts OK and gets about half way (having taken many minutes as the QIF file is 11MB with transactions back decades) and then just closes leaving no Gnucash window. Restarting Gnucash just takes me back to the beginning option to import a file etc. Have tried twice and both times with same result though I have not actually seen the moment the window closes. Any ideas? What can I do to work out what the problem is? Thanks a lot, Bob ___ 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 import QIF issue
Can you do a bit of debugging? https://wiki.gnucash.org/wiki/Stack_Trace https://wiki.gnucash.org/wiki/Tracefile That way we can get a chance to see where the crash happens. Another option is to send your qif file to one of us for us to repro the issue, but that's probably not something you want to do for privacy reasons. Jean On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote: I am trying to import a QIF file from Quicken XG 2004 for the UK. Loading the file etc seems to be fine and I can get through all the option windows. It. The import starts OK and gets about half way (having taken many minutes as the QIF file is 11MB with transactions back decades) and then just closes leaving no Gnucash window. Restarting Gnucash just takes me back to the beginning option to import a file etc. Have tried twice and both times with same result though I have not actually seen the moment the window closes. Any ideas? What can I do to work out what the problem is? Thanks a lot, Bob ___ 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] Bill - Book Item lines to different Customers.
Michael, On Mon, January 10, 2022 11:33 am, Michael or Penny Novack wrote: > On 1/10/2022 1:49 AM, Allan Belcher wrote: > a) How are you accounting for things that will (eventually) get invoiced > to each horse owner. In other words, you don't yet have all the things > that will be going onto the invoice. This is irrelevant to the OP's question. > b) You are asking about multiple owners horse's on the bill to the > farrier, but suppose there were only one? Yes. The farrier comes and shoes three horses and gives a single (vendor) bill. But that single bill needs to be split amongst three customers. GnuCash does not currently support that. > c) Suppose you were dealing with a bill for a vendor that included items > that were not all in the same expense account (fell into different > expense categories in your CoA) That is irrelevant here. > Folks, since I do not use the business features, I can't test this Exactly.. So you don't know how the features work. I would recommend you take a back seat here, because you don't know how to features work in GnuCash. While you are amazing at getting users to actually say what they are trying to do and get to the basic accounting issues at hand, I'm afraid in THIS particular case you're just confusing the issue. GnuCash has a chargeback feature that allows you to select items from a vendor bill and automatically charge them back to a customer. Selected line-items from the bill to auto-populate into the invoice(s) for that customer (until you select them to apply to a specific invoice). This works great if there is a 1:1 mapping of vendor bill -> customer, because you can only assign a SINGLE Customer to the Bill. Unfortunately GnuCash does not currently support mapping individual line-items to different customers. And that's the crux of the question. SO.. The only way to do it within the confines of what GnuCash currently does, unfortunately, would be to enter three individual bills (one for each customer) -- but then you can "merge" them into a single "Vendor Job" and you can pay them all at once via Process Payment. Each vendor bill would allow you to charge-back to a different customer. As I posted in my initial response -- this has been an outstanding issue since 2002. Thanks, > 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] Bill - Book Item lines to different Customers.
On 1/10/2022 1:49 AM, Allan Belcher wrote: OK actual reason. Horse Agistment business. The farrier comes and reshoes 3 horses, each belonging to a different person. The farrier gives me 1 bill for the complete job. When I enter the bill I want to be able to enter 3 lines, each for "reshoing of horse" and allocate each line to a different owner. That explains it well, and is actually close to my "guess". So continue describing: a) How are you accounting for things that will (eventually) get invoiced to each horse owner. In other words, you don't yet have all the things that will be going onto the invoice. b) You are asking about multiple owners horse's on the bill to the farrier, but suppose there were only one? c) Suppose you were dealing with a bill for a vendor that included items that were not all in the same expense account (fell into different expense categories in your CoA) Folks, since I do not use the business features, I can't test this myself, so the question is about invoices in both directions. Now one side of those is a debit to "receivables" or a credit to "payables". When the invoice is receivable, I assume you can split the credit side among different "income" accounts but could that also include a credit to an "expense" account? (that's the reduction of an expense). And of course in the other direction when an invoice is payable, the debit side can obviously be a split between accounts of type "expense" but would gnucash also allow account type "income" << that's a reduction of income >> 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.
[GNC] Gnucash import QIF issue
I am trying to import a QIF file from Quicken XG 2004 for the UK. Loading the file etc seems to be fine and I can get through all the option windows. It. The import starts OK and gets about half way (having taken many minutes as the QIF file is 11MB with transactions back decades) and then just closes leaving no Gnucash window. Restarting Gnucash just takes me back to the beginning option to import a file etc. Have tried twice and both times with same result though I have not actually seen the moment the window closes. Any ideas? What can I do to work out what the problem is? Thanks a lot, Bob ___ 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] problem with a transaction involving 3 securities
Hi, I'm trying out something that until now I didn't try, and that's buying a stock from a broker that handles FX itself "silently" at the time of the transaction (normally for my USD purchases I use an account in USD). I have liquidity account in EUR, and the stock is in USD. So what I attempted is this (seen from the security register, that is in USD): A:Investments:BrokerA:USD:RUSG 2358.28 716.56 A:Investments:BrokerA:Liquidity -634.14 Expenses:Fees:BrokerA0.50 A:Investments:BrokerA:Liquidity -0.50 Trading:CURRENCY:EUR 634.14 Trading:CURRENCY:USD 716.56 Inbalance-USD 716.46 Trading:LSE:RUSG.L -2358.28 716.46 I must add that the Trading:* slices were added automatically. I'm pretty lost on how to balance this transation, after trying a variety of alternatives. My original approach was to add a bunch of Trading: slices (e.g. show the EUR→USD,USD→RUSG.L in a total of 4 Trading: slices, basically turning that Inbalance-USD into Trading:CURRENCY:USD), but it looks like gnucash doesn't let me to have multiple Trading:CURRENCY:USD slices in the same transaction. The only way I found to make this work, is to add a "USD liquidity" account, exchange the EUR for USD there, and from there to buy the shares, but that would split the transactions in two making it a bit less easy to follow what happened. FTR, my broker shows it like this: description fx rate change total Buy 2 RUSG @ 358.28 USD $-716.56$-716.56 Fees €-0.50€ Withdrawal FX €-634.14€ Credit FX 1.13 $716.56$0.00 Do you have an idea on to best record this transaction in gnucash? :) -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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.
