Re: Make "reg" output the account balance
How about: ledger reg --daily It doesn't quite do what you want but I think it's the best there is for now. -- Martin Michlmayr https://www.cyrius.com/ -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/20231122234157.GA2819100%40jirafa.cyrius.com.
Re: Error: Only one posting with null amount allowed per transaction
"John Wiegley" writes: >> "RM" == Roger Mason writes: > > RM> I don't know what information you need but this is the top few lines of > RM> the CSV file: > > RM> date,description,debit,credit > RM> 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K > # 252",100.54, > RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS > #590,3.00, > RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA > #1440,50.60, > > When I create a file containing these lines, and run “ledger convert” on it, > it outputs the following: > > Vulcan ~/dl $ ledger convert foo.dat If I run 'ledger convert foo.csv' the response is: Error: No journal file was specified (please use -f) so I run: ledger convert foo.csv -f my.ledger and get the error above. If I run: ledger convert foo.csv -f ./my.ledger I get: Error: Cannot read journal file "/usr/home/rmason/Personal/Finances/PlainText/foo.csv" Thanks again, Roger -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y655y1t1mor.fsf%40mun.ca.
Re: Error: Only one posting with null amount allowed per transaction
> "RM" == Roger Mason writes: RM> I don't know what information you need but this is the top few lines of RM> the CSV file: RM> date,description,debit,credit RM> 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K # 252",100.54, RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS #590,3.00, RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA #1440,50.60, When I create a file containing these lines, and run “ledger convert” on it, it outputs the following: Vulcan ~/dl $ ledger convert foo.dat 2023/11/20 * Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K # 252 Expenses:Unknown$-100.54 Equity:Unknown 2023/11/20 * Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS #590 Expenses:Unknown $-3.00 Equity:Unknown 2023/11/20 * Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA #1440 Expenses:Unknown $-50.60 Equity:Unknown Is there anything more I need to reproduce the error? John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2v89tfq8b.fsf%40newartisans.com.
Re: Error: Only one posting with null amount allowed per transaction
Hello, "John Wiegley" writes: >> "s" == sprock writes: > > s> I'm getting this error: > > s> While parsing file "/usr/home/sprock/Personal/Finances/ledger.csv", line 1: > s> While parsing CSV line: 2023-11-20,Point of Sale - Interac RETAIL > s> PURCHASE 01553028 CIRCLE K # 252,100.54, > > s> Error: Only one posting with null amount allowed per transaction > > s> using this command line: > s> ledger convert ledger.csv --input-date-format "%Y-%m-%d" -f my.ledger > > The convert sub-command does quite a bit of work, so it’s hard to say exactly > what’s going wrong in this scenario from the information provided. > > John Thanks for your reply. I don't know what information you need but this is the top few lines of the CSV file: date,description,debit,credit 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K # 252",100.54, 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS #590,3.00, 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA #1440,50.60, The failure occurs at line 1. The target journal (my.ledger) exists but is empty. I have also tried the convert command with my.ledger containing this: 2023-01-01 Opening Balance Assets:Checking 342.63 Equity:Opening Balances and getting the same error. I am using ledger-3.2.1 on FreeBSD 12.4. Please let me know if you need further information. Thanks, Roger -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y65leapczby.fsf%40mun.ca.
Re: Make "reg" output the account balance
> Ondřej Čertík writes: >> Does something like `--display-total account.total` help? > It doesn't seem to show the correct totals. Consider: Hmm… this doesn’t seem like something that the ‘reg’ report will ever be able to do, since it’s designed around a running total that reflects the direct summation of the amounts displayed. What you want is almost like a running-form version of the balance report. I don’t think Ledger has anything like this built in. John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2h6ldegxl.fsf%40newartisans.com.
Re: Error: Only one posting with null amount allowed per transaction
> "s" == sprock writes: s> I'm getting this error: s> While parsing file "/usr/home/sprock/Personal/Finances/ledger.csv", line 1: s> While parsing CSV line: 2023-11-20,Point of Sale - Interac RETAIL s> PURCHASE 01553028 CIRCLE K # 252,100.54, s> Error: Only one posting with null amount allowed per transaction s> using this command line: s> ledger convert ledger.csv --input-date-format "%Y-%m-%d" -f my.ledger The convert sub-command does quite a bit of work, so it’s hard to say exactly what’s going wrong in this scenario from the information provided. John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2leapegzv.fsf%40newartisans.com.