- Executing The Plan!
- TechNote: Difference between Converting Unused Paid
Leave to Cash and Adjusting Paid Leave Balance
- TechNote: Moving Your AccountMate SQL/MSDE to a
Different Server
|
|
Dear AccountMate Clients,
It was great hearing from so many of you regarding last month's NewsLine about making priorities to improve your financial
management systems. Issues I've discussed were definitely varied,
and included: better tracking of Aged Receivables for improved
cash flow; implementing finance charges; using the built-in Accrued Received Goods
functionality for real-time inventory valuation; "ABC Analysis"
for implementing inventory cycle counting; sending select customer invoices
electronically via PDF; paying select vendors and employees via ACH; implementing Stonefield
Query (featured in the last NewsLine) - and those are just the ones
I can think of at the moment.
If you haven't had a chance to consider what would be most
beneficial for your organization,
then there's still time to make your own list - or borrow some
ideas from the list above!
Now comes the WORK part of
implementing the changes necessary to realize the improvements...
Nobody said this accounting business was easy, but fortunately
now is the time of year when people are generally "full of
energy" as Spring is coming on strong - even, finally, here
in the cornfields.
And I'm happy to say that we have experience in all the areas
above, which greatly reduces the complexity and client effort of
"learning as you go". Thus we've already polished
off quite a few of these initiatives and clients are enjoying
the benefits!
So, what areas would
you
like to improve accountability for in the coming year?
On the running front, just the weekend before The Boston
Marathon, I paced a friend at
a 150 mile race, running 40 miles from 11pm Friday night through
to 6:30am Saturday in freezing rain with multiple river
crossings. So I wasn't exactly "tapered" for Boston, but
still had a great race; qualifying for Boston at
Boston - which is no small feat on the notoriously tough course. Coming up in
a little over a week, I have
a 50-mile race in Wisconsin,
http://www.iceagetrail50.com, and then a 105 miler through
the rolling hills of southwest England over Memorial Day
weekend,
http://www.nationaltrail.co.uk/Cotswold. I'll be sure
to post a link to pictures in the next NewsLine!
Regards,
Kevin E. Stroud
NexLAN, LLC
http://www.nexlan.com
Tech
Note: Converting
Unused Leave Time
Companies differ in how they choose to handle unused leave time for
employees who are leaving their organizations. Some companies may
offer their employees the option to convert their unused leave time
to cash. This may be a viable option for employees who are about to
retire. For some companies, it may be a “use it or lose it”
proposition. Even companies that offer leave time conversion to cash
may not give this option to employees who are dismissed from their
jobs for legitimate reasons.
These two options require different
accounting treatment and are the subject of this week’s TechNote.
Click the title of the article below to access the document.
Article 1247: Difference between Converting Unused Paid Leave to
Cash and Adjusting Unused Paid Leave Balance
■ ■ ■
Tech
Note:
Moving your SQL/MSDE Database
While we are usually called upon to handle AccountMate technical
issues, a handful of our clients have full-time IT staffs so we want
to pass along a recent whitepaper from AccountMate on how to migrate
the back-end SQL database to a new server.
Moving
the AccountMate LAN product to a new server is very straightforward
if the "old style" payroll is being used, but there are definitely some tricks for the SQL product line.
So, read the following article closely and, of course, contact us if
you have any questions.
Article 1166: How to
Move AccountMate SQL/MSDE to a Different Server
Technical Tips
Version:
AM7 for SQL and Express
AM6.5 for SQL and MSDE
AM6.5 for LAN
Module:
AP
Q:
I attempted to post an AP invoice and reverse the accrued
received goods; however, when I entered the PO# I received the
message “PO# xxx is invalid”. This PO was cancelled but I have
not forced the system to require a PO number for AP invoices.
Why do I get this message?
A:
AccountMate will display the message “PO# xx is invalid”
because, although the purchase order number exists, it is marked
cancelled in the system. If you want the system to allow all
purchase order numbers, including those that are cancelled, in
the AP Invoice Transactions function you must un-mark the Verify
PO # checkbox in the Vendor Maintenance Settings tab. When
posting AP invoices, the presence of a check mark in this
checkbox directs the system to check for valid purchase order
numbers entered in the PO# field.
■ ■ ■
Version:
AM7 for SQL and Express
AM6.5 for SQL and MSDE
AM6.5 for LAN
Module:
GL
Q:
I would like to create GL Account IDs for a new segment that
would have the same Account #s as the existing segment. What
is the best way to create these GL Account IDs with minimal
data entry?
A:
To create GL Account IDs for the new segment, perform the
following:
1.
Access the Copy Chart of Accounts Maintenance
function from the Maintenance menu.
2.
Specify in the Source Company field the
company from which you want to copy the GL Account IDs.
3.
Select in the Copy Segment field the Segment
ID to which you want to copy the GL Account IDs.
4.
Select in the Source field the Segment Value
from which you want to copy the GL Account IDs.
5.
Select in the Target field the Segment Value
to which you are creating the GL Account IDs.
6.
Click the Generate button; then, proceed to
Copy the GL Account IDs.
■ ■ ■
Version:
AM7 for SQL and Express
AM6.5 for SQL and MSDE
AM6.5 for LAN
Module:
AP, PO
Q:
When I use the Post AP button in the Receive Goods function,
the AP invoice amount is automatically populated and the
accrued amount is also automatically reversed. On the other
hand, if I access the AP Invoice Transactions function to
post the invoice, entering the invoice # and amount related
to the PO# receipt does not automatically reverse the
corresponding accrued received goods. What did I miss? Is
there another way to record the accrual in the AP module to
ensure that the accrued received goods are reversed?
A:
To reverse PO receipt accrual in the AP Invoice Transactions
function, click the Overwrite Reverse Accrued Amount button
located next to the read only Rev Accr Amt field. Clicking
this button will open the Reverse Accrued Purchase Orders
window (Accrued Purchase Orders window in AM6.5 for LAN).
Once you click OK to save your entries, the total reverse
amount will be shown in the read only Rev Accr Amt field.
Note:
The information that will be shown when you click the
Overwrite Reverse Accrued Amount button depends on the
AccountMate version you are using. If you are using AM7, the
accrual method selected in the PO Module Setup General (2)
tab affects what you will see in the Reverse Accrued
Purchase Orders window.
Subscription Information
If there is someone else in your office who would like to
receive this NewsLine, please email
newsletter@nexlan.com. In the meantime,
browse through our archives
at http://nexlan.com/?page=newsarchive.htm.
If you would like to
discontinue your subscription to this NewsLine, please click
here.
|
