Browse By Tags

  • Crystal and special tsar functions

    In the users guide there are these functions for AR but it does not tell us exactly what they are doing and how it is determining it. In the AR Statement (CR) uses these functions, but i am getting some strange answers. I believe it has to do with the…
  • Client Average Days to Pay Report

    I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,
  • Receivables

    I'm looking for a report that shows me the current contract dollar amount and how much we have been paid for that particular contract.
  • Adding a note to receivables aging report for individual invoices

    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…
  • A/R Reports for a selected time period, including closed and inactive clients

    Is there a way to generate an accounts receivable report for a time period that includes matters that are closed or inactive?
  • Are First and Last Names needed for printing or eFiling 1099s?

    I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…
  • Printing error

    HI All Please assist on how to resolve this error. It appears when trying to print any report in the system. The print server is configured and the service is running. Job 2 - ERR 262 coming from the edition server : Connection to the X3 file server…
  • Phases Wip Reports

    We have been setting up phases in Sage 100 Contractor for each small job for a customer instead of setting up several small jobs. We then have been billing each phase. It is my understanding that we can not close the phases in sage 100 contractor. …
  • A/R cheque numbers

    Is there a way to print a report from Customers that lists the cheque number rather than the receipt numbers?
  • Full Inventory Inventory List w/filters

    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…
  • Setting up ZPL Printer (Private Network) with Sage X3 (Cloud)

    Hello Everyone, We are trying to setup ZPL printer on Sage X3 but the problem we are facing is: a. ZPL printer is on a private (LAN) network - not accessible outside b. Sage X3 is on the cloud (Accessible only by a secured SSL URL) c. Sage X3…
  • Work Ticket Printing Error

    There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …
  • AR Invoice List

    Hey All, We are still new to Sage 100. I can run a report to see what we invoiced for each month. (3-1-2 Report # 21). However, I was wanting to run a report to show everything thus far this year. January till November. Is there a way to do that? To…
  • Customer activity report

    Is there a report that will show a list of customer invoices and the payments + credit memos applied against it? We have a customer that is constantly trying to re-use credit memos. Thanks for your input!
  • Customer Statements

    Is there an option to run customer statements for customers with a balance less than a specific amount? (Ie, less than $100.00)
  • Inquiry with last invoice date for a job/contract

    I have been searching everywhere to find an inquiry that has the last billing date for a contract. Does anyone know if such a thing exists? I can't even find where this information is stored in contracts, billing, job cost, AR, anywhere. Your help is…
  • AR Tax Group Set up Report

    Does anyone know if there is a AR Tax Group set up report that exists so I can see what tax rates are part the group? Looked in standard reports and KnowledgeBase but have not been able to find anything.
  • How can I tell if I have billed retainage

    1. I m looking to see if there is a report that would show me if i have billed retaiange. 2. I m looking for a report or something that i can run that would show if I billed for my jobs that month.
  • Exporting Sales Receipts

    I really need to be able to export a sales receipt to a .csv or .xls file format rather than print it. I have looked under reports and forms and attempted to use Sage's 3rd party .csv format option. Unfortunately this is cumbersome and does not show…
  • Windows 11 / Business Vision 2023 Reports freezing when printing &/or saving as pdf

    Hello community, I am in desperate need of HELP ! We use Sage Business Vision for small business version 2023. We installed it on 1 new computer with Windows 11 operating system in November 2022. Originally, there was an immediate C++ runtime error…
  • Sage 300 2023.1.0 - Web Screen Print Destination> Preview | Print to Email

    Utilizing Sage 300 2023.1 to access Sage300. How can the print destination be modified using Web screens? Currently, whenever we print any report, a new tab is opened with a file format menu [PDF, Excel, Word, etc.]. In addition, how email functionality…
  • Add field to Report Designer AR Aging Detail by Customer

    We run the AR Aging Detail by Customer (RD version) and lately we have had some payments that have come in that don't get applied to an invoice right away. So, they get entered as customer cash receipts and we indicate which project they relate to by…
  • AR Receipts Reversals

    The AR Customer Transactions Report displays the characters "R" alongside some PAYMENTS transactions and the Legend at the end of the report shows this to be "Reversals". We understand that the reversal process triggers some entries which would invariably…
  • Billing Report

    Is there a billing report that can be run when I've completed billing for the month which shows the customer, the project and the amount billed for the month and the total billed to date?
  • Is there a report that distinguishes between credit card customers and Net 30 customers who pay by credit card?

    Hi, I'm doing an analysis of credit card fees, with the intent of beginning to charge my Net 30 customers a fee for using a credit card to pay their invoice. I doubt it's possible, but is there some sort of report, or series of reports, I could run that…