window "invoice schedule" not shows records in Report
Description
Environment
None
Attachments
4
IDEMPIERE-683_DataEngine.patch
08 Mar, 2013
IDEMPIERE-683.patch
07 Mar, 2013
reportinvoiceschedule.png
06 Mar, 2013
invoiceschedule.png
06 Mar, 2013
Activity
Heng Sin Low
April 27, 2013 at 7:05 AM
Patch to data engine committed.
Richard Morales Herrera
March 8, 2013 at 10:12 PM
the attached suggested patch works without applying the migration script
Carlos Ruiz
March 8, 2013 at 9:17 PM
Thanks Richard, can you please help me testing the attached suggested patch to solve this issue (without applying the migration script).
Carlos Ruiz
March 7, 2013 at 4:57 AM
Richard found this is caused because the column c_invoiceschedule.invoiceweekday (based on list) is null on database, and marked as mandatory on dictionary.
The same can happen on any reference column that has nulls on database and is marked as mandatory on dictionary - that record will not be shown on reports.
The next query shows 52 records with the same problem (DB nullable - Dictionary mandatory):
SELECT tb.relname
|| '.'
|| cb.attname
FROM pg_class tb
JOIN pg_attribute cb
ON tb.oid = cb.attrelid
WHERE cb.attnotnull = false
AND tb.relname
|| '.'
|| cb.attname IN (SELECT Lower(t.tablename)
|| '.'
|| Lower(c.columnname)
FROM ad_table t
JOIN ad_column c
ON c.ad_table_id = t.ad_table_id
WHERE t.isactive = 'Y'
AND c.isactive = 'Y'
AND c.ismandatory = 'Y'
AND t.isview = 'N'
AND ( c.ad_reference_id IN ( 18, 30, 17, 21,
25, 31, 35 )
OR
( c.ad_reference_id = 28
AND c.ad_reference_value_id > 0 ) ))
ORDER BY 1List of columns with the problem:
a_asset_group_acct.a_disposal_loss_acct
a_asset_group_acct.a_disposal_revenue_acct
a_asset.m_attributesetinstance_id
ad_column.ad_element_id
ad_printformatitem.ad_printformatchild_id
ad_replication.remote_client_id
ad_replication.remote_org_id
ad_rule.entitytype
ad_rule.eventtype
ad_rule.ruletype
ad_val_rule.type
ad_window.windowtype
c_acctschema_default.p_ratevariance_acct
c_acctschema_element.org_id
c_acctschema.taxcorrectiontype
c_bpartner_location.c_location_id
c_bp_customer_acct.c_prepayment_acct
c_bp_customer_acct.c_receivable_acct
c_bp_customer_acct.c_receivable_services_acct
c_bp_group_acct.c_receivable_services_acct
c_bp_vendor_acct.v_liability_acct
c_bp_vendor_acct.v_prepayment_acct
c_doctypecounter.counter_c_doctype_id
c_invoiceline.m_attributesetinstance_id
c_invoiceschedule.invoiceweekday
cm_container.containertype
cm_cstage.containertype
c_orderline.m_attributesetinstance_id
c_order.salesrep_id
c_payment.c_bpartner_id
c_projectissue.m_attributesetinstance_id
c_projectphase.projinvoicerule
c_projecttask.projinvoicerule
c_revenuerecognition.recognitionfrequency
c_rfqline.m_attributesetinstance_id
c_withholding.beneficiary
exp_formatline.ad_column_id
i_inoutlineconfirm.m_inoutlineconfirm_id
m_inoutline.m_attributesetinstance_id
m_inventoryline.m_attributesetinstance_id
m_matchinv.m_product_id
m_matchpo.m_inoutline_id
m_matchpo.m_product_id
m_product_acct.p_costadjustment_acct
m_product_acct.p_inventoryclearing_acct
m_product_acct.p_ratevariance_acct
m_product_category_acct.p_costadjustment_acct
m_product_category_acct.p_inventoryclearing_acct
m_product_category_acct.p_ratevariance_acct
m_productionline.m_attributesetinstance_id
m_product.m_attributesetinstance_id
t_replenish.updatedbyRegards,
Carlos Ruiz
Fixed
Details
Details
Assignee
Carlos Ruiz
Carlos RuizReporter
Richard Morales Herrera
Richard Morales HerreraPriority
MajorCreated March 6, 2013 at 3:58 AM
Updated September 1, 2015 at 3:33 PM
Resolved July 2, 2015 at 1:43 AM
the option Report of the window "invoice schedule" not shows records !!!