Hi,
I just converted from vanilla SQL Ledger to the Ledger123 version and I'm
doing my first invoices.
I open an old invoice, updated the relevant information, and hit Post as New
and I got this:
DBD::Pg::db do failed: ERROR: column "transdate" of relation
"invoice" does not exist
LINE 9: transdate = '02-28-2011',
^ at SL/IS.pm line 1020.
Content-Type: text/html
<head>
<title>Edit Sales Invoice - SQL-Ledger Version 2.8.33 - Ian Durey -
method_finance</title>
<META NAME="robots" CONTENT="noindex,nofollow" />
<LINK REL="stylesheet" HREF="css/sql-ledger-blue.css"
TYPE="text/css" TITLE="SQL-Ledger stylesheet">
</head>
<body><h2 class=error>Error!</h2>
<p><b>UPDATE invoice SET<br> description = 'My Awesome
Service',<br> qty = 1,<br> sellprice = 500,<br>
fxsellprice = 500,<br> discount = 0,<br> allocated =
0,<br>
unit = '',<br> transdate = '02-28-2011',<br> deliverydate =
NULL,<br> project_id = NULL,<br> warehouse_id
= 10810,<br>
serialnumber = '',<br> ordernumber = '',<br> ponumber =
'',<br> itemnotes = 'My Awesome Service
',<br> lineitemdetail = '0'<br> WHERE id =
1313<br>ERROR:
column "transdate" of relation "invoice" does not exist<br>LINE 9:
transdate = '02-28-2011',<br> ^</b>
Anyone know how I can fix this?
Thanks,
Ian
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
