> On 27 Aug 2019, at 16:10, Adrien Monteleone <[email protected]> > wrote: > > You can also import invoices. So if you find the duplication-post workflow > tedious, you could set up a spreadsheet with the invoice data ready to > import. Then each dinner, edit the amounts, export from spreadsheet to CSV, > import the CSV into GnuCash. For the next dinner, bring up the spreadsheet > again, edit the amounts, rinse-repeat.
Having a quick look at this option, exported some invoices, edited them (to change Customer’s name, which had appeared in the Description column) and tried to import, but nothing came up in the Preview apart from the headers. I think this may be something to do with the UTF-8 problem I’ve recently come across with imports of names with acute accents in them. This time it’s the pound sign (“£”) that is the cause of trouble - if I change it to a dollar-sign the preview comes up OK but the import still fails, on the basis that there is no such customer. Documentation on the export/import procedure for invoices is scant and hard to find. Nonetheless, his sounds like a promising approach to what would be a tedious process if done by hand. Thanks, Adrien, you’ve been a great help! Michael > > If the amount(s) that need to be edited are the same for each member, you > could either have a master sheet where you chance just those numbers and they > get pulled to the ‘invoice’ sheet, or else just do a Find/Replace if it is > that simple. > > Regards, > Adrien > >> On Aug 27, 2019 w35d239, at 5:30 AM, Michael Hendry >> <[email protected]> wrote: >> >> Unfortunately, there doesn’t seem to be a way of creating regularly repeated >> invoices as Scheduled Transactions, but I’m currently thinking along the >> lines of creating an invoice for each member for the default amounts at the >> beginning of the year, and then duplicating these invoices, one for each >> member for each meeting. After each meeting, I would edit each invoice if >> necessary (to deal with absences and variations in contributions) then post >> and pay them. >> >> This way the Destination accounts don’t need children and the annual Gift >> Aid Report can be populated from Customer Reports. >> >> I’ll do some experiments… >> >> Michael > > _______________________________________________ > gnucash-user mailing list > [email protected] > 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. _______________________________________________ gnucash-user mailing list [email protected] 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.
