Sage 50 US

I have been tasked to create an Inventory Turns Calculation in Crystal, I have a report with all the items, a date range parameter and COGS calculation, Piece of cake. How would get average inventory? Is there a table that gives you historical inventory…

Regarding our customer sales orders, we have multiple items that ship from different vendors. Is there a way to enter the estimated ship dates for each line item and then create a report to email to our customer? Currently we create an excel spreadsheet…

We are wanting to run the 1099 report to see if anyone is missing their TIN. When we attempt to run it, we are not given 2023 an an option on the drop down menu. Our fiscal year runs from Oct 1 - Sept 30, so I am not sure if this is part of the issue…

Hi - With the disappearance of Intelligence Reporting, I have run into a brick wall on accurately accounting for and calculating the commissions that my sales reps get. I have tried to do it through the Invoice Register, but the report that it spits…

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'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…

Hello, I was recently hired to handle IT for a small company that uses Crystal reports 2008 in conjunction with sage 50. The Crystal Reports application was packaged with an older version of Sage and they have continued using it for some time. The problem…

Does Sage 50 2018 version include Crystal Reports licenses? I have a client that used Crystal Reports with an older version of Sage 50, but the client cannot find the installation CD or installation files.

Dear All, I want to print AP Invoice in crystal report due to customized layout. I want to bring Jornal entry in the form of Debit and Credit for AP Invoice, but I am unable to find the relevant fields in the JrnlHdr and JrnlRow, kindly help me in this…

If you use Sage 50 2016 - US Edition, and you run any custom Crystal Reports that utilize the GETPEACH formula, DO NOT LOAD THE 2016.2 UPDATE! Loading this update will break Crystal Report's ability to calculate any formula value that pulls from the GETPEACH…