Sage 100

I've developed a script that, for some customers, discounts TX ItemCode's to absorb their AvaTax calculated sales tax and present a invoice total including sales tax (but not freight) equal to the original net invoice, but when the invoice is imported…

I am trying to launch either BOM Inquiry or Maintenance using an InvokeProgram or Process User Defined Script, but any time I add the Bill I get the error "You do not have security rights to create the record" but I am not trying to create a record. Any…

Hi all, Does anyone have any suggestions on how to incorporate user-defined functions and additional sub routines in UDS? I have a working (pseudo-codes below), intended to be assigned to Table_Post-Write event for AR_Customer_bus. Basically, there…

Hi everyone, could someone please tell me if a different object is processing IM_ItemWarehouse? I was testing out copying QuanaityOnHand of a certain warehouse to a UDF in CI_ITEM but it appears the script attached to Table_post-Write wasn't even firing…

Hi everyone, I see many examples of processing a report in BOI, like this one . But all of them are VB/.NET or C#. Could someone please help me translate the syntax to UDS work with Events like Column_PostValidate? Below is Bret's example of Previewing…

I need help. I created 2 numeric UDF's for CI_Item; PACK and EACH_COST. I wanted to automatically calculate EACH_COST by taking the Item's Standard Cost and dividing it by the PACK. I searched SageCity and found a simple script and modified it. I…

I'm trying change sales order detail lines upon the user clicking Accept of a Sales Order. For example, the script below is supposed to override all the quantities, and set them to 1. Set oLines = oSession.AsObject(oBusObj.Lines) oLines.MoveFirst…

I have been using UDS and BOI for a while and understand how to launch UIs. I'm just having trouble finding how to open the screens for searching. Specifically the Contact Code List that can be opened from Customer Maintenance by clicking on the magnifying…

Is it possible to use SetUIOptions for a text field? I can't figure it out if it is.

I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total. The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount. I don…

We have steel surcharges due to market pricing that need to be added to invoices for certain parts (separate charge). I have written a script that will add a line to the table when one of those items is entered. It works, but I wanted another set of eyes…