Browse By Tags

I'm using Sage 50 US. I'm looking for a way to add a comment about an invoice that would show up when I run the aging report. For instance, when a customer communicates to me that the invoice will be paid on a certain date, or if there is an issue with…

Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.

As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…

Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…

Hey everyone, We do have many dashboards with different reports telling us what to do next, which are missed deadlines and what my daily performance is. Now I'm wondering if there is a way to change the background color of a field or line based on…

Hi - With the disappearance of Intelligence Reporting, I have run into a brick wall on accurately accounting for and calculating the commissions that my sales reps get. I have tried to do it through the Invoice Register, but the report that it spits…

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…

I have created a "description" field to hold the description of the unit of measure as the 4 letter unit is often pretty cryptic. I had no problem creating it, but when I go to add the field to the panel (Dmain), I cannot add my UDF. The add field is…

Form and Report Designer are still stuck in the1980's as text based editors. Isn't it time to upgrade them to a graphical UI? I'd like to be able to import an image of a preprinted form on a non-printing layer. This would make text and field alignment…

Hi, I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards…

Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…

I have 2 different reports one is a Statement of Financial Position while the other is an Income statement, how can I get calculated fields value from my Income Statement Into my Statement of Financial Position noting that the IS has it's Data Model just…

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…

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…

I would like to know if their is a way to create a text field on purchase orders, sales orders, quotes etc or any report / form where who ever entered the information is logged. So on the bottom of the from I could have Entered By: "Employee Name…

Trying to figure out how to invoice clients who have flat rate task and hourly task on one bill Example file application- flat $1400 report application as filed $18/ hrly can I invoice a flat rate task and an hourly task? Can I invoice a flat rate…

I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …

I need to add our clients number (Nickname 2) to the WIP reports, anyone have experience with this? I have had no luck creating from scratch and was hoping to use our current WIP report and add the field (but the option doesn't show)

I've created a number of reports intended for Facility Managers to access through a link I made on their Landing Page. What I would like to do is pass their default facility through to the report to restrict the data they can retrieve to just that which…

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…

I have some older customized financial statements listed in my drop down that I don't currently use, but might have to in the future. Is there a way to move these files to another folder so I am not seeing them? I am currently using 2019.

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.

Is there a way to print blank stock checks in Sage 500? My AP person doesn't want to use pre-printed checks. Also, how do I add a signature to the AP check print form, Sage 500? I'm so used to having source code, I was a former developer, so I'm having…