Sage 100

Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…

I am adding the Creator (2 or 3 initials of our team) of a Sales Order/Work Ticket on the WIP Report. It only comes up on part of the Work Tickets listed. I have tried to compare of what has hours applied, what has parts, etc. Is there utility I should…

if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version? we had an employee accidently create a customized panel and it is not correct how can I get her back to…

I've created a custom script to record changes made to the order status of a sales order through a generic shadow table format but I'm having issues getting the time to record properly in the UDF_TIME field specifically. I'm not sure what could be causing…

I would like to automate some Visual Integrator Exports. However, I need to use the Select Tab to make sure each time the export runs the correct records are selected. I found the following formula helpful on the Sage Knowledgebase...and it works based…

I am trying to pull history for certain dates. There is not a column to be able to choose dates through the builder. How do I add this option to the sheet? TIA - Tracy

So if I was to attach documents to a sales order through Memo's, is there a way to print them when the Bill of Lading is printed?

Hi All, Is there any way we can increase the decimal points from 2 to 4 of a numeric field or any standard field? Please help if anyone have an idea. Thanks,

Is there a way we can add an "on-the-fly" text field that will show up on printed labels through Inventory Label Printing ? Our previous ERP system had a textbox on the print screen that allowed the user to type in a custom remark that then printed out…

We have office staff who need to clock in and clock out daily. Is there an add-on that can be used for this? And an easy way to import the time into Daily Payroll ? Thank you!

Our company has always charged a % of the order total for a shipping fee. I don't believe this is possible using shipping rate maintenance since I wouldn't want to have an enormous table with every possible price to the penny... This has left me looking…

OK, friends! If either of you can solve this for me, you will be my hero for month! Lol I have created a custom report that is sorted by Customer Number. Main tables involved are AR_Customer and AR_CustomerSalesHistory . I need for this ONE report to…

Hello, I'm trying to building a custom container using the SAGE Intelligence Reporting Connector. I would like the information in both the AP_InvoiceHeader and AP_InvoiceHistoryDetail table to draw from. When run the following query with any polarity…

Hello Everyone, I am attempting to put together this ODBC query against the Sage database, and I am trying to return values from the past year, specifically using this parameter: WHERE AR_InvoiceHistoryHeader.InvoiceDate > DATE_SUB(now(), INTERVAL…

Here is what I am trying to do: basically UDF # 1 will have options A, B, and C. UDF # will have options A through Z. If opton A is selected in UDF #1 then the user will be able to select A-D in UDF #2, if option B is selected in UDF #1 then user will…

Hello, I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…

I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…

We'd like to take a sales order form that SAGE 100 emails to customers and instead run it through the Docusign API. This would allow our customers to e-sign for custom orders instead of printing out, signing, and scanning forms. Has anyone done this?

Is there a specific Sage 100 table to use for a custom Crystal Report, that will show a list of all users currently logged in to the Sage 100 ERP system at any given moment?

Hello. I have created a custom Crystal report showing sales by Salesperson code. I realize there is a "standard" report in Sage already, but our director is wanting one that exports to a clean Excel format. A couple of issues... 1. The custom report…

Hi, on Sage 5.1 , I created a Crystal Report, and then loaded the report with Report Manager, How do i grant users authority to run this report, probably a very basic question but appreciate any help. right now you can find the report in custom…

Does anyone know if any Sage 100 Add-ons for food producing companies? I have a client that would like to record Safe practice information and make tracking Inventory easier. For example: Mixing raw ingredients sometimes causes tweeking so instead…

I'm trying to create a custom dialog button in custom office on the SO Entry Detail screen to show some UDFs. The button would need launch a screen that allows me to put some UDFs that are linked to the line. If I create a custom dialog button in that…

We are running MAS ver 4.4008 and would like to find a way to automate our print sheet printing. We have the Custom Office and VI modules and I was wondering if someone knows how these could be used. I know about customizations that exist but we stay…

I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables. I want to have the two…