Sage 50 US

I would like to add the data [customer_order_number] into the statement payout (in place of details) but I cannot find the field in the options ; any help appreciated!

Hello,

We're starting to utilize the inventory reorder worksheet report, and we can not figure out what the difference of the column options are for "Quantity on PO" and "Quantity on Order".  The figure seems to be the same, but…

We are wholesale greenhouse, currently we don't track our inventory through sage.  The inventory items are grouped under the container they are grown in (10" hanging baskets, 1203 Flats, 1801 Flats etc.).  I am trying to get our inventory to be…

I'm a long-time Sage 50 user but recently upgraded to Sage 50 cloud (Quantum). I've been working on customized versions of standard income statements and came up with a good summary report we want to keep using. The problem is, I logged in one day and…

Is the Report Designer available for Sage 50 Accounting users?  The options in the package itself are VERY limited, and I would like to customize some reports.  Thanks for any info!

Jim

Hi all,

I just got this all figured out and figured I'd document this here for future me and anyone else who might need it.

I typically use the Sage 50 .dat file documentation when writing SQL queries in the connector: https://help-sage50.na.sage.com…

I migrated from decades of Quickbooks, and am still learning this new system.  I created a custom report for our Simple IRA (Quickbooks had one).  I needed a report to give me each employees gross earnings for the week, their contribution amount to their…

How do I  create a custom container in Connector that will contain the Job information that Sage pulls from to create the reports outside of Intelligence Reporting from the Job Reports: Project Information area? 

The report we are trying to create will…

We have installed a copy of XLGL and it seems to launch properly. However it is only showing us the standard forms that SAGE has in it not any of the modified forms that we normally use. How can I get it to locate and use the modified forms?

We currently use Intelligence Reporting to gather the Last Purchase Date for inventory items. Once Intelligence Reporting is discontinued, is there another report I can use to obtain the Last Purchase Date to age inventory?

We are looking for a consultant to assist our accounting manager with creating some new reports. Sage Experts don't have any appointments until April!

We are the manufacturer, distributor, wholesaler, and retailer of our given product, since we are the only ones in this country who create it. Looking to pull a basic piece count out of the total Sales Orders for a given amount of time), to get a projection…

I'm looking for a Sage Consultant that can build a customized report within Sage 50.   We need to report on the following by month, by manager, by customer:

Hello! I have Sage 50 and also the Intelligence Reporting. My question; Is there any was possible to create a report that is the cash receipts journal that has what the total $ the invoice is for whether or not if only 50% of it was paid? I can get the…

Hi,

I have Sage 50 US Quantum 2020 edition.

How can I make a copy of a standard Intelligence Reporting, Jobs Profitability Report, into the Report Manager so I can modify it. I need to modify it a little and regularly email to someone in the company.

ERROR MESSAGE: Wrote a report for a client who was on Sage 50 US v 2020. They have now upgraded to v 2021 and also purchased a new server. The client asked us to make updates to the report which we did. During delivery, selected "create a new container…

What is the procedure to write custom crystal reports to calculate commissions.

We have some Custom Crystal Reports that link with Sage 50. I recently did the update for Sage 50 and now the Crystal Reports aren't linked. I know there is a place to update/relink them but can't find it. Anyone know where I can find that?

I have several custom reports created that pull in employee SSN. After installing 2020, the values returned for employee SSN are scrambled.  I am assuming this data is now encrypted... but not sure.  Tech support is no help.  None of the agents even have…

I'd like to create a customer list that shows the names of files that have been attached to each customer. But I can't figure out how to join the customer table and attachment table. I created a simple report listing all fields and records in the attachment…

I was wondering if a support group member has created a report, in the correct format, to upload via Berkheimer website in PA? I'm frustrated with manually entering the info each quarter and would very much appreciate any assistance. Thank You!

I suppose to be able to have a white arrow to increase column width, but it never shows up when I hoover over the blue marker of each column.

Called tech support and they said custom reports are not in their scope and they cannot help me.  I cannot run my reports I've developed over the last couple years.  Need Help Please.  I even tried starting over and Sales Analysis works but when I strip…

Our company has a need for a report that does not come with our Sage 50 US.  In other words, I am looking for someone who works with Sage 50 US and can come up with a report to query the information we need.  However, I am having no luck finding someone…

I used to have a report in crystal reports that allowed me to choose a product and then it would list the customer who bought and how many they bought.. I cannot find anything like it in the current program. Is there a way to create that report in the…