Tech Tuesday: SmartList Failing to Export Due to Random Characters


This week’s Tech Tuesday is from our Support Guru, Jared Dux, who will go through a consistent issue that as been brought to his attention regarding SmartLists failing to export.

Recently I have seen this come up several times in my cases and it can be a bit puzzling and frustrating users. When running a SmartList you will sometimes see random characters

See the article here:
Tech Tuesday: SmartList Failing to Export Due to Random Characters

November 25, 2014 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 97

CBM Cash Receipt AA Journal Issue & Resolution

Couple of days back, a user reported an issue. When she tried to open CBM Cash Receipts window, following message appeared:

Screen Shot 2014-11-25 at 5.48.52 PM

For all other users, when they posted any Cash Receipt, an Analytical Accounting Journal report would open with some entries on it; particularly with 5 cash receipts. User, who reported the issue, confirmed that the records shown on AA journal report were posted by her and only after posting them, the above error message appeared.

Since the report is AA journal, I first checked the AA Sub Ledger tables (AAG20000 series) and confirmed that the entries shown on the AA journal report are present without any issues. If I get rid of the above error message, things would be normal and this particular user can continue with her entries. Task on hand is to find out AA journal report tables and see the stuck/orphaned records and clear them.

Issue: Records got stuck on AAG50000 (AA Sub Ledger Report Header), AAG50001 (AA Sub Ledger Report Distribution) and AAG50002 (AA Sub Ledger Report Assignment) tables.

Resolution: Remove them. Simple. What you MUST note here is that all records (including genuine ones) would be present on these tables. You MUST note down AA Sub Ledger Header ID of the ones that are stuck and use below query to delete records.

DELETE AAG50000 WHERE aaSubLedgerHdrID IN (,,...) 
DELETE AAG50001 WHERE aaSubLedgerHdrID IN (,,...) 
DELETE AAG50002 WHERE aaSubLedgerHdrID IN (,,...)

Replace  with respective AA Sub Ledger Header ID of the stuck records.

NOTE: Always take a backup of records before you delete.

VAIDY

Filed under: #MSDYNGP, AA, Analytical Accounting, Cashbook Bank Management, CBM, GP, Microsoft Dynamics GP, SQL Server, Troubleshooting

View original post here:
CBM Cash Receipt AA Journal Issue & Resolution

November 25, 2014 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 136

SQL stored procedure for all open AR transactions by customer name

A little variation on my Unapplied AR Transactions view, this SQL stored procedure will return all open (unapplied) receivables transactions for customers with a name containing what is supplied as the parameter. In case you’re wondering why I am all of a sudden posting a stored procedure, I am going to follow this up later …

See the original post:
SQL stored procedure for all open AR transactions by customer name

November 24, 2014 · Victoria Yudin · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 129

Conference Etiquette in 2014


Last week as I was attending a conference session and I did something that I am not proud of. I looked a very smart, intelligent presenter in the eye and

Link:
Conference Etiquette in 2014

November 21, 2014 · Martin · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 104

Tech Tuesday: Steps for Installing eConnect using the Microsoft Installation Media


This week’s Tech Tuesday is from our support guru, David Youngquist, who has included steps for installing eConnect using the Microsoft Dynamics GP 2013

Read More:
Tech Tuesday: Steps for Installing eConnect using the Microsoft Installation Media

November 18, 2014 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 97

Web Client – Date Fields “Please check and reenter the date”

If you are using the web client, you might be going through the message in the subject, this is annoying for users with too many daily transactions!

image

As reported by one of my customers! This issue occurs only when you have the date format with string month (dd-MMM-yy) like the below:

image

Just make sure that the month is numeric (dd-MM-yyyy) and you will get rid of this message!


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

View article:
Web Client – Date Fields “Please check and reenter the date”

November 15, 2014 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 140

Tech Tuesday: Excel Report Builder and Office 365

Excel Report Builder and Office 365 interact a little bit differently than a local installation of Office or SharePoint.

Excel Report Builder and Office 365 SharePoint

Currently, Excel Report Builder will not publish directly to a SharePoint site on Office 365.

You can publish them locally and upload them to the SharePoint library. You can also sync the local folder and the SharePoint library

More:
Tech Tuesday: Excel Report Builder and Office 365

November 11, 2014 · Nicole Albertson · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 110