Sage 100

I am trying to script copy the SO Line comment into a Work Ticket header UDF. I have opened an object (SO_SalesOrder_bus), can read SO header values, and SO detail values (ItemCode, ItemCodeDesc...) but when I try to read the CommentText field, nothing…

Anyone ever do something like this? On Sales Order Detail, I'm trying to check (via script) if the current line being added is being inserted between 2 existing lines on the SO. I attempted this by checking LineSeqNo values, but I'm not getting the results…

Moved from providex to SQL and have alerts that used a filter for GL_DetailPosting.DateCreated is greater than or equal to the {%Last Date/Time Event Checked%}. Now that we are on a SQL database, the event won't trigger due to needing the date and time…

I inherited a custom-built program that talks to SAGE. The program relies on the following query to work: SELECT AR_InvoiceHistoryHeader.InvoiceNo, AR_InvoiceHistoryHeader.InvoiceDate, AR_InvoiceHistoryHeader.Last4UnencryptedCreditCardNos FROM AR_InvoiceHistoryHeader…

Would anyone be willing to share a SQL statement that tracks “Changes” in a SQL Server Database? I'm trying to use Sage Alerts and Worksflow w/Sage 100 Premium and I want to be alerted when a SO field changes from "Y" to "N" and have to use the SQL view…

Hi Guys Is there any way i can create a filter that shows only Purchase Orders that have items on back order. When I sort my purchase orders by OrderStatus "B" I get a lot of orders coming up that don't actually have any back orders. Any Help would…

How do you add the Drop Ship yes/no field to the BIE Sales Order View? Or, create a new view that shows orders with Drop Ship line? Sage 100c 2016 (soon to be 2019) thanks! Ann

I'm writing a button script which must run on the client (for an InputBox), so business objects are not available (otherwise I'd just use oSession.CompanyCode). The list of Variables (for AR Invoice History Inquiry) doesn't have anything I can use.…

Is it possible to filter the records when using the Next / Prior navigation buttons in a panel? Using the Payroll...Employee Maintenance panel for example, I know it is possible to filter the Lookup list when selecting an employee, and I have my default…

Is there a way to select the field and sort direction (ascending/descending) for a list box such as Invoice History or Item Transactions? If a script is needed, what method/property should be used? How does Sage determine the default field and sort…

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…

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

I want to create a calculated field (say Gross Margin) in the Item View Explorer. Calculation would be (Standard Price- Last cost)/Last Cost. However there are several items that do not have a last cost yet because there has not been any inventory produced…

I am trying to script some sort of data flow from the receipt into the Landed Cost panel / table, but nothing seems to work. I want to calculate a value based on receipt lines (conditional percentage), and write that value as a Landed Cost... without…

Hi there, I saw that there were other posts on this topic but I didn't see a solution and the posts were old. I'm wondering if it is possible to change the default Date Range for the Item Inquiry. I desire to always see all the transactions when I…

Have a client on 2017 and one user cannot see the Public Views in Business Explorer. They have the Security check box to be able to modify, but can't see them in the first place. Tried switching Classic/Standard and can not see in either launcher, and…

I would like to know how to add a custom field that is listed on our sales order entry screen to the Customer Maintenance/Customer Inquiry tab 6. Invoices screen as a column next to the Customer PO No. column. Is there an easy way to do this myself?

(Tested on v2017.2 Standard and 2018.3 Standard). I stripped my script to just a loop through oLines on a panel UI script (see below script code ). With this active, when I add / edit lines, then click off the tab then back to pLines, the lines on an…

v2018 (so scripting in JC is possible). I'm writing a script to override the GL account for Job Posting Entry lines. (Detail PreWrite event). I can get the override to work, with a SetValue but the grid does not refresh with the new value. retSet…

I have a customer that has a very large number of items with lot numbers. Their products are lumber of various dimensions. 2 x 4 x 10 or 1 x 10 x 12 etc. We want to add a UDF or possibly an alias that will allow a lookup of a all "2 x 4"'s or all…

We have over 2,600 Item Codes in Inventory. Looking for a "tool" or method to perform a "search and replace" of portions of the Item Description and Extended Description fields. Any suggestions?

So I have a button script that I use to "repair" some records that are not getting completely processed. Here is the section of script that is at issue: retVal = oEquipMaint.GetValue("EquipmentKey$" , equipKey) retVal = oMaintOrder.SetKeyValue("EquipmentKey…

Hi All, I recently upgraded a client from MAS200 4.05 to version 4.30. In 4.05 they had an import for AP Invoice entry with perform logic to search AP4 for duplicate invoices. Here is the old logic that worked: 0010 IF AP4_CHN<>0 THEN GOTO 0030 …

Event script on SO_SalesOrderDetail, trying to set SalesAcctKey$ to a GL Account number (not key), and expecting the key to be looked up automatically (like what happens in Visual Integrator imports) but that isn't happening. Do I have to look up the…

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…