Sage 100

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

2019 Advanced - Sales order history detail has extended into a second partition and MS Access now gets the message "Cannot open Database" when trying to link or import the table. It may not be a database that your application recognizes, or the file…

For example: 5 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Inventory Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item {ARO$(19,1)}

Hi all, I am looking for a document that lists a description of the columns in each table in the MS SQL server backend. I looked everywhere but not able to find any description of the columns.

Hello, I'm trying to populate a table with PO values when a UDF date value is assigned in order entry. I have a database trigger set to do this, which works when I use a generic update trigger that doesn't specify which column it's checking for for…

We are currently using Microsoft Access to collect AR Invoice History detail data. We have data from 1999 & use Access to lookup prior invoice line information detail, which displays service performed. We search by a UDF_ServiceLocation field. If possible…

Does anyone have experience in Data Agent/Business Alerts? For some reason when I create a report to create a csv file on a ftp site it wants to put all the data in a single row instead of columns. I can copy a report that works and do some minor adjustments…

I have a UDT that contains user codes and email address. I need to lookup the current user's email address from this table in any module. Basically, PO, SO, Invoice, AR, and AP. What is the trick to having a single lookup UDT available for all these…

Is there some where we can download FRX ? Customers using this and I have not used FRX for over two years. Looking for refresh but don't have the software.