Sage 100

Hi All, I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....". On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write. …

I've added a field to the Employee Deduction file for the garnishment account number. Added it to the Deduction tab screen, but then realized I can display it there just fine, but I can't ENTER it anywhere! Can't modify the Deduction ENTRY screen. WHAT…

I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?

Hello, I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query. This needs to be run on the Client…

Hello, We are trying to set up our customer maintenance screen to look identical to customer inquiry, except for one tab so that a certain department can access just that one tab. To do this, I am creating a custom panel which locks all fields except…

Hello, I'm curious if it is possible to have a visual process flow button simply open a file instead of download it? I have a button set up linked to an excel document and another linked to a crystal report, but clicking these buttons causes an internet…

Hello, I have been struggling to get this to work for quite some time and am starting to go crazy! I have created a button on the Invoice History Inquiry which opens up the Sales Order UI, but I want to pass through a parameter so that the Sales Order…

Is there a way to add an additional header tab to a screen via custom office... say in SO Entry or PO Entry? Then populate it with whatever we want?

I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great. Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…

Hi Folks, my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend. is there a way to create…

I'm trying to create a mask for a string UDF that displays <blanks> for missing characters. If I use 000 000 000, the empty field displays the zero mask even when the field is empty. This is confusing as there's no way to tell if the entry is truly 000…

I am trying to write a script that will take numeric values that are currently stored in a string field and perform a mathematically expression on them. For example: Field 1 is 10 character String field Field 2 is 10 character String field I am…

I'd like to create an additional field in SO Totals that shows a fixed percentage of the sales order total and then, in a separate field, shows grand total (sum of order total + %). How can I achieve it?

I need an executable to run when the client Posts AP Batch to the Invoice Register. I cant add a user defined script to the AP Invoice Registry screen because i cant get to it with Customizer. Is there a way to get around this?

I want to add Cash Discounts to the Summary or History Tab in Customer Maintenance: Each tab is pulling cash received in a given period. I can not get the correct data to pull cash discounts. Any ideas would be great. I need to know the sales, cash receipts…

I am stuck and I think the following cannot be done so consider it a challenge to everyone to see if someone can come up with an answer that is not crazy complex. I have an end user that would like to track who picks up Sales Orders...picture a field…

I have two clients who get an error 29 error in definition of screen item when they try to open a customized panel if they have selected large font in Application Scaling in Sage 100c 2016 PU#3. Our current workaround is to have them use either the default…

Hello, I am trying to write a script for lookup button in order to pull the salesperson data. I only want to pull the salesperson data whose division number is “00”. How can I pass ARDivisionNo as parameter? Here is the script which I am working on…

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…

We have customized the sales order entry main header screen with 30 header udfs. This was done in version MAS9090 4.4 and converted in 4.5. We updated our client last week to Sage 100 2016. The sales order entry screen still looks the same and the udfs…

I have been using MAS since 1987, but have never used the above features. With the demands of customers lately I need to be able to email a variety of forms to multiple people within a company. Right now it is taking way too long to scan documents in…

I have developed a UDF on the shipping address info to designate the FOB info specific to a ship-to address. On occasion we may have reason to override this. I would like to have our sales orders and picking tickets default the FOB from the ship-to address…

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…

My client is using version 2013 of SAGE. Is their any way to create a lookup on the UDF field to pull from a standard ALE lookup in SAGE/MAS and return the value. Does anyone have an example of the custom office script.

I have a parameter field link to the CI_Item for Value Field, I would like to have only the Type 1 item show up in the drom down, what is the best way to manage the parameter field in crystal reports? or can I do something like this?