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…
I want to spool sage intelligence report using optional fields that I created on General ledger instead of using General ledger account or General ledger account segments on sage 300.
/resized-image/__size/640x480/__key/communityserver-discussions-components…
Hello everyone, I need a crystal report programmer to assist with designing a AR customer statement with following output:
1. Opening balance on account at every point in time the report is printed ie yearly or monthly,
2. outstanding invoices unpaid…
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…
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.
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…
Does a profit and loss report exist in Sage 50?
Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage?
I would like the report to include income, cost…
I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.
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…
Does anyone know what happened to the Additional Reports for Sage 50 Canadian Intelligence Reporting? It seems only US and Pastel reports are available.
I've been using the Purchase Analysis intelligence report, however I want to add the "Purchase Order No." (not JobID) in the report.
Sage has to be storing it somewhere, because we fill it out on every PO we input, same with "Unit Price". It is not…
I need BI Tools menu in Excel to export reports. It keeps disappearing from the tabs at the top. If it goes away, I have to reboot my whole computer to get it going again. Any help would be much appreciated. There are no warnings or dialogs that pop up…
We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…
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.
I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…
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…
How would you like constant access to a library of additional reports? The Sage Intelligence Report Utility allows you to select the reports you like and automatically imports them into your Report Manager. All you need to do is download and install the…
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…
Hello,
I keep getting this error message when attempting to e-mail myself a BI report created on our system. I'm not sure what the issue is but it appears to be generating based on the FROM send address. Perhaps it is a email server authentication issue…
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…
Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.