Sage 100

Do you have to be a certified sage developer to access the API? The care support informed that you do. myaarpmedicare

We are using SQL Linked servers and are receiving the error [ProvideX][ODBC Driver][PVKIO]Invalid segment number in one company (JAN). We are getting this error when doing a Select * From GL_DetailPosting. (Other tables work without error.) We can get…

I have a script on the pre-totals event, that loops through any line items, and needs to get item related information for a given item. The problem I'm running into, is that in certain cases, the script runs, but the item information is returned as blank…

FYI, I've just gone through a new upgrade to v2021.1 on the weekend with strange errors opening Invoice/Shipping entry, and again after choosing an SO. Sage support pointed me at *ESC to isolate the issue to scripting, and I found the problems to be a…

Hi, Is there a cross reference list of what the WO tables/fields are now called/located in PM. I'm looking to make a new query for PM to replace what I had in WO coming from the WO9 table or WOO depending on Active or History. Thanks, Ryan

I have multiple queries that run in sequence to give me certain fields in the PO module. The main filter is the date created time stamp field. I have the query filtering to show only PO's created since the last time I ran the query. This is done through…

I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…

Hello All, We utilize a number of kits on a daily basis, and I'm looking for a way to check stock/backorder when a component is not available. This tends to cause a bit of an issue when receiving product and the backorder report doesn't produce the…

Hello, We are trying to run some basic metrics surrounding Back Ordered Sales Orders, i.e. "How many Sales Orders had back ordered items last month". Problem is, I can't seem to find any data fields in the SO_SalesOrderHistoryHeader table that would…

I would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case: sItemCode…

Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…

Need a tutorial on Pick Tickets Other than SO_PickingSheetWrk.M4T, where Sage end the picking process? There are no fulfillment functions in Sage, correct? How do the Pick transactions end in Sage 100 (without AddOn/Exteneded features Scanco etc…

Silent ODBC is working, but cant add a SQL linked server. error code below Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SAGE200". OLE DB provider "MSDASQL" for linked server "SAGE200" returned message…

I'm starting a script for account segment substitution (CoGS / Sales accounts on specific SO lines), and before I start testing different methods for getting the formatted Account number based on the key values (ChildHandle, open a new object...) I'm…

Are for each loops allowed in BOI vbscript?

I have this code in a BOI script (SO Header, PreWrite)... ... Set oPayment = oSession.AsObject(oBusObj.PaymentObj) retVal = oPayment.GetValue("CreditCardAuthorizationNo$", sAuthNo) retVal = oPayment.GetValue("AuthorizationDate$", sAuthDate) retVal…

Where do I go or can I add fields to the "Select Field" options that filter out what sales orders you want to group on one PO? I am assuming the fields in there are by default but it seems like there would be a way to add other fields, we have some UDF…

We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

Created a customized Accounts Receivable Invoice History Report that is to be sorted by a UDF. Parameter comes up and asked for the UDF and I choose one and then the report prints all UDF records. Any suggestion on where to look to see why the sort…

I previously worked with Sage 500 and was able to run a query from Sales Order lines and dump that data into excel and then manipulate it for my presentations and create pivot tables.This would brake down the sales order to the line level and provide…

I have a script in SO Header where I open Customer Maintenance, and I want to pass a Storage Var to that Customer Maintenance object (to change what happens in an AR_Customer post read script), but the values are not transmitted. To test, I created…

Hello, all - is the answer right in front of my face and I can't see it? Neither the Employee Listing (in Payroll Reports) and Custom Lookup View (in Payroll Employee Maintenance) seem to report part-time status in EE Maintenance; this status is indicated…

A customer has asked for an easy way to change the invoice date for an entire batch (without using VI). What I am trying is a button script run from SO Invoice Entry, opening a new object, grabbing the ModuleDate, scrolling through the batch and setting…

I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…