Browse By Tags

  • Is there a PO Return of Goods History Report

    Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…
  • Voided transaction log

    Hi, I am working on the closeout package for 2023, I know a it late, however I am having issues matching the trial balance apparently some transactions were voided after everything was sent to the CPA. I need a way to a report with voided transactions…
  • Power BI

    We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.
  • Would it be possible for a Attachment in Sage X3 on a Products "ITMMASTER" screen be referenced when Printing from the Work Order "MFGHEAD" screen?

    Hello All, I have an interesting ask from our User base. We have Word Documents that are required to be printed when ever as a Check sheet each time a user prints a work order. Here's the twist the Word documents are unique to each product or groups of…
  • Information Assistant RDP connection does not allow users to print via local printers

    Hello everyone, I have an issue that I haven't been able to find a good fix for. Users in the office access Sage that is installed on one of our servers with an RDP connection into the Information Assistant app to pull reports, particularly Job Cost…
  • How do I get a report showing Vendor Statistics for a fiscal year in Sage 300 CRE

    I need to pull a report that shows all of the following information for our past fiscal year: Vendor name, address (CSZ) number of checks, total amount paid to vendor, Type of payment (Check, cc, ACH).
  • Error when opening payroll reports - Access violation in module Task0150.exe

    Hello! We process our payroll in Sage BusinessWorks. After printing checks, we print out the Check Register report. We had no problems last week; however, after printing checks and attempting to open the register report today, we got the following error…
  • 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…
  • cannot access database (error=40960) sage 300

    I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?
  • Check Register doesn't show correct Payee

    Recently my check register report does not show the correct name that was printed on the check. How do I fix this? I need it to show the Remit 1(2,3,) name not the Vendor Name so it matches the actual check. We have lots of Vendors that require us to…
  • 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.
  • AP invoice and the AP Trial Balance Report compared to the GL

    Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…
  • Reports not matching and Database Utilities tool not working

    I am having an issue with inventory reports not matching, and showing false negative quantities. The inventory quantity report will sometimes show negative Pending Sales Order quantities, and currently I am seeing negative quantities for some items only…
  • Print report to show shipping amounts from sales order

    I am looking for a report that will show the shipping amount total for the day from the sales order before it's invoiced. This is just the shipping cost.
  • Monthly Income Statement

    We are new to Sage 100. We are trying to run a report that shows what we invoiced, and any payments/debits made. We ran report 2-3-21. However, that report is showing every invoice we received for the month even though it wasn't paid. Some of our credit…
  • 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…
  • Sage BusinessVision 2023 SBE Bug Report - Broken indexes (Actian v15)

    Hi ClarkM and Erzsi_I I see that that a similar question was posted by slacka 6 months ago, and remains unfixed. I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…
  • missing main.db?

    I turned my timeslips 2017 and the main.db was missing. i now can't find it to access my data. can someone please call me at 310-556-1001 or refer me to someone who can find it? I found my tseg.fdb file but that is it.
  • Order Confirmation Creation Time

    Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you
  • Report formatting to analyze realization

    The report "User History by Period" seems to reflect the total slip values "Billable Fees" (hours x user charge rate on slips actually billed during specific period) and actual charges billed "Actual Fees" (actual amount billed for specific slips for…
  • Previous employees on Vacation report 5-1-8-86

    On report 5-1-8-86 How do remove old employees from the report? Some of these employees have not been employed for quite awhile, but still show, even with a zero balance.
  • Running a Crystal Report with a range parameter from Web Services using (CWSGPRTRT) Generic Print Report

    We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
  • Report that shows wages for a particular job

    I m looking for a report that shows employee's name and wages for a particular job and a certain time frame.
  • Printing job statements is cutting off paid dates

    Report 3-4-21 (at least in the Canadian edition) is cutting off the dates when you print the payments. This has been happening for a while, but we were hoping it would get fixed in a subsequent release
  • Oregon Corporates Activity Tax Report

    HELP! What reports are you pulling/printing to do the Oregon Corporates activity report? We are a WA. based business, but we also do jobs in Oregon. Need to be able to separate the states or tax district. What I'm looking for is a report that will…