Return-Path: X-Original-To: apmail-ofbiz-user-archive@www.apache.org Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AFF299574 for ; Fri, 18 May 2012 06:34:49 +0000 (UTC) Received: (qmail 1531 invoked by uid 500); 18 May 2012 06:34:49 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 1510 invoked by uid 500); 18 May 2012 06:34:48 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 1500 invoked by uid 99); 18 May 2012 06:34:48 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 May 2012 06:34:48 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of venkatmangudi@gmail.com designates 209.85.214.172 as permitted sender) Received: from [209.85.214.172] (HELO mail-ob0-f172.google.com) (209.85.214.172) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 May 2012 06:34:42 +0000 Received: by obbeh20 with SMTP id eh20so4311635obb.31 for ; Thu, 17 May 2012 23:34:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=mtOKTte7VR939jBZELP5ZpqaEM0hTmkuTJOL4dlXA2I=; b=r8BXzpLk2D4gJe58iZ+QZUTXcHetwa7JJViYaWZvzSu2Eqn+UflgpxZWQou7ztYg9V dlliE4TY5ktHKcf6apsd9JKiaUS0kFrxxDF9v6Dc3H9YEXwo+6hV5f3Hff2saTlOHQki brdKjLXI8YRwTpY0JvBX+e+O9O8yKZF/tPMpwz+IQfeYF+78yAN475lHfr4DJTntSPW3 c7dhjnCaki12uSRcX5ceHWelnsks3tAmfOpq/xsEDZ1tUGOHSdpuhanacUYqjGqxHfBd qacerX9rsAktcU7PBdbJZuBCqv01BuPOJ/ypPScYJGLlvFut5BFaUj+OO72CYoKUgvJV nM7A== MIME-Version: 1.0 Received: by 10.182.207.41 with SMTP id lt9mr9179933obc.41.1337322861616; Thu, 17 May 2012 23:34:21 -0700 (PDT) Received: by 10.182.80.103 with HTTP; Thu, 17 May 2012 23:34:21 -0700 (PDT) In-Reply-To: References: Date: Fri, 18 May 2012 12:04:21 +0530 Message-ID: Subject: Re: Order Sequence From: Venkat Mangudi To: user@ofbiz.apache.org Content-Type: multipart/alternative; boundary=e89a8f6435881ddde704c049bef3 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8f6435881ddde704c049bef3 Content-Type: text/plain; charset=ISO-8859-1 On Fri, May 18, 2012 at 10:52 AM, Surya Kusumakar wrote: > Hi Venkat, > > For Sales order you can set your preference in Accounting Preferences field > : Order Id Prefix. So all the Sales order numbers will start with your > preferred prefix, like : BMP100001 . Also you can set preference for order > sequence from Accounting preferences. > > Thank you, but what I am really looking for is not prefix. I want sales orders to have their own sequence and purchase orders to have their own sequence. I suspect that my requirement will be a problem because Orders (both SO and PO) are stored in Order table. Can the big guns weigh in on this please? -- Regards, Venkat --e89a8f6435881ddde704c049bef3--