Re: info about action field in double-line view
Jack Slater writes: > my reconciled transactions display a Y not an R??? Correct, Y == YES, it is Reconciled Other values are: C == Cleared N == Neither cleared nor reconciled V == Voided (I think -- not 100% sure of this one) > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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: info about action field in double-line view
Dave, you got me! I didn't look carefully before replying. I too get 'y' as a result of a reconcile! :-) David C On Mon, Jan 29, 2018 at 10:48 PM, Dave H wrote: > My workflow is remarkably similar but my transactions are marked as "y" > when they get reconciled :-) > > I wouldn't mind also being able to flag a transaction as 'p' = pending for > the pending credit card transactions and 's' = scheduled when I have > scheduled a future transaction in online banking but I was told previously > that it's a binary value even though it transitions from 'n' to 'c' to 'y' > in my world !!! > > Cheers Dave H. > > > On 30 January 2018 at 11:36, Buddha Buck wrote: > > > Here's the workflow that I ideally go through. > > > > During the month, I order something online using a credit card. > > > > When I enter the transaction into GnuCash, the split associated with the > > transaction in the credit card account is tagged "n". > > > > The next day, I check my online banking, and I see that the credit card > > company considers the transaction "pending". I leave it tagged as "n". > > The next day, I check again, and now the transaction is charged against > my > > account, and is no longer "pending". I tag the entry in GnuCash as "c", > > cleared. > > > > At the end of the month, I receive my statement, and I run the > > "reconciliation" process in GnuCash. GnuCash automatically cherry-picks > > "cleared" transactions for me, and I look for any discrepancy > (transactions > > that haven't cleared, or transactions on the card I don't have recorded, > > etc). When I am satisfied that all is well, I tell GnuCash that the > > reconciliation is complete, and it marks the reconciled transactions as > > "r". In the future, when you go to reconcile the next month, it won't > > consider the ones already reconciled. > > > > GnuCash also shows multiple balances for an account: a current balance, a > > future balance, a reconciled balance, and a cleared balance. At any given > > time, the "cleared balance" should match match what the online banking > says > > it should be, the "reconciled balance" matches your last statement > balance. > > > > > > On Mon, Jan 29, 2018 at 7:59 PM Mark Hedges > > wrote: > > > > > Thanks all. > > > > > > I don't understand the difference between "cleared" and "reconciled" > > > in Gnucash context. Someone mentioned that one changes R from "n" to > > > "c" when they see the charge in their bank statement or online > > > banking. How is that different in terms of information flow from > > > using the reconciliation feature to do exactly the same thing? I > > > still end up having to cherry-pick individual transactions to make the > > > balance work out. > > > > > > Regarding the Num field, I understand that this would be a check > > > number if anyone paid for much with checks anymore. For checking visa > > > or ACH transactions, am I supposed to record the transaction number > > > from the bank online balance sheet or statement? > > > > > > Thanks. > > > > > > Mark > > > ___ > > > 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 list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: info about action field in double-line view
My workflow is remarkably similar but my transactions are marked as "y" when they get reconciled :-) I wouldn't mind also being able to flag a transaction as 'p' = pending for the pending credit card transactions and 's' = scheduled when I have scheduled a future transaction in online banking but I was told previously that it's a binary value even though it transitions from 'n' to 'c' to 'y' in my world !!! Cheers Dave H. On 30 January 2018 at 11:36, Buddha Buck wrote: > Here's the workflow that I ideally go through. > > During the month, I order something online using a credit card. > > When I enter the transaction into GnuCash, the split associated with the > transaction in the credit card account is tagged "n". > > The next day, I check my online banking, and I see that the credit card > company considers the transaction "pending". I leave it tagged as "n". > The next day, I check again, and now the transaction is charged against my > account, and is no longer "pending". I tag the entry in GnuCash as "c", > cleared. > > At the end of the month, I receive my statement, and I run the > "reconciliation" process in GnuCash. GnuCash automatically cherry-picks > "cleared" transactions for me, and I look for any discrepancy (transactions > that haven't cleared, or transactions on the card I don't have recorded, > etc). When I am satisfied that all is well, I tell GnuCash that the > reconciliation is complete, and it marks the reconciled transactions as > "r". In the future, when you go to reconcile the next month, it won't > consider the ones already reconciled. > > GnuCash also shows multiple balances for an account: a current balance, a > future balance, a reconciled balance, and a cleared balance. At any given > time, the "cleared balance" should match match what the online banking says > it should be, the "reconciled balance" matches your last statement balance. > > > On Mon, Jan 29, 2018 at 7:59 PM Mark Hedges > wrote: > > > Thanks all. > > > > I don't understand the difference between "cleared" and "reconciled" > > in Gnucash context. Someone mentioned that one changes R from "n" to > > "c" when they see the charge in their bank statement or online > > banking. How is that different in terms of information flow from > > using the reconciliation feature to do exactly the same thing? I > > still end up having to cherry-pick individual transactions to make the > > balance work out. > > > > Regarding the Num field, I understand that this would be a check > > number if anyone paid for much with checks anymore. For checking visa > > or ACH transactions, am I supposed to record the transaction number > > from the bank online balance sheet or statement? > > > > Thanks. > > > > Mark > > ___ > > 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: info about action field in double-line view
Here's the workflow that I ideally go through. During the month, I order something online using a credit card. When I enter the transaction into GnuCash, the split associated with the transaction in the credit card account is tagged "n". The next day, I check my online banking, and I see that the credit card company considers the transaction "pending". I leave it tagged as "n". The next day, I check again, and now the transaction is charged against my account, and is no longer "pending". I tag the entry in GnuCash as "c", cleared. At the end of the month, I receive my statement, and I run the "reconciliation" process in GnuCash. GnuCash automatically cherry-picks "cleared" transactions for me, and I look for any discrepancy (transactions that haven't cleared, or transactions on the card I don't have recorded, etc). When I am satisfied that all is well, I tell GnuCash that the reconciliation is complete, and it marks the reconciled transactions as "r". In the future, when you go to reconcile the next month, it won't consider the ones already reconciled. GnuCash also shows multiple balances for an account: a current balance, a future balance, a reconciled balance, and a cleared balance. At any given time, the "cleared balance" should match match what the online banking says it should be, the "reconciled balance" matches your last statement balance. On Mon, Jan 29, 2018 at 7:59 PM Mark Hedges wrote: > Thanks all. > > I don't understand the difference between "cleared" and "reconciled" > in Gnucash context. Someone mentioned that one changes R from "n" to > "c" when they see the charge in their bank statement or online > banking. How is that different in terms of information flow from > using the reconciliation feature to do exactly the same thing? I > still end up having to cherry-pick individual transactions to make the > balance work out. > > Regarding the Num field, I understand that this would be a check > number if anyone paid for much with checks anymore. For checking visa > or ACH transactions, am I supposed to record the transaction number > from the bank online balance sheet or statement? > > Thanks. > > Mark > ___ > 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: info about action field in double-line view
The letter c is applied to transaction splits by GnuCash either when the user imports a transaction from a QIF, OFX or QFX file that was probably downloaded over the Internet from a banking website or manually by clicking in the appropriate box. This is interpreted to mean that the information in that split line of that account register of the data file matches the information from the bank. Arguably, it would probably be better to have separate indicators for these two distinctly different actions. That is not the same as the R applied by GnuCash from a Reconciliation, where the user is verifying that his data records match those from whatever independent source he chooses. Historically, the independent source was the checkbook register, but now it is probably a combination of memory and whatever receipts the user has kept. The R indicator cannot be manually applied to a transaction split line. There is no requirement that the user even consider using these indicators. Many users, myself included, never reconcile income or expenses or any other accounts except bank and investment accounts. As to your cherry-picking to make the balance work out, are you referring to making a reconciliation balance work out? That would be little different than comparing a manually recorded checkbook register to a bank statement. You still need to 'remember' that credit card or debit card purchase that you forgot to record or to notice that there was an unauthorized charge to your account. This is your opportunity to discover fraudulent use of your account. To your last point, the Num field can contain whatever information that you choose to put there, period. David C On Mon, Jan 29, 2018 at 6:56 PM, Mark Hedges wrote: > Thanks all. > > I don't understand the difference between "cleared" and "reconciled" > in Gnucash context. Someone mentioned that one changes R from "n" to > "c" when they see the charge in their bank statement or online > banking. How is that different in terms of information flow from > using the reconciliation feature to do exactly the same thing? I > still end up having to cherry-pick individual transactions to make the > balance work out. > > Regarding the Num field, I understand that this would be a check > number if anyone paid for much with checks anymore. For checking visa > or ACH transactions, am I supposed to record the transaction number > from the bank online balance sheet or statement? > > Thanks. > > Mark > ___ > 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: info about action field in double-line view
An item that is cleared means that your bank has cashed it. An item that is reconciled means that at the end of the month the balance of the bank and your checking account match for all item that have cleared. That is the difference between the two. I hope my explanation is simple enough. Sent from my iPhone > On Jan 29, 2018, at 7:56 PM, Mark Hedges wrote: > > Thanks all. > > I don't understand the difference between "cleared" and "reconciled" > in Gnucash context. Someone mentioned that one changes R from "n" to > "c" when they see the charge in their bank statement or online > banking. How is that different in terms of information flow from > using the reconciliation feature to do exactly the same thing? I > still end up having to cherry-pick individual transactions to make the > balance work out. > > Regarding the Num field, I understand that this would be a check > number if anyone paid for much with checks anymore. For checking visa > or ACH transactions, am I supposed to record the transaction number > from the bank online balance sheet or statement? > > Thanks. > > Mark > ___ > 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: info about action field in double-line view
Thanks all. I don't understand the difference between "cleared" and "reconciled" in Gnucash context. Someone mentioned that one changes R from "n" to "c" when they see the charge in their bank statement or online banking. How is that different in terms of information flow from using the reconciliation feature to do exactly the same thing? I still end up having to cherry-pick individual transactions to make the balance work out. Regarding the Num field, I understand that this would be a check number if anyone paid for much with checks anymore. For checking visa or ACH transactions, am I supposed to record the transaction number from the bank online balance sheet or statement? Thanks. Mark ___ 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: info about action field in double-line view
LOL - OK - got scared I was doing more wrong than right! Thanks. On Fri, Jan 26, 2018 at 10:12 AM, Rich Shepard wrote: > On Fri, 26 Jan 2018, Jack Slater wrote: > > my reconciled transactions display a Y not an R??? >> > > Jack, > > Could be. I was working from memory. > > Rich > ___ > 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: info about action field in double-line view
On Fri, 26 Jan 2018, Jack Slater wrote: my reconciled transactions display a Y not an R??? Jack, Could be. I was working from memory. Rich ___ 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: info about action field in double-line view
my reconciled transactions display a Y not an R??? On Sun, Jan 21, 2018 at 6:49 PM, Rich Shepard wrote: > On Sun, 21 Jan 2018, Mark Hedges wrote: > > It also shows an "Action" field underneath the "Num" field. Where is this >> described in the manual? What is the purpose of the Action field? >> > > Mark, > > Use this for the type of transaction; e.g., payment, refund, transfer. At > least, that's what is entered in that cell in my business checking account. > There might be value for searching for all payments, regardless of method > or > expense account and this cell will allow that. > > On that note what is the purpose of the Num field? To enter check numbers? >> > > I use it for check numbers; both for those I write and for those the > business receives from clients. If you want to assign numbers to cash > dispersements or deposits, this is the place to do so. > > It also has R and A fields. "R" field is automatically filled with "n" for >> each transaction. "A" field is blank. What are these for? >> > > 'R' is for reconciled; not sure what the 'A' represents. When a > transaction appears on a bank's statement click the 'n' (none) and it > converts to 'c' (cleared). When you reconcile the account the signal is > changed to 'r.' > > HTH, > > Rich > ___ > 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: info about action field in double-line view
Geert, Could the install not include a particular required font as a dependency or as part of the installer? Perhaps even better would be to use a GPL licensed icon font, though Iβm not sure if you can specify different fonts for different cells in the register. Doing so would provide a cleaner look regardless of the desktop theme. Maybe the combination of an icon font and mapping the desired symbols to the common unicode tables for them might work. Just a thought. Regards, Adrien > On Jan 25, 2018, at 2:20 AM, Geert Janssens > wrote: > > Op woensdag 24 januari 2018 23:14:29 CET schreef Tommy Trussell: >> Geert: >> >> Maybe the legacy register code cannot handle icons, but instead of using a >> letter such as "F", can it handle Unicode glyphs? >> >> Here are a few of many available glyphs (including example URLs in case >> they get mangled in email): >> >> π paperclip http://graphemica.com/%F0%9F%93%8E >> >> π link symbol http://graphemica.com/%F0%9F%94%97 >> >> π file folder http://graphemica.com/%F0%9F%93%81 >> >> πΎ floppy disk http://graphemica.com/%F0%9F%92%BE >> >> π pushpin http://graphemica.com/%F0%9F%93%8C >> >> βcheck mark http://graphemica.com/%E2%9C%93 >> >> π page with curl http://graphemica.com/%F0%9F%93%83 >> >> π wastebasket http://graphemica.com/%F0%9F%97%91 >> >> β no entry http://graphemica.com/%E2%9B%94 > > Hi Tommy, > > That's a neat idea! I didn't think of this at all. > > Text is rendered by the gtk default rendering code, which appears to handle > unicode glyphs just fine. I have just copy-pasted the paperclip glyph above > in > a register in gnucash 2.6.19 (!) and it is rendered correctly. > > The only reservation I'd have is we don't control the user's > default/preferred > system font. If the chosen font doesn't have the chosen glyphs, the field > would display a "glyph-not-found" character. I have no idea what glyphs the > default fonts on the various platforms we support provide. That would need > some experimentation first. > > Geert > > > ___ > 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: info about action field in double-line view
Op woensdag 24 januari 2018 23:14:29 CET schreef Tommy Trussell: > Geert: > > Maybe the legacy register code cannot handle icons, but instead of using a > letter such as "F", can it handle Unicode glyphs? > > Here are a few of many available glyphs (including example URLs in case > they get mangled in email): > > π paperclip http://graphemica.com/%F0%9F%93%8E > > π link symbol http://graphemica.com/%F0%9F%94%97 > > π file folder http://graphemica.com/%F0%9F%93%81 > > πΎ floppy disk http://graphemica.com/%F0%9F%92%BE > > π pushpin http://graphemica.com/%F0%9F%93%8C > > βcheck mark http://graphemica.com/%E2%9C%93 > > π page with curl http://graphemica.com/%F0%9F%93%83 > > π wastebasket http://graphemica.com/%F0%9F%97%91 > > β no entry http://graphemica.com/%E2%9B%94 Hi Tommy, That's a neat idea! I didn't think of this at all. Text is rendered by the gtk default rendering code, which appears to handle unicode glyphs just fine. I have just copy-pasted the paperclip glyph above in a register in gnucash 2.6.19 (!) and it is rendered correctly. The only reservation I'd have is we don't control the user's default/preferred system font. If the chosen font doesn't have the chosen glyphs, the field would display a "glyph-not-found" character. I have no idea what glyphs the default fonts on the various platforms we support provide. That would need some experimentation first. Geert ___ 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: info about action field in double-line view
On Wed, Jan 24, 2018 at 12:21 PM, Geert Janssens wrote: > I think the file association feature is currently pretty basic, but useful. > > The most common complaints about the initial implementation were > - the lack of an indication of whether a file was associated with it or not > - a way to remove an existing association > > The former has been fixed in 2.6 already, the latter was implemented for > the > upcoming 3.0 release. > > By checking this, I find the option to remove an association hidden too far > away, so it may need another revision in the future. Currently to remove an > existing association one has to select "Associate File with transaction" a > second time. The file dialog that pops up will now have an additional > "Remove" > button to remove the existing association. > > > Future potential improvements I can think of: > - Make removing a file association more visible. > - Show a file icon instead of "F"/"U". While a no-brainer from a usability > point of view it would require huge changes in the current register code, > so > it's unlikely to be implemented anytime soon unfortunately. > Geert: Maybe the legacy register code cannot handle icons, but instead of using a letter such as "F", can it handle Unicode glyphs? Here are a few of many available glyphs (including example URLs in case they get mangled in email): π paperclip http://graphemica.com/%F0%9F%93%8E π link symbol http://graphemica.com/%F0%9F%94%97 π file folder http://graphemica.com/%F0%9F%93%81 πΎ floppy disk http://graphemica.com/%F0%9F%92%BE π pushpin http://graphemica.com/%F0%9F%93%8C βcheck mark http://graphemica.com/%E2%9C%93 π page with curl http://graphemica.com/%F0%9F%93%83 π wastebasket http://graphemica.com/%F0%9F%97%91 β no entry http://graphemica.com/%E2%9B%94 ___ 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: info about action field in double-line view
Op maandag 22 januari 2018 17:30:32 CET schreef David T.: > Geert, > > What is the current status on the File Association feature set? I know that > there was a wave of activity a few years back when the feature was first > added, but I havenβt seen anything about it since. My recollection of the > traffic at the time was that it had potential to be very useful, but that > after the initial basic implementation, additional work to enhance its > utility was lacking. > > As far as I can tell, there is nothing in the documentation about file > associations, either. At the very least, it would be good to have some kind > of state-of-the-feature information put out there somewhere, maybe on the > wiki, if the feature isnβt yet ready for general use. > > David > David, I think the file association feature is currently pretty basic, but useful. The most common complaints about the initial implementation were - the lack of an indication of whether a file was associated with it or not - a way to remove an existing association The former has been fixed in 2.6 already, the latter was implemented for the upcoming 3.0 release. By checking this, I find the option to remove an association hidden too far away, so it may need another revision in the future. Currently to remove an existing association one has to select "Associate File with transaction" a second time. The file dialog that pops up will now have an additional "Remove" button to remove the existing association. Future potential improvements I can think of: - Make removing a file association more visible. - Show a file icon instead of "F"/"U". While a no-brainer from a usability point of view it would require huge changes in the current register code, so it's unlikely to be implemented anytime soon unfortunately. - Provide an option to store a copy of the associated file near the gnucash file. I don't know what the best equivalent would be in case the gnucash data is stored in a database. We may have to store it as a binary blob in that case. The primary use case here would be to prevent the association being moved or deleted from underneath gnucash, or in case of the db backend, to make the association available to all gnucash clients interacting with the db. - Make file associations more universally useful: allow them to be associated with invoices, bills, vendors, customers,... Regards, Geert ___ 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: info about action field in double-line view
On Sun, 21 Jan 2018, Mark Hedges wrote: It also shows an "Action" field underneath the "Num" field. Where is this described in the manual? What is the purpose of the Action field? Mark, Use this for the type of transaction; e.g., payment, refund, transfer. At least, that's what is entered in that cell in my business checking account. There might be value for searching for all payments, regardless of method or expense account and this cell will allow that. On that note what is the purpose of the Num field? To enter check numbers? I use it for check numbers; both for those I write and for those the business receives from clients. If you want to assign numbers to cash dispersements or deposits, this is the place to do so. It also has R and A fields. "R" field is automatically filled with "n" for each transaction. "A" field is blank. What are these for? 'R' is for reconciled; not sure what the 'A' represents. When a transaction appears on a bank's statement click the 'n' (none) and it converts to 'c' (cleared). When you reconcile the account the signal is changed to 'r.' HTH, Rich ___ 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: info about action field in double-line view
Geert, What is the current status on the File Association feature set? I know that there was a wave of activity a few years back when the feature was first added, but I havenβt seen anything about it since. My recollection of the traffic at the time was that it had potential to be very useful, but that after the initial basic implementation, additional work to enhance its utility was lacking. As far as I can tell, there is nothing in the documentation about file associations, either. At the very least, it would be good to have some kind of state-of-the-feature information put out there somewhere, maybe on the wiki, if the feature isnβt yet ready for general use. David > On Jan 22, 2018, at 8:59 PM, Geert Janssens > wrote: > > Op maandag 22 januari 2018 01:03:19 CET schreef Mark Hedges: >> Hi. I view my checking account ledger in Basic Ledger mode. I choose >> View > Double Line View. This opens up the "Notes" line for each >> entry, which is helpful. >> >> It also shows an "Action" field underneath the "Num" field. Where is >> this described in the manual? What is the purpose of the Action >> field? >> >> On that note what is the purpose of the Num field? To enter check numbers? >> >> It also has R and A fields. "R" field is automatically filled with >> "n" for each transaction. "A" field is blank. What are these for? >> > > The "A" column indicates whether a file or url is associated with this > transaction line. "A" hence stands for "Association". It can be empty if > there > is no association, "f" for a file association or "u" for url (I didn't verify > the last one). > > Geert > > > ___ > 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: info about action field in double-line view
Op maandag 22 januari 2018 01:03:19 CET schreef Mark Hedges: > Hi. I view my checking account ledger in Basic Ledger mode. I choose > View > Double Line View. This opens up the "Notes" line for each > entry, which is helpful. > > It also shows an "Action" field underneath the "Num" field. Where is > this described in the manual? What is the purpose of the Action > field? > > On that note what is the purpose of the Num field? To enter check numbers? > > It also has R and A fields. "R" field is automatically filled with > "n" for each transaction. "A" field is blank. What are these for? > The "A" column indicates whether a file or url is associated with this transaction line. "A" hence stands for "Association". It can be empty if there is no association, "f" for a file association or "u" for url (I didn't verify the last one). Geert ___ 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: info about action field in double-line view
The num field[*] is for the check number or other accounting document.Β (In a business situation, you always need to have some unique identifier between accounting entries and the physical or electronic documents that justify them in case of control (=audit). [*] I say this because it makes sense in the context of accounting, not because I actually know what was in the developers' minds when they implemented it. Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 https://www.p27.eu/jeff/ purple.com -> p27.eu On 22/01/18 03:11, Dave H wrote: Yes, if you use the Reconcile process it puts the "R" in for you :-) Cheers Dave. On 22 January 2018 at 11:47, Mark Hedges wrote: Oh so I should use the R column for checking against the bank web site or statement, instead of putting a checkmark in the notes column like I have been :-) Still not sure what 'Action' is supposed to describe on an entry that is not split, or even what it means on a split item, but thanks for the reference. Mark -- Mark Hedges CEO Weird Vibe Inc. +1-310-487-7123 https://weirdvibe.media On Sun, Jan 21, 2018 at 6:54 PM, Dave H wrote: Try clicking in the Action field - it displays a drop down for transaction type etdc. R = Reconciled and has values of N (New ?) / C = Cleared / R = Reconciled. A dunno I only ever use "Basic Ledger" view :-) Check out https://code.gnucash.org/docs/C/gnucash-guide/txns- registers1.html for a bit more detail... Cheers Dave H. On 22 January 2018 at 10:03, Mark Hedges wrote: Hi. I view my checking account ledger in Basic Ledger mode. I choose View > Double Line View. This opens up the "Notes" line for each entry, which is helpful. It also shows an "Action" field underneath the "Num" field. Where is this described in the manual? What is the purpose of the Action field? On that note what is the purpose of the Num field? To enter check numbers? It also has R and A fields. "R" field is automatically filled with "n" for each transaction. "A" field is blank. What are these for? Thanks. Mark -- Mark Hedges CEO Weird Vibe Inc. +1-310-487-7123 https://weirdvibe.media ___ 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. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 https://www.p27.eu/jeff/ purple.com -> p27.eu ___ 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: info about action field in double-line view
Yes, if you use the Reconcile process it puts the "R" in for you :-) Cheers Dave. On 22 January 2018 at 11:47, Mark Hedges wrote: > Oh so I should use the R column for checking against the bank web site > or statement, instead of putting a checkmark in the notes column like > I have been :-) > > Still not sure what 'Action' is supposed to describe on an entry that > is not split, or even what it means on a split item, but thanks for > the reference. > > Mark > -- > Mark Hedges > CEO Weird Vibe Inc. > +1-310-487-7123 > https://weirdvibe.media > > > > On Sun, Jan 21, 2018 at 6:54 PM, Dave H wrote: > > Try clicking in the Action field - it displays a drop down for > transaction > > type etdc. > > > > R = Reconciled and has values of N (New ?) / C = Cleared / R = > Reconciled. > > > > A dunno I only ever use "Basic Ledger" view :-) > > > > Check out https://code.gnucash.org/docs/C/gnucash-guide/txns- > registers1.html > > for a bit more detail... > > > > Cheers Dave H. > > > > > > On 22 January 2018 at 10:03, Mark Hedges > wrote: > >> > >> Hi. I view my checking account ledger in Basic Ledger mode. I choose > >> View > Double Line View. This opens up the "Notes" line for each > >> entry, which is helpful. > >> > >> It also shows an "Action" field underneath the "Num" field. Where is > >> this described in the manual? What is the purpose of the Action > >> field? > >> > >> On that note what is the purpose of the Num field? To enter check > >> numbers? > >> > >> It also has R and A fields. "R" field is automatically filled with > >> "n" for each transaction. "A" field is blank. What are these for? > >> > >> Thanks. > >> Mark > >> > >> -- > >> Mark Hedges > >> CEO Weird Vibe Inc. > >> +1-310-487-7123 > >> https://weirdvibe.media > >> ___ > >> 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: info about action field in double-line view
Oh so I should use the R column for checking against the bank web site or statement, instead of putting a checkmark in the notes column like I have been :-) Still not sure what 'Action' is supposed to describe on an entry that is not split, or even what it means on a split item, but thanks for the reference. Mark -- Mark Hedges CEO Weird Vibe Inc. +1-310-487-7123 https://weirdvibe.media On Sun, Jan 21, 2018 at 6:54 PM, Dave H wrote: > Try clicking in the Action field - it displays a drop down for transaction > type etdc. > > R = Reconciled and has values of N (New ?) / C = Cleared / R = Reconciled. > > A dunno I only ever use "Basic Ledger" view :-) > > Check out https://code.gnucash.org/docs/C/gnucash-guide/txns-registers1.html > for a bit more detail... > > Cheers Dave H. > > > On 22 January 2018 at 10:03, Mark Hedges wrote: >> >> Hi. I view my checking account ledger in Basic Ledger mode. I choose >> View > Double Line View. This opens up the "Notes" line for each >> entry, which is helpful. >> >> It also shows an "Action" field underneath the "Num" field. Where is >> this described in the manual? What is the purpose of the Action >> field? >> >> On that note what is the purpose of the Num field? To enter check >> numbers? >> >> It also has R and A fields. "R" field is automatically filled with >> "n" for each transaction. "A" field is blank. What are these for? >> >> Thanks. >> Mark >> >> -- >> Mark Hedges >> CEO Weird Vibe Inc. >> +1-310-487-7123 >> https://weirdvibe.media >> ___ >> 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: info about action field in double-line view
Try clicking in the Action field - it displays a drop down for transaction type etdc. R = Reconciled and has values of N (New ?) / C = Cleared / R = Reconciled. A dunno I only ever use "Basic Ledger" view :-) Check out https://code.gnucash.org/docs/C/gnucash-guide/txns-registers1.html for a bit more detail... Cheers Dave H. On 22 January 2018 at 10:03, Mark Hedges wrote: > Hi. I view my checking account ledger in Basic Ledger mode. I choose > View > Double Line View. This opens up the "Notes" line for each > entry, which is helpful. > > It also shows an "Action" field underneath the "Num" field. Where is > this described in the manual? What is the purpose of the Action > field? > > On that note what is the purpose of the Num field? To enter check numbers? > > It also has R and A fields. "R" field is automatically filled with > "n" for each transaction. "A" field is blank. What are these for? > > Thanks. > Mark > > -- > Mark Hedges > CEO Weird Vibe Inc. > +1-310-487-7123 > https://weirdvibe.media > ___ > 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.