Blog
Budget Write Back in F9
A question came up last month about updating budgets within MAS 90.
While there are several ways to update the budgets in MAS 90, I find the easiest way is using F9’s Budget Write Back functionality.
F9 is an Excel plugin that reads financial data
First you need to create a spreadsheet with your GL Accounts and periods. The critical piece is to have the headers exactly correct. The header for the Account Column needs to say Account, the header for the account description needs to read Description, and the individual periods needs to have the number only for the period as the header (ie: Period one is 1, Period two is 2, etc.). You don’t have to have the account description in your spreadsheet for this to work. I’ll put up another post explaining how to do this later and link to it here.
Next you need to fill out the budget amounts for each period. If you only want to update a single period, you don’t have to have the other periods in your spreadsheet.
Before we run the F9 Budget Write back, you can see the MAS 90 budget here:
Next we go back to Excel and highlight and copy the cells with the accounts, periods and budgets you want to update.
Then go to the F9 Menu | Budgeting | Budget Write Back.
Verify the company code, budget, and Fiscal year.
The other concern here is whether you have the “Write ‘Sales’ accounts as debits” check box checked. Check it if you entered the sales accounts as positive amounts on your spreadsheet. Don’t check it if you entered them as negatives.
Click on Write and over in MAS 90, you will see the budgets have been entered automatically. Note that it will show the credit balances as negatives in MAS 90.
You can use the same technique to only update certain accounts and certain periods. To make this work, just make sure you only copy the sections you want to update before performing the Budget Write Back.
In my example below I’m updating only period three for the account selected.
Sage MAS Intelligence Demo Video
Many of you have gotten letters from Sage about the new Sage MAS Intelligence (SMI) reporting tool. This demo video provides an overview of Sage MAS Intelligence.
Sage MAS Intelligence is Sage’s replacement for the soon to be retired Microsoft FRx. It is an Excel based plugin that reads Sage MAS 90/200 data and presents it in both a report format and as a dashboard.
Additional good news: unlike FRx and F9, SMI reports not just on General Ledger Data, but it reports on data from the other MAS 90/200 modules.
This video by Clients First, a fellow Sage Partner and 90 Minds member firm.
via Clients First
How can I update all of my customers’ addresses to be uppercase in Sage MAS 90 or MAS 200?
We’ve all done it at one point or another. We setup some of our addresses in ALL CAPS and accidentally setup others in Mixed Case.
As Brett Zimmerman points out over on the 90 Minds blog, the Upper Case Address Utility (or SWUPCS) is a “Hidden Utility” in Sage MAS 90/200 for converting Customer and Vendor addresses (or just City in case you forgot about the “Return City Name in ALL CAPS” setting in Company Maintenance) to ALL CAPS.
WARNING!: This is a permanent change, so be sure to use with caution!
To access this utility in MAS go to File | Run.
![SNAGHTML13c960bd[1]](http://www.ddfcgi.com/wp-content/uploads/SNAGHTML13c960bd1.png "SNAGHTML13c960bd[1]")
Enter SWUPCS in the Program box and click OK.
From here you can select City Only or All Address Fields and which addresses you’d like to set to All Caps (Customer, Ship To, Vendor, or Purchase Addresses) and click Proceed.
Unfortunately there isn’t a utility to convert all addresses to Mixed Case, but that’s what Visual Integrator is for, right?
Via 90 Minds
Sage Summit Virtual Event Registration is Live
Sage is holding a virtual event November 18, 2010, from 10 am to 1 pm ET and you’re invited to participate.
See! I told you you were invited.
The event will lead with an update from Sage North America’s CEO, Sue Swenson followed by customers viewing very short introductions to sessions that might be presented at the full Summit 2011 conference. Each customer can then vote on which sessions would interest them most — and perhaps most interesting they can also send questions direct to the Sage Product Managers.
Registration is live, so register now.
Sage Summit Virtual Event Registration – November 18, 2010 via 90 Minds
How To Post GL Bank Fees and Adjustments From the Bank Rec Module in Sage MAS 90 / MAS 200
One of the new features in Sage MAS 90 and MAS 200 4.40 PU 3 is the ability to post Bank Fees and Adjustments to the General Ledger from the Bank Reconciliation module.
This has to be one of the most requested features for any user of the MAS 90 Bank Rec module.
From Modules | Bank Reconciliation | Main select Check, Deposit, and Adjustment Entry. There are a few new features here. From either the Checks tab
or the Dep/Adjust tab
you now have access to a “Select For G/L Posting” check box and a “Distribution Account No.”. If you check the GL Posting check box, it will allow you to enter the distribution account number.
Once you’ve finished entering your adjustments you can click the new “B/R Trans Register button at the bottom of the Check, Deposit, and Adjustment Entry screen (highlighted in red above).
You’ll then be prompted to select the bank code or leave it blank for all and select the GL Posting date and print and update as you would any other module.
One place where the posting from Bank Rec is different from other modules is that you can delete the record from Check, Deposit, and Adjustment Entry after it’s been posted and it won’t update the GL. Also the account number can’t be changed after it’s been posted, so you’ll either need to correct with a GL Journal entry or enter a correcting entry if there is a problem with an account that has been selected.
If you try to update the Bank Reconciliation Register and purge cleared transactions you will get the following message and be unable to purge until you have run the Bank Reconciliation Transaction Register and updated it (or deleted the transactions).
-
Recent Posts
Sage MAS 90/200 ERP Webcast
Sage BusinessWorks Webcast
Categories
Archives
Sage Links
