how do I change the default currency? cheers, kurtis. Dave Tenerowicz <[EMAIL PROTECTED]> wrote: Ok, I read the jira thread, and set a value for lastInvoiceRestartDate (2007-01-01 00:00:00) I still get the same error message. Also I am using a version much newer than the one in which this issue was reported fixed. Is it possible that this is a new issue? Is anyone else seeing the same error?
-Dave Dave Tenerowicz wrote: > Rev is 564334. > > David E Jones wrote: >> >> >> Dave Tenerowicz wrote: >>> Using the latest revision from trunk. >> >> Specific revision numbers are helpful. Things are changing all the >> time. Are you saying the rev # is 564187? >> >>> ParytAcctgPreferences for Company are: >>> invoiceSequenceEnumId =INVSQ_ENF_SEQ >>> invoiceIdPrefix =CI >>> lastInvoiceNumber = 0 >>> useInvoiceIdForReturns = "null" >> >> There was a recent issue related to this, which is why I asked for >> these details. I think there may have been comments that some >> sequencing type may still not work. >> >> Hopefully someone who worked on that can comment and help out. You >> could also try looking up that issue in Jira and related comments on >> the mailing list (probably the dev list). >> >> -David >> >> >>> David E Jones wrote: >>>> >>>> Which revision of OFBiz are you using, and what are your invoice ID >>>> settings on the accounting preference record? >>>> >>>> -David >>>> >>>> >>>> Dave Tenerowicz wrote: >>>>> Hoping someone has seen this one before. >>>>> In attempting a quick ship operation on an Order (Quick Ship >>>>> Entire Order from the View Order screen) I receive the following >>>>> error: >>>>> Any ideas how to troubleshoot? What is the reference to >>>>> "SQL070413040729120' defined on 'INVOICE" >>>>> Many thanks in advance >>>>> -Dave >>>>> >>>>> 2007-08-09 13:24:44,216 (http-0.0.0.0-443-Processor3) [ >>>>> RequestHandler.java:308:ERROR] Request quickShipOrder caused an >>>>> error with the following message: ERROR: Could not complete the >>>>> Sub-method used by quickShip methods to create a shipment >>>>> [file:/C:/projects/daveonly05032007/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createShipmentForFacilityAndShipGroup] >>>>> >>>>> process [problem invoking the [updateShipment] service with the >>>>> map named [packedContext] containing [[shipmentId=10060, >>>>> statusId=SHIPMENT_SHIPPED, >>>>> userLogin=[GenericEntity:UserLogin][createdStamp,2007-04-13 >>>>> 16:15:12.422(java.sql.Timestamp)][createdTxStamp,2007-04-13 >>>>> 16:15:10.25(java.sql.Timestamp)][currentPassword,47ca69ebb4bdc9ae0adec130880165d2cc05db1a(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2007-08-09 >>>>> >>>>> 11:01:15.891(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-09 >>>>> 11:01:15.891(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)], >>>>> >>>>> locale=en_US]]: Problems with the transaction. (Exception while >>>>> inserting the following entity: >>>>> [GenericEntity:Invoice][billingAccountId,null()][createdStamp,2007-08-09 >>>>> 13:24:42.045(java.sql.Timestamp)][createdTxStamp,2007-08-09 >>>>> 13:24:37.31(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][dueDate,null()][invoiceDate,2007-08-09 >>>>> >>>>> 13:24:41.701(java.sql.Timestamp)][invoiceId,CI1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2007-08-09 >>>>> >>>>> 13:24:42.045(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-09 >>>>> 13:24:37.31(java.sql.Timestamp)][partyId,DemoCustomer(java.lang.String)][partyIdFrom,Company(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] >>>>> >>>>> (while inserting: >>>>> [GenericEntity:Invoice][billingAccountId,null()][createdStamp,2007-08-09 >>>>> 13:24:42.045(java.sql.Timestamp)][createdTxStamp,2007-08-09 >>>>> 13:24:37.31(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][dueDate,null()][invoiceDate,2007-08-09 >>>>> >>>>> 13:24:41.701(java.sql.Timestamp)][invoiceId,CI1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2007-08-09 >>>>> >>>>> 13:24:42.045(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-09 >>>>> 13:24:37.31(java.sql.Timestamp)][partyId,DemoCustomer(java.lang.String)][partyIdFrom,Company(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] >>>>> >>>>> (SQL Exception while executing the following:INSERT INTO >>>>> OFBIZ.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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>>>> ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have >>>>> caused a duplicate key value in a unique or primary key constraint >>>>> or unique index identified by 'SQL070413040729120' defined on >>>>> 'INVOICE'.))))] >>>>> >>>> >>>> >>> >> >> > -- Dave Tenerowicz [EMAIL PROTECTED] Office: 303.493.6727 Mobile 303.906.6116 Fax 303.814.8330 Visit us at http://www.salmonllc.com --------------------------------- Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
