Sage 100

For anyone familiar with setting up AR invoice printing form codes, do you know how the crystal report determines the maximum number of digits a field can be? We have one where it's saying a field has a maximum character limit of 15, but it's set higher…

I'm interested in developing or using some method so I can quickly generate a .csv, or some type of document openable in Microsoft Excel, which will show only a list of product names, (selected based on their inventory cycle), and next to them, their…

Afternoon, For Sales Order: Curious if we have any control over the SO Order Type. Specifically we want to remove Master Order & Repeating Order as an option. For Sales Order Invoice: Same for Sales Order Invoice Data Entry. We would like…

Is it possible to modify the name of a report that was added to our AR Custom Reports menu?

Haven't had any luck finding an answer to this so hoping you all can help. Currently when you search using the "Description" option on a web search, it only searches Item Name (short description?) and not the Long Description (extended description?…

Hello, We are looking to automate statement printing for our customers. I looked through the "Task Scheduler" provided by MAS and noticed that this was not an option. I have no experience with this sort of thing, but it seems that this should be possible…

Hello. I have noticed that Loaded Weight on the Shipping Ticket is usually about double the actual weight so we have to write the weight on the piece of paper. On one Shipping Ticket I checked the weights in the system and it adds up to about 13,000 lbs…

Hello All, I have added one custom Report to Custom Reports to one of the menu, by using the report manager, Now I would like to change the name of the report, so if I go back to "Report Manager" and open a "Custom Reports" in "General Ledger",…

Is it possible to change the name of the modified canned report? if so, how? Thank you.

Hello, Is it possible for change the work table selection criteria? Because I have modified on of the canned report and in the modified version I would like to eliminate some of the customers. Any advise/help as how to achieve that? Thank you.

Hello, Can some one please guide me as how do I copy a base line report that is using the work table and modify it as per our needs? I tried to copy one of the report open in crystal report and modify it and then put it back in SAGE, now when I tried…

Hello, I decided to try using a Business Insights dashboard for looking at the A/R. When I view the A/R Analysis report, the first Aging Period is correct for today. But the ones displayed below are the last months of our 2014 Fiscal Year, and not the…

I'm looking for pointers on exporting data from Sage 100 into an Excel table with no page formatting. I can build queries to populate the required columns of information, but clicking the export button always renders a file with page header rows, page…

Just upgraded to 2018. All forms converted fine except pick ticket. Blank lines and header . Just "Bill Line 1, Bill line 2" etc. print. and comment in footer I remember this from years ago but forget what fixed it. ANy help??

Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…

On my Progress Billing report, is there a way pull in the "Description of Work" for only the items that have a figure in the "Current Complete" column?

We upgraded to Sage 100 2018, which came with CR 2016. I was having problems opening Designer from the check printing screen, so I opened CR directly and modified the form PR_Check1, which is supposed to be the preprinted form. However, no matter what…

Good day all, We have a system that uses Crystal report for .NET frame 4.0 it used to work fine on that computer. For instance, We normally filter by location, date, and other parameters report would bring up the correct information respectively.…

We created a custom report in Crystal Reports, and I followed the procedure for placing the report into the SAGE modules. However, when we go to run the report, it can't EXECUTE/RUN the stored procedure and says table cannot be found. Is there a default…

I'm trying to set up a report for an alert, after running an automated VI import. The customer (v2014 Premium) wants to know if there are any failed / invalid records. I know the data is available, because the UI can produce reports based on job results…

Script worked in 2015 Customized Template button calls the script. sh Run "windx://erp-xxx/9700/IM_ItemInquiry_ui ^" & JT_Template_bus_TemplateNo & "^ABC" Modified to new server name and port number Allow external access checked in Company Maintenance…

We have 10 active Company Codes. Each one has a set of core sales reports that are exactly the same except they pull the sales reps, customers & products from the specific company code. Due do performance issues I can't use dynamic parameters in the CR…

I want to add some info to General Ledger - > Daily Transaction Register Form. How to do with it?

Does anyone have a recommendation for which MICR font to use in version 2015? My client wants to stop purchasing pre-printed checks. Thank you [:D]

I have a custom crystal report to print labels out of MAS. I want to set a different printer as default just for this report. I believe that any custom report should save the printing information from the last time it was printed. But in this case it…