A quick note. The requirements that you're discussing is probably handled better with a different approach. When you give meaning to data that is created arbitrarily (surrogate primary keys like invoiceId) you WILL run into problems. This is likely better handled through the use of an external id instead of the primary key.
--- Xavier Olivella <[EMAIL PROTECTED]> 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. (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"))))] >
