Hi everybody,
I started using opentaps a couple of months ago, mainly as a CRM for
quotes and everything was fine.
Now I need to start doing some sales, and I have a problem generating
invoices. I set up financials and accounting settings.
The problem is that I can convert one order to an invoice (I do it with
the "Quick ship entire order" button), but the following orders fail as
OT is trying to assign them the same invoice number (2007-1 in this
case).
I've read all the accounting and financials docs, but cannot find
anything that can cause this problem.
Thanks in advance, the error generated is the following:
The Following Errors Occurred:
ERROR: Could not complete the Sub-method used by quickShip methods to
create a shipment
[file:/usr/local/test01/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createShipmentForFacilityAndShipGroup]
process [problem invoking the [updateShipment] service with the map named
[packedContext] containing [[shipmentId=10012, statusId=SHIPMENT_PACKED,
userLogin=[GenericEntity:UserLogin][createdStamp,2007-05-31
13:21:26.0(java.sql.Timestamp)][createdTxStamp,2007-05-31
13:21:26.0(java.sql.Timestamp)][currentPassword,a059d9ac5e0b9c8067ae0cebb9a5bcba1636c386(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,ca(java.lang.String)][lastUpdatedStamp,2007-07-04
18:25:10.0(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-04
18:25:10.0(java.sql.Timestamp)][partyId,X.Olivella(java.lang.String)][passwordHint,null()][successiveFailedLogins,0(java.lang.Long)][userLoginId,x.olivella(java.lang.String)],
locale=ca]]: Problems with the transaction. (Exception while inserting the
following entity:
[GenericEntity:Invoice][billingAccountId,null()][createdStamp,2007-07-04
19:59:06.653(java.sql.Timestamp)][createdTxStamp,2007-07-04
19:59:04.314(java.sql.Timestamp)][currencyUomId,EUR(java.lang.String)][dueDate,null()][invoiceDate,2007-07-04
19:59:06.511(java.sql.Timestamp)][invoiceId,2007-1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2007-07-04
19:59:06.653(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-04
19:59:04.314(java.sql.Timestamp)][partyId,10001(java.lang.String)][partyIdFrom,Company(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)]
(while inserting:
[GenericEntity:Invoice][billingAccountId,null()][createdStamp,2007-07-04
19:59:06.653(java.sql.Timestamp)][createdTxStamp,2007-07-04
19:59:04.314(java.sql.Timestamp)][currencyUomId,EUR(java.lang.String)][dueDate,null()][invoiceDate,2007-07-04
19:59:06.511(java.sql.Timestamp)][invoiceId,2007-1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2007-07-04
19:59:06.653(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-04
19:59:04.314(java.sql.Timestamp)][partyId,10001(java.lang.String)][partyIdFrom,Company(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO INVOICE (INVOICE_ID,
INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID,
BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE,
INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key
or integrity constraint violation message from server: "Duplicate entry
'2007-1' for key 1"))))]
