Browse By Tags

We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…

We upgraded Estimating last night and now any report layout you choose the previous settings are gone

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…