Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0022688Openbravo ERP07. Sales managementpublic2012-12-27 15:512013-02-20 23:39
caristu 
ioritzCia 
immediatemajoralways
closedfixed 
5
pi 
3.0MP21 
caristu
Core
No
0022688: Is not possible to create a custom invoice grouping
Is not possible to create a new invoice grouping because the process that generates the invoices is not retrieving correctly the 15-digits binary code to specify the grouping.

The reason for this is because is necessary to add the module database prefix in the new search key that defines the grouping logic. And the process that generates the invoices is not taken this into account.
As System role,
Go to Windows, tabs and fields,
  - Select Business Partner
         Show up Invoice grouping in its header
Go to Reference window,
  -select schedule invoice grouping
  Add a new item list:
    Search key: [MODULE_PREFIX]_000000010000000
    Name: By payment term
restart tomcat

As group admin role,
Go to Invoice Schedule window,
   Create a new register
       name: Monthly
       Invoice frequently: Monthly
       Day of the month: 1
       Invoice Cut-Off Day: 31
Save it
Go to Business Partner window
   - Select Sleep Well
     set By Payment Term in Invoice grouping
  Go to Customer tab:
     - select in Invoice terms: Customer Schedule After Delivery
     - select the invoice schedule as Monthly

Go to sales order:
  Create 3 invoices, one for 30 days Payment term and 60 days for the other two.
  each other has to be defined one month before today.
Book them.

Execute the process Create shipments from orders

Execute Generate Invoices process for F&B US org -> only one invoice is generated instead of creating two (separated by the invoice term)
No tags attached.
Issue History
2012-12-27 15:51caristuNew Issue
2012-12-27 15:51caristuAssigned To => dmiguelez
2012-12-27 15:51caristuModules => Core
2012-12-27 15:51caristuResolution time => 1362524400
2012-12-27 15:51caristuTriggers an Emergency Pack => No
2013-01-08 09:20dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-01-24 11:16jonalegriaesarteTarget Version3.0MP20 => 3.0MP21
2013-02-18 14:58ngarciaResolution time1362524400 => 1361314800
2013-02-18 14:58ngarciaAssigned Tojonalegriaesarte => ioritzCia
2013-02-18 14:58ngarciaPriorityhigh => immediate
2013-02-18 14:58ngarciaSeverityminor => major
2013-02-18 15:01ngarciaIssue Monitored: networkb
2013-02-18 15:02ngarciaIssue Monitored: ngarcia
2013-02-20 09:36hgbotCheckin
2013-02-20 09:36hgbotNote Added: 0056627
2013-02-20 09:37hgbotStatusnew => resolved
2013-02-20 09:37hgbotResolutionopen => fixed
2013-02-20 09:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b932b97bf985b82e9e80fc7f081794d7c05d9640 [^]
2013-02-20 17:25caristuReview Assigned To => caristu
2013-02-20 17:25caristuNote Added: 0056648
2013-02-20 17:25caristuStatusresolved => closed
2013-02-20 23:39hudsonbotCheckin
2013-02-20 23:39hudsonbotNote Added: 0056655

Notes
(0056627)
hgbot   
2013-02-20 09:36   
Repository: erp/devel/pi
Changeset: b932b97bf985b82e9e80fc7f081794d7c05d9640
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Tue Feb 19 00:01:18 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b932b97bf985b82e9e80fc7f081794d7c05d9640 [^]

Fixes issue 22688: Is not possible to create a custom invoice grouping.

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0056648)
caristu   
2013-02-20 17:25   
Code Review + Testing OK
(0056655)
hudsonbot   
2013-02-20 23:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ad1d8844f2f6 [^]

Maturity status: Test