Log Message: |
A patch from Parimal Gain for "Order Report Issue" https://issues.apache.org/jira/browse/OFBIZ-5297
Reports under Order component has following issues -
1. Following reports are not showing any records due some issue
a. Last three month sales report.
b. Sales report.
c. Sales Order discount code report.
d. Product demand report.
2. Inconsistency in opening the pdf report - some reports are opening in new tab window but some are in the same window.
Following are the checkpoint -
1) Order should be Approved
2) All Dimension table(CurrencyDimension, DateDimension, ProductDimension)should have record.
3) After approval of order, order record should be created in 'SalesOrderItemFact' table. These is the OLAP table used to display data in reports.
Description -
1) If dimension table doesn't have records then following services should execute from service engine -
a) loadAllProductsInProductDimension
b) loadCurrencyDimension
c) loadDateDimension
2) Calling service to create record in 'SalesOrderItemFact' is updated into patch. On commit operation of service 'changeOrderItemStatus' if order item is approved then 'loadSalesOrderFact' service called through SECAS.
|