4Site
Support Request System
View Patch #50.004.016
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
01850 -
VO Query Details report doesn't show detail lines anymore
Symptoms:
VO Query Details report doesn't show detail lines in some cases. - in cases where the vo has no tax and therefore no record on the taxacct table. Also, duplicate detail lines are printed for vouchers where taxes are applied.
Solution:
Revise the vodetai.sql procedure such that it supplies data to the voDetails sub-report (as well as the costing sub-report) i.e. - add required fields to the #tmp temporary table, the select list in each union of the select query and in the insert statement to populate the #tmp table. Revise the Crystal report file as follows: - Add proc p4s#vodetails (TestV5) as a data source to vodetails subreport. - Remove all references to existing data source table, then remove the tables - Link the @void parameter as the key to the vodetail subreport - Re-link all report objects and formulae to respective fields on the new p4s#VODetails data source - Re-format all fields in the detail section of the subreport - Suppress the Tax record from displaying in the detail section (already detailed in costing subreport) - Add Group Footer to suppress duplicate lines based on p4s#vodetails.voline - Revise @Tax formula to correct split costing calculation Enlage the voLine form and resize relevant grid co;ums to better display data
Browse Patches
Find a Patch
Return to Request System Menu
