Sage 100

So we are doing a massive overhaul of our system, and one big thing we have to do is change customers pricing method. We have about 2300 customers in our system, but not have custom saved pricing. We are moving from Price Discount % to Price Override…

Hi All, I want to setup a calculated field in explore that takes a package quantity UDF and divides the on-hand quantity by that to show the number of cases they have on hand. The hitch is that not all of the items have a pack size and some items have…

slow down the performance of MAS200. I have 3 sales agents who are running no less than 3 sales order entry screens. I keep getting call the the system is running slow. 4.4.08 version, any suggestion on how to identify performance issues? This system…

I am looking for the code to determine the event that fired off a script. Are there any methods to check to see if the event is post-read, pre-write, post write, pre delete, or post delete?

Hello, After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'. I want to know how can I get to know…

Hello, I am working on some query and part of the query needs me to select all the records from AR_CustomerSalesHistory table with FiscalYear equivalent to current year. I have tried these and some other combinations: SELECT * FROM AR_CustomerSalesHistory…

Hello, I am new to the world of Sage ERP. I have designed this query and it works fine in SQL: SELECT o1.*, ( Select isnull(SUM(D002_DollarsRented)+SUM(DollarsSold),0) FROM openquery(TESTSWRMAS, 'select * from AR_CustomerSalesHistory') o2 WHERE…

We have a number of customers who require their item# to print on the invoice and packing slip and I'm running into performance issues when trying to get a customized SO Invoice Print form to work. I've added those customer specific item #s to the IM_AliasItem…

What would the best way to upload journal entries into Sage100?

I have gone through the set up wizard for the General Ledger Exchange to import a journal entry from a CSV vile and got all of the way through to the GL Exchange window to import the file. When I click on the Proceed file I get an error that says, "Source…

I am trying to use BOI tp print PO to paperless office and I am having hard time finding any good examples of printing to paperless. Does anyone have code for printing of any forms or reports to paperless? My goal is to email PDF copy of purchase…

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…

I created a UDF, Estimated Delivery Date, in PO Header. Now I have trouble to add this UDF to PO Detail table. Anyone can help me? User-Defined Field and Table Maintenance-->PO Purchase Order Detail-->Right click-->Edit Fields-->Green '+' on the right…

oy vey, I thought I knew this sort of software well but I was clearly wrong.... I'm using 2 queries in an event like below. First Query - gets a list of new orders that contains CustomerNo and the email address of the user who created the orders…

Sage 100 Advanced 2013. Importing GL Accounts - Test import completed successfully with no bad records (except header). After reviewing log, clocked Accept to import records and received this error message. No File, no channel and no key. This error…