Implement Generate Invoices (manual) as Info Window


1. Create new Info Window (same columns as Generate Invoices (manual))
1A. parameters for info window

  • organisation - only orders for a specific wh

  • business partner - orders for a specific partner

  • document type - only specific order types

  • order
    2. process - re-use existing "Generate Invoices"
    output - process parameters

  • date invoiced

  • checkbox - consolidate to one document

  • document action - changing document status




Hiep Lq
May 24, 2015, 8:54 AM

in view c_invoice_candidate_v we can remove below where clause
OR o.invoicerule = 'S'::bpchar
AND bp.c_invoiceschedule_id IS NULL

or has wrong logic at here.

Norbert Bede
May 24, 2015, 4:06 PM

we are using scheduled invoicing. "S".
we are investigate today with

we found its tricky to understand how to setup properly. if we setup e.g. monthly invoicing to 31 day and cutoff day to 31 then i got "guite" good figures. still testing well.

thanks for investigation.

Andrea Checchia
September 19, 2016, 1:11 PM

Hi ,

we tried this and we found a little problem about ad_element doc_type 202717 . There is no "insert" in this script of this element .
But we solved changing it with standard doc_type (196) is this correct ?
In fact we found that the new infowindow doesn't recognise the t_select . it process all the rows .
Are you using in production or did you make new update?
Probabily we need to change the process to recognise the t_select .? doesn't it ?

Thanks in advance

Norbert Bede
September 22, 2016, 8:38 PM

not yet. i suppose that was proof of concept. norbert

Norbert Bede
August 22, 2020, 2:46 PM

same as

patch must be converted to PR then deprecate form.


Hiep Lq


Norbert Bede

Tested By


Affects versions

Due date