Browse By Tags

  • Crystal error when running reports

    Fresh install of Sage 100. I ran the installer as domain admin as well as the WksUpdate Standard file. I have already tried reinstalling the software over 5 times and verified all necessary files were present in the C Drive file path. Is there any other…
  • 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…
  • 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…
  • 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…
  • report error "invalid object name mscfld

    I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.
  • 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.
  • Error in Account Reconciliation with Outstanding Transaction Detail Report

    When I used the Match Bank Transactions function in the Banking module to help with making my lengthy bank statement reconcilable, I matched all the transactions, then look at my reconciliation on the reconcile accounts functions; it says I have no unresolved…
  • 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…
  • Report - Average days to pay

    Is there a report I can check average payment time for our clients? or do I have to go through every single transaction and count? Thanks!
  • Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
  • Slow Performance during Report Phase Job Started and Printing X3 V12

    Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019 When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…
  • PO wont display amount

    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!
  • Running Quote Reports

    Is there a way to run a report in sage that lists all the pending quotes not yet awarded? The only report I can find is the Pending Delivery Orders by customer.
  • Paid customer and job remain on AR Aging Detail reports (not crystal)

    Our AR Aging Detail by Job is showing a job that has no balance, and our AR Aging Detail by Customer is showing that customer with no balance. There's nothing that I can find to adjust on this customer. I found some forum posts on receipts and invoices…
  • I want to print an Accounts Receivable Invoice History report sorted by Customer Type.

    I need to print an Accounts Receivable Invoice History Report sorted by Customer type. I have created the UDF for Customer Type and added to all the work and history files. When I run the report just selecting invoice dates I get my report showing the…
  • Commitment Count - Total & Unique

    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…
  • A/R Transaction Listings

    Hello - I'm looking to run a report that shows every amount we invoiced our clients for one year as well as what they paid in that same year. Basically invoice amounts and payments for 1 year. The invoice amounts look correct, but the payments that…
  • Formulas to pull out First name & Middle Initial separately

    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…
  • Consolidated Designer

    I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…
  • Report error: "Index was out of range. Must be non-negative and less than the size of the collection"

    Reports starting giving the following error: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name:index". This just started happening on the latest update. I've been using these same reports for years…
  • Report window exits on clicking Print button

    When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…
  • Payments not showing in Aged A/R Balances Report

    I have an issue with Aged A/R Balances that has come up a few times recently. Sometimes, check payments that I entered do not show up when I print an Aged A/R Balance report. I check the client's payment transactions and there are no unapplied payments…
  • AR Balances Report

    Hi, Does X3 have a report that shows what is owed by a customer. This would be any open invoices that have not been paid. FAHAD