Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008264Openbravo ERP07. Sales managementpublic2009-03-24 14:202009-05-06 00:00
pmagnin 
jayakumar 
lowminorhave not tried
closedno change required 
5
2.40MP1 
2.40 
Core
No
0008264: Issue when Auto Numbering option inactivated
You can not do a “Create Shipments from Orders” and a “Create Invoices from Orders” after having inactivated the Auto numbering.
Please see screenshots in attachment.
No tags attached.
pdf AutonumberingIssue_Nuevo.pdf (200,477) 2009-03-30 20:00
https://issues.openbravo.com/file_download.php?file_id=1093&type=bug
Issue History
2009-03-24 14:20pmagninNew Issue
2009-03-24 14:20pmagninAssigned To => rafaroda
2009-03-24 14:20pmagninFile Added: AutonumberingIssue.pdf
2009-03-24 14:20pmagninRegression testing => No
2009-03-30 19:39PascalMagninFile Added: AutonumberingIssue_New.pdf
2009-03-30 19:40psarobeFile Deleted: AutonumberingIssue.pdf
2009-03-30 19:51psarobeSeveritymajor => minor
2009-03-30 20:00PascalMagninFile Added: AutonumberingIssue_Nuevo.pdf
2009-03-30 20:02psarobeFile Deleted: AutonumberingIssue_New.pdf
2009-04-15 22:14psarobePrioritynormal => low
2009-04-15 22:15psarobeStatusnew => scheduled
2009-04-15 22:15psarobefix_in_branch => pi
2009-05-04 10:44AinhoaPagolaAssigned Torafaroda => sathiyan
2009-05-04 14:30sathiyanAssigned Tosathiyan => jayakumar
2009-05-05 12:25jayakumarStatusscheduled => closed
2009-05-05 12:25jayakumarNote Added: 0016044
2009-05-05 12:25jayakumarResolutionopen => no change required
2009-05-06 00:00anonymoussf_bug_id0 => 2787545

Notes
(0016044)
jayakumar   
2009-05-05 12:25   
We can do "Good shipment", “Create Shipments from Orders” and a “Create Invoices from Orders” after having inactivated the Auto numbering. We don't have any constraint for process whether we choose auto numbering or not in our system. If you choose auto numbering, it will take sequence from specific meta data/sequence name. Otherwise it will take from general pool for particular document type.

For instance:
The general sequence pool for above scenario is DocumentNo_M_InOut. If you switch it off auto numbering, it will take document number from "DocumentNo_M_InOut" sequence. Otherwise it will take it from specific sequence pool. It is "MM Shipment" in our case above. You may get next sequence id on both the cases.

Case 1- Auto Numbering off at good shipment:

SELECT * FROM Ad_Sequence where name='DocumentNo_M_InOut' and ad_client_id = '1000001'
 
Case 2- Auto Numbering on at good shipment:

SELECT * FROM Ad_Sequence where name = 'MM Shipment' and ad_client_id = '1000001'

This rule of thumb is same across our ERP. I am closing this, since the given defect is invalid.