Sage 100

I have a client that wishes to maintain access to their MAS 90 4.3 system for historical purposes only after their licensing subscription period has ended. For whatever reason they're choosing not to renew and move in another direction but may need historical…

When attempting to update Job Billing Register within the Job Cost Module, receiving error message: Record: 0002687 is missing from SY_03.SOA. 0002687 is one of the Job numbers used within the system. Users claim two individuals were entering Job billing…

I wanted to change a vendor name from "SMITH" TO "3SMITH" however I ended up deleting the original vendor name. How can I get this information back? What I did: Modules > AP > Utilities > Delete and Change Vendors. (I used the first tab instead of the…

We have many items that when originally setup, the "Valuation" category was set to "Standard Cost". We are attempting to change the valuation of existing items from "Standard Cost" to "FIFO", however we are experiencing a ghosted column that will not…

I am having an issue with trying to run the period ending for accounts payable. I was having this issue back in April 2014, but our support people fixed it, but it only worked successfully for a few months. Now the same message is re-occurring and will…

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…

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?

We are a service company, using MAS 90 and Automated Services. One of our tasks for many of our customers is a monthly recurring inspection. How can we automate this (i.e. Put the first inspection on the monthly board then have it repeat ever month after…

I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables. I want to have the two…

I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files. I want to have it subtotal the quantities of each of the products and then print all items with a negative number on one page and all…

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 using MAS 90 under Windows 7. I have made copies of several custom reports using the Custom Report Maintenance screen, typing in a new report number, and then using the Copy From button to copy the old report number to the new report number. The…

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 am trying to create a profit & loss trend report that compares three or more years. I am using the "Custom Report Maintenance" option in MAS90. Is this possible? Any solutions would be appreciated. Thank you.

I use F9 s/w to produce monthly reports for our Not-For-Profit, and to manage our budget process since it will extract information from Mas90. Its past time to do our upgrade to the latest Sage100 s/w. It appears that F9 won't work with Sage 100.…

Would like some help in activating "undeposited funds". Does anyone have experience with this?

Hi all, it's been a while since I've been here and even longer since I've done any scripts... I need to write a script that will auto-Generate shipping packages based on business rules. does anyone have a simple script that they are willing to share…

Using version 4.50.70.0. I need to add bin location to the item inquiry and item maintenance look up fields. So when I go to Item Inquiry or Maintenance, then the look up magnifying glass and I use the custom tab. I can add just about everything I want…

Our fiscal year has ended and in reviewing the detail GL I have found that sales from the previous fiscal year were updated to the current fiscal year, due to a date error. All sub-ledgers have been closed, and the G/L has also been closed for the last…

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…

One our accountants created a new account group and catergorized it as an Asset.. Then a main account was assigned to this group, and a GL account created assigned to the Main account. A/P then processed an invoice and used the GL account that was created…

The following question was raised during the Sage City Live event at Sage Summit… What Sage budgeting tools are you using for forecasting, cash flow projections, and dynamic revenue reporting for flexible reporting, and what do you find most effective…

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…

The following question was raised during the Sage City Live event at Sage Summit… What do you feel the bank reconciliation challenges stem from...Lack of training, lack of knowledge, lack of resources to find answers? What are your thoughts?