Hello, "John Wiegley" <[email protected]> writes:
>>>>>> "s" == sprock <[email protected]> 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 000001553028 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 000001553028 CIRCLE K # 252",100.54, 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 000001671085 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y65leapczby.fsf%40mun.ca.
