Browse By Tags

  • Prior year vendor Payment & Purchases

    Is there a way to run a report of prior year vendor payments & purchases?
  • billed fees on reports not matching

    At the end of the month, we run the slip profitability by period using just the date as a parameter (i.e. 3/1/2024-3/31/2024). We also run a user defined invoice listing for the month using clients classification - open, and invoice number range for the…
  • Report Designer

    Hi, I have a report in Sage Payroll and I would like it to count the number of employees on the report. I've tried and I cant get it to add up the number of entries, it just keeps adding up the employees reference numbers to give a hug total So for…
  • 941 Report - use Period End Date or Check Date?

    What is the difference between running a payroll report by period end date and running it by check date?
  • Timekeeper Collections by Period - Unassigned

    I thought I once knew this but I cannot for the life of me remember. A client is getting a line item for "Unassigned" in the Timekeeper Collections by Period. Does anyone know where this comes from? I wish I could remember!!!
  • Auto Run a Daily Report in Sage 50 US - is this possible?

    I need a report that will run at the end of every day with any inventory price & cost changes +/- so we can be up to date on our pricing. Is there a way to do this automatically and possibly have it write over the report run a day prior? Thanks!
  • Creating a Parameter and Filter to Only return last 5 years out of 20 years of data in the report - This is a Consolidation Financial Report and has a Standard Report named Fiscal Year

    I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…
  • Tax Liability Report and Payroll Tax Report State SUI is not calculating correctly

    The Tax Liability Report and Payroll Tax Report's State (GASUI) does not calculate correctly. The line item Liability Calculated on GASUI has the Tax Liability calculating correctly.
  • CUSTOMER STATEMENTS

    Why is it impossible to print statement of accounts reports in SAGE 300 simultaneously across a number of workstations? When one of the users in a given workstation tries to print a report and their is another user who has opened this module, the error…
  • Accounting Balance not equaling Customer Open Total on the Customer Statement

    We have an email that goes out with the customer's statement. The Customer Open Total on the Customer Statement is $0.54 off from the Accounting Balance that is sent out in the body of the email. This is the formula that is used in the email: "BLCC":…
  • Sage Intelligence using Fiscal Year 4-4-5

    In Sage Intelligence if I run the report Fiscal Year Detail, the start date is not accurate if you are using a 4-4-5 Fiscal Year. The formula used to calculate the start of the month is not accurate and is off by days, resulting in incorrect period…
  • 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…
  • Customer Discount Report

    Is there a Report I can run that shows all my customer discounts?
  • 1099 report

    I updated the date in AP for the current year, but the misc 1099 report is still pulling amounts from 2023. How do I get it to populate from 2024?
  • GST included in Sales

    Hi all community members, I made a Tax code for GST which is included in Sales. When I make a sales invoice lets say $100, it does not show GST amount $4.76 in GST column at the bottom of Bill but when I post it and see in sales account then it shows…
  • report for balance of inventory of what was produced

    anyone know of a sage standard report, or how can create a report, where can get the balance of what is in inventory of a given point in time of something that was manufacturered? I'm drawing a blank on where to start. know it would be stock transactions…
  • Quantity sold from finished goods produced

    Does anyone know if there is a Sage standard report that can display the quantity sold to customer from what was produced via production tracking?
  • Item cost price and selling price

    Hi dears, is there is a report in sage 300 that shows the cost price and selling price for the items, or how can i extract them.
  • Client Average Days to Pay Report

    I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,
  • how to link to remote SQL server / Sage Alerts

    We have just upgraded to Sage 2023 Premium, the SQL version. We use a remote database to store metadata about our items. When we were on an older version of MAS 90, we copied the table data from the remote server to a SQL server on our LAN. And we…
  • User defined "Number" option has no decimal places. Is this new?

    I'm sure I've used the usrdf1/usrdf2 in places and changed it to be a number value, but i have noticed lately that when i change it to number it is only accepting and integer and not a decimal. I know i can make custom fields but i avoid them as they…
  • Closing Accounting Month Issue

    When trying to close my Accounting month, for the last 4-5 months, I get an error advising "GL Master File in Use" and the Accounting cannot be closed. No one is using the Master File when trying to complete this task and the only way we've been able…
  • How to enter dollars and cents in a payroll quarterly

    Hi! I would appreciate any help with this, it is driving me nuts. Payroll Quarterly Reports what do I need to do to be able to put dollars and cents in the reports. I cannot put a decimal after the dollar amount for the cents? There has to be something…
  • Change the Year on the Report

    I am running my first 1st Qt Report in Payroll my 941 says 2024 my 940 says 2023. How can I update the reports for the correct year? Thanks, Penny
  • Incapable d'imprimer rapport

    Lorsque j'essaie d'imprimer n'importe quel type de rapport (balance de vérification, versement de paie, etc.), le message indique que la mémoire de l'imprimante est pleine ou que les informations de l'imprimante sont incorrectes, mais je n'ai rien changé…