As told in the other message my problem is that I want the "invoice
sequence" to be set as "Restart on Fiscal Year (no gaps, per org, reset
to 1 each year)" but it doesn't work. The only way it works is with
default option.
I am getting really mad about that, I've been testing dozens of things
and searching in docs for days and I cannot make it run.
I really could not find any "in-deep" documentation about setting the
company accounting, so it's impossible for me to solve the problem.
When I make an invoice it works, but on the following the program gives
it the same invoice number so it crashes with the error below.
Could anyone help me?
***************************************
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"))))]
