Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I thought I read a post about this, but now I cannot locate one.
When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not:
Of course we get this message, which…
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…
There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …
Everything works on the script except for the line that calls for the print
oRpt.Printout
(I tried oRpt.Printout(FALSE) but then nothing happens at all)
The line actually technically works, but instead of just printing the the default printer, the…
When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order?
Thanks
Trying to do a simple formula combining the PR Employee last name with the suffix. Both fields are PII fields. When I run the report data formula only works if employee has a suffix so I had to place the last name field in the report and then cover it…
I am passing a value from a subreport to main report and in the main report this is the formula:
WhilePrintingRecords; shared numbervar Cafe; Cafe
If there is not a match between the main report and subreport, Then it prints the value from the previous…
Hello everyone,
I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
Hi All,
I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…
Is there a specific field and/or table to use within Crystal Reports to determine when a G/L account was last used? This would be for the purpose of delete the obsolete account. Please advise and thanks!
T. Helm
To anyone out there who can help with this...I would be most grateful!
Our boss needs a very specific Item Sales History report for Fiscal Year '2016' that should include the following as COLUMNS ( if possible ):
Item Code, Item Description, Qty Sold…
I've searched through various posts and cannot seem to find an answer to a simple, specific question. Hopefully, someone can provide some input.
I have created a very simple Crystal report, using the SO_SalesOrderPayment table. I want the report to…
Sage 2016 SP1 The Extended descriptions are fine.
I need to write a crystal report that uses the Second line of the Extended description.
I am trying to use the Split command and it works for spaces, but I have tried the chr(13)+chr(10) for line feed…
Just started with this error in December 2015. Users of both DC Reader and Acrobat Standard XI, Windows 7 ,Mas 4.2. Not sure if MS or Adobe update caused the issue. Any help is appreciated!
I have reports that when I go into designer I see the ODBC connection and it not using the SOTAMAS90 ODBC connector, it has some other type of connection. I do not think it is correct and if someone can explain the connector and how to fix it I would…
So there is a feature that seems to be included in CR 2011 that was not available in CR XI. It appears that we now have the ability to change the XML Schema for exporting from Crystal. The problem is that I can't figure out how to utilize it.
Before…
I need to be able to review invoice line history for specific customers for a period in time(AR INIVOICEC HISTORY) Detail and Header). From that data I want to exclude specific items sold during specific date ranges(Sale items). Once I have gotten the…
We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…
I have written a report in Crystal utilizing dynamic parameters. When I run the report outside of Sage, it works fine and all of the parameters work as they should. If I add the report to Sage 100, the parameters no longer function properly. There is…
Deductions are automatically calculated but at times when an employee is on vacation, deductions are not calculated for that week for that employee. They are entered manually next pay period in addition to the automatically calculated deductions. What…
I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled.
Thanks for your help!
