Browse By Tags

I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…

Hi All, I was trying to print the SSRS report from sage. If anyone have tried this please help me with this.

Hi, I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports. But there is no description field found from it existing table in this report. The field that I want to add is in table AROBL.DESCINVC…

[sage300erp 2018] I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

I am a novice when it comes to custom report programming. I hope that someone can help me with a formula in the custom report 13-3 screen in Sage 100. This is the only tool we have to do the custom reports. I want to combine the original budget from table…

I took over a client who created a number of crystal reports that output to printboss. Very nice, but they do something strange with the crystal variable that evaluates to the trigger string 'PB#INFO '+Chr (247)+{@PrintBossForm}+Chr (247)+', '+ …

Apologies if this is not the correct category. From time to time we receive the following error when attempting to do custom report printing. The temp file is there. The only fix seems to be rebooting the server and deleting the file. Sage 100 will then…

Hi all, We created a custom report using views.We used alias names in the view as"Quantity" ,but the alias name displayed in the report is apperaring to be all small letters "quantity".Is there any way to change the starting letter to upper case.…

I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…

I'm currently working with a standard job cost report that shows employee hours at T&M rates with certified classes on it, but it is actually pulling the certified class from the employee set up. I want it to pull from the actual weekly payroll certified…

Hello! I have a report design that utilizes the following recordsets: CN Contract CN Contract Item JC Job PJ Job PJ Job Custom Fields I have a custom field in PJ Job Custom Fields that specifies the price structure (stipulated sum, GMP…

Hi, The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates. Is this possible using Windows Task Scheduler or is there…

We recently started using the DSD SQL Mirror to speed up reporting and are very pleased so for with the results but I have run into a problem. I am attempting to move the slower reports in SAGE custom report menus over to the mirror and when I attempt…

I need to modify the 5-1-8-41 report (and name it 5-1-8-05) with the following modifications: * Remove PREMIUM hours column and replace with OTHER hours column (to include sick, vaca, holiday as we don't use premium) * Add OVERTIME WAGE column …

Hi, My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result. Any…

Businessworks 2017 SP2 I want to calculate job margin on a custom report using JCjobs fields as follows: ((Billings-ActualCost)/Billings)*100 Is a calculation like the above possible in the report? Any help would be greatly appreciated!

Client wants the cheque advise to have 2 columns on the cheque advise in Sage 300, as Sage 50 gave him 36 items on the remittance stub. (Just Doc # and Amount paid) How do i setup the sub report to do this? Sam

We have 10 active Company Codes. Each one has a set of core sales reports that are exactly the same except they pull the sales reps, customers & products from the specific company code. Due do performance issues I can't use dynamic parameters in the CR…

I have created some reports in Crystal reports 2008 which work fine when opened directly from Crystal reports. Unfortunately the client would like to be able to open these reports from any workstation that has access to Sage, so must be able to open…

I can run the old versions that use html extension, but I prefer to use the up to date AOM when working with Crystal etc...

I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…

My company is looking into the possibility of developing an ASP.Net MVC application to view custom reports that are designed & created by our users through Sage 300 ERP Suite. I believe there is the .Net library to integrate with Sage. Can we develop…

I am building a custom crystal report off the AP Invoice Table. When I grab the APIBH.DATEINVC file, it shows 20,110,101.00. I want to convert it to 1/1/2011. I tried using the following formula: date({APIBH.DATEINVC}) but it does not work. Any suggestions…

I have pretty limited knowledge/experience with Sage or report writing but I'm currently working on recreating non-modifiable System Report 4-1-3-21 so I can add "account" as a selection criteria. I was able to recreate the calculated fields and I am…