Sage 100

I'm looking for existing script I can use to simplify our need to run a custom report during our quoting process for every order. Can anyone help me create a script that will calculate the entire Gross Profit/Margin for the whole Sales Order and display…

I've been trying to find a way to just check BOM if the raw material item open in Item Maintenance is a component of a BOM. It appears there is a FindWhereUsed Function of BM_WhereUsedCommon, but I haven't been able to get it to work. SET oBM= oSession…

Hi All, I hope this is something simple.. I'm getting a retVal of 0 when pulling the Product Line, but nothing in the sLastErrorMsg. The message box displays nothing for the error. Other GetVals are working. Am I doing something wrong on the GetVal…

Without going in to the whole story we are trying to update some fields for auditing purposes and don't want the user to have the option to not save the changes to the order thus not having a record of the auditing information we are looking for. I have…

I want to link data in a detail line of PO Material Requisition Issue Entry through to IM_ItemTransactionHistory. But when I try to pull a data value into the IM_TransactionPosting table, none of the Business Object sources listed are from the PO Mat…

I have created a JobNumber UDF and added it to AR and AP invoice data entry line detail. Now I would like to create a User Defined Script for the actual Job Number entered during data entry to be written to the JobNumber UDF. In AR it comes from the header…

I want to add field [Category4] from CI_Item to the Item Maintenance, but can not seem to find it in Custom Office User-Defined Field and table Maintenance. Can anybody help with that? Thanks.

I have created a script, and it does not seem to work. Do I put it under column validation, or some other mode. Here is the script. Retval=0 rExtcost rExtamount=0 rQtyship=0 rUnitcost=0 rLineGM=0 Set oLines = oBusObj.AsObject(oBusObj.Lines) oLines…