Browse By Tags

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…

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…

Hello. Is it possible to run multiple general ledger detail reports at the same time, but have each account print on a separate page? I have to run up to 14 reports each month for 60 clients and if I could run 60 reports each month instead of 840 that…

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.

What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.

I just voided several checks for a vendor. How do I run a voided check report?

Form and Report Designer are still stuck in the1980's as text based editors. Isn't it time to upgrade them to a graphical UI? I'd like to be able to import an image of a preprinted form on a non-printing layer. This would make text and field alignment…

Your Sage 50cloud Accounts software has hundreds of great reports available, showing a wide range of information to help you run your business. With our Which report guide you can quickly pinpoint the report you need. Simply enter what you're looking…

Sage 50cloud Accounts has hundreds of great reports available to show a wide range of information to help you run your business. With so many reports to choose from, we've released a great new service that finds the best report for you! Read more >

Hi When I export a bespoke report to 'Data to excel' the data columns are not in the correct order: IE. Column G - PaymentAnalysis.Desc2 Column H - PaymentAnalysis.Desc4 Column I - PaymentAnalysis.Desc6 Column J - PaymentAnalysis.Desc10 …

Under the Order Entry Module I was redesigning a sales order to use for a commercial invoice. After creating a db calculation it would only display the number with no decimal places unless there happened to be cents in the calculated answer. I wanted…

Is it possible to receive automatic daily reports directly from sage using a scheduled time / date? So if i want a certain report to be emailed to me, or generated, it doesn't it automatically without me having to click on the report & criteria every…

I have created a proj: proj_title in the report view. I am trying to use the dynamic field in the Title: for the report. We are using Sage CRM for Sage 300 ERP v 7.1g. Thank you in advance for any suggestions or directions. Reg Cracknell

I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …

Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda

I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…

I got a problem regarding the sales order report printing , it keeps on loading but it never print . I'm just asking why was this happen . It only happen with this particular SO number.

Some fields in our X3 db were renamed. SEI process currently refers to old field names. Is it possible to remap field references in process? I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…

I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…

We have some 'straggler' projects from 2014 that are still active projects. It seems I cannot generate any Project Income report that uses a date earlier than Jan. 1, 2015 now that I have rolled over into 2016. That seriously sucks :( Are there any…

Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…

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…

Good morning. I have two visas set up in my accounting and made some simple errors that i then fixed (ex: using wrong card for transaction). that has been fixed. But now when i print out my transactions by account report for each card... the wrong vendor…