Browse By Tags

  • 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.
  • 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…
  • 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…
  • Report showing jobs associated to companies?

    Hi, Within a datafolder we have numerous companies - all with jobs associated to them. Is there a report or easy way to show what company each job is associated to or show a list of jobs associated to a certain company within a datafolder? Further…
  • Positive Pay file generation

    When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.
  • When will the Year End be posted?

    When will the year end be posted?
  • Crystal report Issue

    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…
  • 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…
  • Blended Billing-Flat Rate Task & Hourly Billing Task

    FormerMember
    FormerMember
    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…
  • WE WANT TO PRINT/EXPORT TRANSACTION DETAIL FROM ACCOUNT MGMT/INQUIRY

    FormerMember
    FormerMember
    We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…
  • Adding to Reports

    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)
  • 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…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    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…
  • What does *!! at the end of a general ledger report mean?

    On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant
  • Positive Pay and Report Designer

    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…
  • Invoice total and Final balance due on AR invoices don't match

    Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
  • 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…
  • Crystal reports inserting duplicate unwanted field - what am I doing wrong?

    I know there's still some fellow "old school" CR users here ... I am updating our check form - simply making a couple of minor alterations to PAYRLCHQ.rpt I want to replace 47/100 with 47 Cents The form has no 'Page Header' when I begin. I click somewhere…
  • Is Sage 300 2016 compatible with Windows 2003 32bit OS at the workstation level?

    I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…
  • Inserting a running total from a Formula field to OE Invoice report

    To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…
  • Job Cost Report Showing Mark-Up Labor and Contractor's Fee

    We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…
  • List of previous month's activity

    Hello, I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…
  • Business Insights Reporter Wizard Payroll Hang

    I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
  • Failed to retrieve data from database Database vendor code 208

    Hi I installed Accpac 500ERP 5.5a on my PC and the following error shows when i using it. (This is the first time I use Accpac so i have no idea about this error. And my PC environment is Windows7 64bit) Error:Crystal Report Viewer "Failed to retrieve…