Success Story |
A couple of months ago, we invited customers to submit a success story for our newsletter. This is one of the responses that we received from a long time client; the story highlights how creative thinking with Crystal Reports and Excel was used to solve busines problems. Thank you Zein at Amtex (YARN) Manufacturing for your story.
The development and implementation of a custom written Component Requirement Report and an Excel based cash flow report reduced the time and increased the accuracy in the information we receive from Sage MAS 90. For the Component Requirement Report, we had to manually compile into 1 worksheet vendor's PO's, customer orders and inventory on hand for over 150 items. This was a long and tedious job and at times, mistakes were made due to the complexity of the information in different formats. With the new Component Requirement Report, we are able to get the information we need accurately in a few minutes instead of hours. The cash flow report quickly populates an Excel sheet showing our cash position for any week of the year. Since we do a majority of business in the US, it has helped us in booking the correct amount of foreign exchange when it is required. This way, we can monitor the forex market and lock in exchange rates that are favorable to us instead of guessing what is required for when.
If you have a success story you would like to share, please click here and tell us about your success.
|
General Ledger Fiscal Year Update |
In early January, we often get calls from clients asking how to set up a new fiscal year in the General Ledger system. Sage MAS 90 / 200 will automatically set up a new fiscal year for you -- you don't normally have to do anything. For example, when you make your first posting in 2010, a new year will be created in General Ledger | Setup | Fiscal Year Maintenance.
HOWEVER, we have seen problems in the past when a future year had been created in error and future year postings were posted incorrectly. So, our recommendation is that if you go into General Ledger | Setup | Fiscal Year Maintenance and you see that future years have been set up, but there is a gap of missing years, you should manually set up the years that are missing. For example, if fiscal years 2007, 2008, 2009, and 2015 were set up, you should manually set up years 2010 to 2014 inclusive. Otherwise, we have seen where postings after Dec 31 2009 will be posted to period 1 in year 2015. If this has happened to you, there are utilities available to recalculate the GL period history. If you need help fixing this, please submit a support case on our new web support system at www.munjalwhite.com/support
|