Sage 100

We run this task daily and are coming across some inconsistencies. It appears when purchasing runs this task (we run it per vendor no), it will generate the purchase report, then they will generate the PO after reviewing the report maybe 2-5 minutes later…

I would like the Check Transmittal to print by Invoice number (lowest to highest) rather than by invoice amount (lowest to highest). Does anyone know how to do this?

Hello.. this one is a totally new one, never have dealt with commission report. Sorry if the question might be to vague because not how to state it. So why doesn't the commission rate show on report for a debit memo... for one salesperson he was a…

I have a question regarding how to look at bits of data from a certain vendor. Using the explorer views we are trying to figure out how to find a certain item from a certain vendor and how much we paid for the individual item for the past 5 years.

Receipt of goods is not asking to print all reports it is just automatically printing the Goods register and the Daily Transaction register. It is not printing or offering to print the back order register. If do a preview it does ask to print all but…

We have to schedule 4 different IRP types to run in the evening. Can this be done under Library Master > Task Scheduler? And how can we schedule them?

After migrating. to a new server, all the custom reports are missing. The reports are in the company directory\reports but do not show up when selecting the report in the modules. I can manually re-add them, but this is time consuming. Any suggestions…

I need your kind help please, I am facing a problem managing distribution instructions for Sage reports, I believe it is a common problem and you have had it before, do you have any advice on how to fix it please. Hiding part of the screen.

How to display AP PII information in a Crystal Report?

Hello all again, I've been getting some very good advice here lately, thank you all! I create a custom report in the "Item List" that includes "Total Quantity On Hand". The issues I have is when the report shows a negative qty, however the Item Detail…

Is there a report that will pull the contract amount for jobs? I need the contract amount for a group of jobs vs what has actually been invoiced/paid.

Is there a way to view past IA transactions in detail and not just the GL accounts that are being hit? Is there anymore detail available than the information below?

I am working customizing Quote Forms using crystal reports and we have a standard text on each specific quote. This standard text will not show up on the sage preview. It is like somewhere in the report its blocking a view in some of the groups. Any Ideas…

I am on a mission to shrink our PC report, branching off of this post I made previously, https://communityhub.sage.com/us/sage100/f/unique-business-challenges/211318/drop-ship-po-s-in-purchases-clearing . After speaking with AP they stated some of our…

Hello, We have invoices that display unneeded line items which confuses the customer. Is there a way in Crystal or Sage to hide those line items when printing out invoice

Hello - I'm trying to print all the purchase orders made on a specific date - but the "Purchase Order Printing" module has no filter currently for date. Is that something I can add myself? Or does anyone know of another way I could accomplish this? …

Hi guys, Would you please lend me your hand in finding the table that stores beginning qty (and also value) for inventory? Basically, i'm trying to replicate the "5.History" tab in Inventory Inquiry. I've looked into IM_PeriodPostingHistory, IM_ItemWhseHistoryByPeriod…

is there a payroll report to use for the annual OSHA 300 report that excludes hours and wages for vacation hoildays and sick days

Hello, Our Ops Mgr. Is looking for a report or log that shows users activity with sales order? Like a audit trail, trying to eliminate S/O errors and trying to determine who is making them. Thank you!!

Hello, For one PO we received two different invoices since products were shipped separately. For a line that was for the sales tax, it was used twice when receiving the two invoices instead of a second line being created for the second invoice's sales…

I made the mistake of not printing any of my period end reports in AP Module only. I closed all the periods through period end processing. Is there a way I can print these reports now?

I had entered an invoice in AP → Invoice Data Entry instead of using PO → Receipt of Invoice Entry. When I run the Open Purchase Order Report. The PO is now Backordered and it shows as the item being ordered and received, but not invoiced. The invoice…

Hello.. This is more a Crystal question than Sage but I thought what the heck maybe someone out there has a quick answer. So I'm trying to add the Invoice # field to the report however when I add Inv# from the AR_InvoiceHistoryHeader table the report…

Hi, Any way I can get the user ID / Logon name to print at the bottom of a work ticket? All i am able to find are fields for the user that created or updated the work ticket, but not the user who actively printed it. Thanks, Ryan

Is there an option to run customer statements for customers with a balance less than a specific amount? (Ie, less than $100.00)