I need help, can somebody be so gentle to help us out with this report. this report is locked and we do not have intelligence reporting or other software for modify this report. is possible have a screenshot of other structure of the report and have a print format so i can see the calculate field use.
we need to copy this report because we need a/p invoice table - CO table and Subcontract table, and this looks that is complete.
thanks
The only way you can really get a look at what the fields are that they are calculating is to open the report into notepad. (i.e. depending on your version go to the appropriate drive and navigate to the mb7/custom reports folder or the C:/Sage100Con/Common/Custom Reports folder, find the report you're looking for 06070421, right click and open with notepad). Then you can see what Sage is calling the calculated field. If you are lucky, you can then search in the Calculated fields section for the calculated field that is identified (it will look something like acpinv*sbbal), and the calculation is there.
Unfortunately, as was stated above, this is probably a more advanced SQL statement than most clients are able to do on their own. I would recommend a third party reporting tool, or investing in a consultant that can help create this type of report.
The linkages you would need would be through the subcontract number on the AP Invoice (acpinv.ctcnum) and the Subcontract Number on the Change Order Lines (sbcgln.vndctc). You would need to connect the AP Invoices (acpinv) and AP Lines (apivln) to the Change order Lines (sbcgln) to the Change Orders (prmchg) to the Subcontracts (subcon)/Subcontract Lines (sbcnln). The header/detail connections would be through record numbers.
Hope that helps!
Kelcie
