I'm still trying to "get my arms around" LedgerSMB and how it works.
Can someone clarify things for me?
I added a vendor "Acme Jewelry Inc". Then added a part (product) and
successfully saved it. Then I wanted to assign a vendor to the part. I
entered Acme and clicked the Update button. Acme Jewelry Inc was
displayed as a vendor, and an additional "open" row was added. I
clicked the Save button, but the vendor was *not* saved (assigned to the
part). When I tried "Save New", the following error occurred:
*
*
*UPDATE parts
SET partnumber = ?,
description = ?,
makemodel = ?,
alternate = ?,
assembly = ?,
listprice = ?,
sellprice = ?,
lastcost = ?,
weight = ?,
priceupdate = ?,
unit = ?,
notes = ?,
rop = ?,
bin = ?,
inventory_accno_id = (SELECT id FROM chart
WHERE accno = ?),
income_accno_id = (SELECT id FROM chart
WHERE accno = ?),
expense_accno_id = (SELECT id FROM chart
WHERE accno = ?),
obsolete = ?,
image = ?,
drawing = ?,
microfiche = ?,
partsgroup_id = ?
WHERE id = ?
ERROR: duplicate key value violates unique constraint
"parts_partnumber_index_u"
DETAIL: Key (partnumber)=(02357) already exists.*
Thanks.
Brian
------------------------------------------------------------------------
Brian Wolf
Activus Technologies
Phone: 410.367.2958
Email: [email protected]
Try out Activus Secure Payments^(TM), our recurring payments application.
Demo at http://demo.activustech.com
------------------------------------------------------------------------
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
