Sage 100

I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.

I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…

Morning, I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)? {SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…

Hi, I want to add a UDF in the JT_Employee table and within the UDF maintenance I see i should be able to use a UDT to limit the options being chosen. When I select the UDT validation button, a few UTDs are available but not the one I want. How do I…

Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?

Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?

I am trying to hide tabs 3, 4, and 5 for Customer Maintenance for a specific user. I know I could set the fields on the tabs to hidden, but the user wants the entire tab to be unseen when looking at Customer Maintenance/Inquiry. I cannot delete the tabs…

USING SAGE 100 ADVANCED 2021. Is there a way to create a warehouse that does not apply any unit cost to an item? we want this new warehouse code to hold items that will eventually be replaced by the factory. so if we receive a container full of…

I need to create a sales order form for KnowledgeSync. I can't get the lines to print in the correct order. The standard sales order form created from the sales order work table has a "Group" that I'm assuming is what gets order lines to print as displayed…

I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…

Hi, I found a thread about a somewhat related customization, but it wasn't quite similar enough and I wasn't able to learn enough to be able to use the information there. I'm trying to setup my sales orders to print to different trays based on criteria…

Hi everyone, I have a phone number field in the Sales Order Entry task, which appears to be a customization someone added at some point. It’s not a default field, right? The text label looks a bit different than the other fields and sometimes it seems…

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…

I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report. I need to create a summary report that includes data from both tables. I'm hoping that someone has…

Hello, I'm trying to modify my picking sheet so it shows which Sage user created the sales order. I'm using Sage 100 ERP 2013 and Crystal Reports 2011. I have "SO_SalesOrderDefaults" added in Crystal Reports under Database Fields, but when I add …

Hello, We are making some changes regarding taxes at our company and are wanting to change the default tax class when adding new items. Currently, when a new item is added it is assigned 'NT' (non taxable) tax class, and we want it to default to …

I am using BOI to automatically create production entries in BOM in Sage100 ERP. I realize Sage100 ERP support is obsolete, but it is what our company still has and we plan to update in the next year. I have some code I threw together below for testing…

Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…

Hello everyone, I received existing import job with defined perform logic The import job contains Command "CREATE_ERRORLOG" on Failure. Сan anyone tell me where I can find this error log? Also, Is there a link where listed all available commands…

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…

Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table? I've tried creating an UDF via CM under SO Additional Picking List Work, but I…

Hello, Does anyone know how I'd set a default option on a drop-down? For example, in Check Printing, I would like Stub, Check, Stub to be the default (selected automatically), not Stub, Check. When I right-click in the panel, I don't have an option…

We're editing our picking form, but now when there is a comment on an item it will add a line of space before the next line item. Is there a way to get rid of this space? Is there a way to get rid of the extra space created when an item doesn't have a…

Sage 100 ERP 2013 I've been struggling to create a panel I need for my small business and create a form in Crystal Reports for it - I've hardly had time to attempt this and I'm not having an easy time with the advice that's been offered. I don't have…