If there's a bug no documentation will fix it, a human will have to go in,
reproduce the bug, find the problem, and fix the code.
You can file a Jira issue to help keep track of it, but that won't necessarily
get resources allocated to getting it fixed. Someone with an interest in the
feature will actually have to do it, or hire someone else to do it.
-David
Xavier Olivella wrote:
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. (Ex
ception 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)][invoiceT
ypeId,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"))))]
