Sage 100

A client of mine is trying to understand how much of each vendors products their salesmen sold in the previous year. I've been attempting to connect reports in PBI & Excel to garner the information, but haven't had any luck. Any suggestions on reports…

We are struggling with an intermittent problem in Paperless Office; sending SO Invoices in Customer Viewer. The system will indicate the invoices have been sent with a "Y" yet they never hit our Exchange server. Our company has a Sage 100 Advanced V2023…

It appears that the beginning balance for period 1 is coming into the reports without regard to the beginning period selected. The subordinate transactions come into the report correctly, but the balances are all off because of the incorrect beginning…

We have 3 companies setup with Sage 100 Advanced. Last month (12/23) all 3 companies could email statements. This month, one of the companies has that ability greyed out. Where you select Electronic or Print, it is Print and greyed out. Can anyone…

How come when I add SY_State to get the state name it duplicates the InvoiceNo from AR_InvoicehistoryHeader. The only field I use is StateName from SY_State. And when I add AR_InvoiceHistoryDetail it freezes the report around 23,000 records.

Is there anywhere in Sage 100 - where I can print out all of our A/R credit memos for 2023. It is year-end and our auditors are requesting and it is way to many to scan and email. Any help would be much appreciated

Is it possible to general direct deposit paystubs for electronic submission, after you've accidentally printed them out?

We are looking to file our 1099s directly through Sage 100 since we are having trouble signing up with the free IRIS e-filing service. Do you have any instructions on how to e-file directly through Sage? I believe it's sponsored by Aatrix. Hoping…

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.

I have a question regarding how to look at bits of data from a certain vendor. Using the explorer views we are trying to figure out how to find a certain item from a certain vendor and how much we paid for the individual item for the past 5 years.

When launching Form 1099 Printing from workstation, it hangs at 'Creating Work files' but on the server there is an error message 'Microsoft Visual C++ Runtime Library Runtime Error! pvxwin32.exe abnormal program termination. vers 2022.2 - installed ird…

Receipt of goods is not asking to print all reports it is just automatically printing the Goods register and the Daily Transaction register. It is not printing or offering to print the back order register. If do a preview it does ask to print all but…

This year 1099 recipient copies seem to only available to print as 4 part forms. I have the 3 part forms. Previously, I could print the federal copies onto the recipient preprinted copy. Is there a way to print on the 3 part forms, or alternatively, how…

I am trying to build a report that will show me what companies a particular vendor is set up in. We have 53 companies. I am not sure how to join the company code with the vendor table to show on one consolidation report. Nothing seems to link well, any…

Can anyone help me with Fuel Tax Returns? I am working on the State of Mississippi but any information you can help with would be appreciated. I need to know what reports to run to get the information needed to fill out the returns. Thank You

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…

We have to schedule 4 different IRP types to run in the evening. Can this be done under Library Master > Task Scheduler? And how can we schedule them?

After migrating. to a new server, all the custom reports are missing. The reports are in the company directory\reports but do not show up when selecting the report in the modules. I can manually re-add them, but this is time consuming. Any suggestions…

I'm trying to run the 1099's for 2023 and when I go to run them after selecting new and putting in all the rest of the information I'm getting an Error #15 Operating System Command Failed, can anyone help? I've tried reinstalling Sage and the Forms onto…

How do I stop a script from triggering during the Sales Journal update on the Sales Order header pre-write?

Have had 2 clients (and I can confirm) that the Payroll Earnings Report in the latest Payroll update is not automatically changing the printer to Landscape when printing. Works if you manually change the printer each time, but I'm assuming since two people…

I need your kind help please, I am facing a problem managing distribution instructions for Sage reports, I believe it is a common problem and you have had it before, do you have any advice on how to fix it please. Hiding part of the screen.

Does anyone know if the creation of these cached reports is dependent on the configuration of the RDS server itself, or is there programming within the application that defaults to this location? The reason I'm asking is because I'm upgrading a client…

How to display AP PII information in a Crystal Report?

First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…