Sage 300

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…

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.

Hi, The scenario is like this: The Financial year is Jan - Dec 2021 while the transaction that entered in the system is until Jan 2022. Note that the user is not yet create new year as the transaction of Dec 2021 is not yet completed. So, here, how…

Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…

Welcome to the Sage Data & Analytics (SD&A) for Sage 300 Sage City forum! SD&A is a cloud-based business intelligence solution that can be integrated with Sage 300 to equip users with on-the-go access to their data. In this forum you can ask & answer…

Hello, I have a client with over 160 customized Sage Intelligence reports. They know that some of these reports have not been used by their 200+ users in a long time. Their IT staff is looking to streamline which reports will need testing as they move…

Using Sage300c for the first time. browser stucked on https://[IP.ADDRESS]:9113/#/Welcome Web/ WepAPI already set to allow admin access Any other suggestions ?

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.

I was doing some research and came across this blog post from Stephen Smith talking about the hidden Crystal parameters. Thought I'd add it here to be picked up by the Sage forum search engine. (From: https://smist08.wordpress.com/2012/09/15/reporting…

Hello, I have a client who uses Sage 300 and I file their sales tax returns for them and I cannot figure out the best report to use to find the sales tax information I need (shipping state, shipping city, amounts) without digging through piles of information…

I have a report written over a Single View. The tables used include: GLAFS, ARCUS, OEINVH, OEINVD, OECRDH, OECRDD, ICITEM. When I run my report in Crystal it runs fine. When I attempt to add it to the ACCPAC SAGE300 Reports menu I receive a popup warning…

Using Sage 300 Premium 2018, with Purchasing and Inventory Control modules. The PO Clearing account on the balance sheet has no means of reconciliation or audit report that proves the GL. I need a report that shows PO receipts that reconciles to the…

We are using Sage 300 Premium 2018 (Accpac) with the Job Costing module. I don't have a method of auditing the balance of the WIP balance sheet account. The balance is climbing, and it is as if transactions are being "dead-ended" there and not flushed…

Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018. When trying to print preview any default sage reports get error message. Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…

Hi all, My company hasn't been using Sage 300 (V.2016) to do budgets. Its typically been done in excel. I know it can be done, (use sage to budget) but don't know where to start or what reports i can print. Are there any courses just for the budgeting…

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…

Are you ready to start using Sage Intelligence Reporting to create your own reports? The next Intermediate course is scheduled for May 17. Click here for more information. It is recommended that you view the Beginner Anytime Learning topic first.

I've set a few criteria in optional field in Order Entry module, user will insert their data to each of the created optional field, now how can i show Optional Field data which have a few lines to reporting? It should showing all Order Confirmation although…

Get immediate access to a library of additional reports As your business evolves and grows, so too do your reporting needs. We understand that it’s not always realistic to wait for the next Sage Intelligence update to get your hands on the reports that…

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…

After upgrading to Version 14.1, some of our systems will not print Crystal Reports. When attempting to print we get the following error message. We have attempted to perform the suggested Resolution on KB 55371 with no results. Anyone have any ideas…

Hello, I am trying to install Financial Reporting for one of our users but am unable to locate the steps to do so. Can someone help me get this installed? Thanks -J

I have attached a screen shot of my Report Manager UI. I am on Sage 300 2014 PU 3. The panels on the screen are mixed up. Has anyone seen this behaviour? Thanks

Hello Friends, We are searching for consolidation tool for our client. I would be grateful if anybody can suggest any software or module for this We are basically looking for tool with following capabilities Basic consolidation Intercompany…