Thursday, February 26, 2009

AA Table Changes with GP 10 SP2

If you are using GP 10 SP2, FRx Cannot Report on Analytical Accounting History Following an Year End Close.

With Microsoft Dynamics GP 10.0 Service Pack 2 - Microsoft has made some Database changes . When the year end close process is run - it automatically moves the AA transactions from the AAG30000 tables to the AAG40000 series tables.

FRx does not read from the AAG40000 series of tables and therefore, cannot report on historical data for Analytical Accounting. You get the error - "This report yields no data".

There is a hotfix available from Microsoft (hotfix 962862), but you need to contact Microsoft for it, its not available for public download yet.

I have not done any tests yet, but this should lead to performance improvements in your AA Reports. This would also mean that you need to update your custom AA Reports to read data from AAG40000 series tables.

Friday, February 20, 2009

1099 Minimum Amount

As per the IRS, the 1099 form must be issued to Vendors for amounts of $600 or greater. Somebody recently reported that the 1099s were not being produced for Vendors with amounts which were exactly $600.

By default, the minimum amount for 1099’s is set to be $600 (Microsoft Dynamics GP menu >> Tools >> Setup >> Purchasing >> Payables >> 1099 Setup button)

As per the documentation this is the “minimum amount to report on the selected type of 1099 statement.” So my guess was that vendors with amounts exactly $600 and greater would be reported in the 1099 Lists. I checked and in V9, this was the case. However, this seems to have changed in V10. V10 does not pick up Vendors with amounts exactly $600 in the edit list, if the minimum amount is set to be $600.

The solution that I figured out was to set the Minimum amount to be $599.99. This ensured that the vendors with 1099 amount $600 were reported.

Have any of you noticed this change?


Monday, February 16, 2009

Attachment Detector

One of the most embarrassing things in life is forgetting to send an attachment with an email, when you write down the whole 100 words of text describing the attachment. It was most heartening for me to know that a lot of people felt that way, and some came up with a solution.

There’s one solution out there for Outlook, and one for Gmail. The tools – “politely remind you to attach a file if it finds the word "attach" in your email and no actual attached file.”

Outlook Attachment Reminder via Lifehacker


Gmail's Forgotten Attachment Detector