Sage 300

Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…

Hi Everyone, We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along with the…

Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…

We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…

We add inbound freigh as an additional cost on our inventory purchases. How can I pull a report that tells me how much I'm spending on inbound freight?

When I print my PO to PDF the amount is displayed by #### symbols. Is this a formatting error? I attached a snapshot of what it looks like. Thanks!

Hi there, Can someone help me out an FR function here. I am new to the FR designer. I am using a report template that was created before me, function is below, but it returns the date format like 5/31/2021 =FR("PERIOD")&" Months Ended "&FR("END…

We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…

Hi Citiers, I have searched around and and followed all the tips found here there there with no uck. I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error. We got an Windows Server…

Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…

We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work. The issue is that when we print a report - any report, it runs the database record select and then stops…

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…

Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time? We're trying to determine: 1) How many commitments were…

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…

I created a folder (new Object) that contain customized reports in Sage 300 premium (version 2016). When I run these reports Sage crash and closed with no error message. The reports I created work well in another PC. What can be the problem?

Hi All, Problems found when we had started doing new forms/reports for Sage 300 2019. Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier…

I need to fast track the implementation of Positive Pay due to fraud activity. Does anyone have a Positive Pay text file for the Atlantic Union Bank Specs that you'd be willing to share? Thanks!

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 need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…

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…

Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…

Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.

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…

We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…