Sage 100

Hello, I'm trying to export the history tab of Item Inquiry window (see above) to excel sheet for reporting purpose. I created query which pulls data from the table of IM_PeriodPostingHistory. However, the beginning quantity of each month shows 0…

Getting stuck on this script, I've tried a column post val on the qty received and a table post read. Both are getting stuck at the same point, on the first "retVal=oSOLines.MoveNext()", should it be MoveFirst? Dim sPurchaseOrderNo Dim sSalesOrderNo…

v2022.2 Standard, Column pre-validate on InvoiceNo, as the only script active on the table. Basically the script checks if the user is allowed to enter an InvoiceNo, and does a SetError (when a specific Role permission is active). The column pre…

I'm trying to use the SetBrowseFilter method with an external script using the AR_Customer_ui object. and the InvokeLookup method. I need to show only Active Customers with a SortField set to a value. I can't seem to find any documentation for the SetBrowseFilter…

Hi, I am trying to find a path from the GL detail back to the AP/PO data where Job number is recorded. Wanting a query to do this instead of having to manually track down the PO lines. Is the same Sequence Number field that appears in the GL_DetailPosting…

I am seeing duplicate countries in my country list under country code maintenance. For example it will show the country "France" twice with the codes "FR" and "FRA". What is best practice in removing these two digit country codes from the country list…

I'm receiving a cryptic error stating "IM_ItemWarehouse" does not have correct permissions when I do a SetKeyValue and Find via IM_ItemWarehouse_bus (and _svc). Code is below. I've also tried using a SetBrowseFilter and that works until it reaches the…

Hi there! I'm a fairly new Sage 100 user and work in a call center that handles sales for multiple warehouses. I get a lot of questions about the availability of products and in different sizes (which we use different item codes for). I would like…

In GL_CompanyActiveBatch it appears the batch status field is always blank. Trying to write a Sage Alert that filters out any batch "in use". Is it even possible? Sage 100 v2021. Thanks.

I want to do a search the excludes any Job that starts with the letter "C". Is there a carrot or symbol that can be used as a wild card to maybe Not Equal to C* to filter them out? As shown in the picture below I have some jobs that start with a zero…

I'm hitting a wall. My client wants a column in Sage Intelligence to pull only total of net activity for a specific day instead of a period. It has to do with accruals. They don't want to enter accrual journal entries. They want to keep the expenses dated…

I'm working on a button script where I'll be looping through multiple Sales Orders, and sometimes an SO will be locked (e.g. when it has an invoice being processed). oSalesOrder = oSession.GetObject("SO_SalesOrder_bus") Set oSalesOrder = oSession.AsObject…

A customer has asked for a way to update pricing on 1000's of SO, for some planned pricing updates they working on. My idea was to have a button script to loop through all SO, and all lines on each SO, triggering the Sage logic to calculate each line…

Is it possible to search within the SO Detail "Comment" field for a particular word to post-write a check mark in a UDF field?

We are upgrading to Sage 2021 from 2017. The MP_04SuppliesAndDemands view has been retired from Sage 2021. However, my staff does not want to give up the (very robust) MRP tool we developed in house. Consequently, I need to recreate it. Can someone provide…

I'm new to Sage, using 100 Advanced. For SQL, why doesn't this script work: SELECT * FROM (SELECT ItemCode, QuantityOnHand WHERE Warehouse="100" FROM ItemWarehouse) AS STUFF Please disregard spelling errors (if any). I've used this style of…

Looking for opinions on if the the one to many scenario in Sage 100 can be created with Custom Office: one item # to many different models for example. The goal is to be able to search a model # and see all the item numbers that are compatible with that…

I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?

Writing a script (with role check), where I want to prevent a user from editing a customer's credit limit (ideally preventing a non-admin order entry person, with Customer Maintenance access, from raising a credit limit... without going through an approval…

Hello, I have a request to setup an aggregate query linked to an email event which lists the total sales by salesperson for the day which is pretty straightforward; however on this same email they want a breakout of those sales listing the order number…

Hi Everyone, I am wondering if there is a script that can be written in Excel to look up an item number in SAGE and return the required date back to the excel sheet? Following the screenshots below I would like to have excel pull the next required date…

Is there a way to paginate the GetResultSets() function in boi? I'm thinking sort of like how in SQL, you can use OFFSET and LIMIT to divide the query results into multiple pages. Is there a way to do that with the GetResultSets() function?

I am trying to ask a question about querying historic aging but for some reason the question won't post? Is there a limit on question size or attachments?

Huge thanks to David Speck for your code and your expertise. I've got a script that works well for printing all SOs, but I'm trying to filter it down using a UDF Date Parameter ( UDF_Delivery_By) we have in SO Printing. I'm certain I have my syntax…

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