Microsoft Dynamics GP 2013 "Feature of the Day" - Week 11 Digest

Week 11 is gone, but left us the following goodies, enjoy:

Feature of the Day: Credit Card Vendor's Invoice Void

Void a credit card payment to a vendor...

...will reverse the invoice created for the credit card company

Original article: Feature of the Day: Credit Card Vendor's Invoice Void
Link to presentation: GP2013 FOD_CreditCardInvoiceVoided.ppsx
Learning script: N/A


Feature of the Day: Default Sort Order for Favorites

Can now select an additional sort option in a lookup...

...then set as the default sort option for the lookup

Original article: Feature of the Day: Default Sort Order for Favorites
Link to presentation: GP2013 FOD Default View Stores Sort Order.ppsx
Learning script: N/A


Feature of the Day: Default View Stores Sort Order

Can now select Smartlist-based favorites in a lookup...

...and set as a default for the lookup sort order 

Original article: Feature of the Day: Default View Stores Sort Order
Link to presentation: GP2013 FOD Default Sort Order for Favorites.ppsx
Learning script: N/A


Feature of the Day: Printing 1096 Forms

Not only can you print 1099s, now you are able to print the 1096 form

Original article: Feature of the Day: Printing 1096 Forms
Link to presentation: GP2013 FOD Print 1096 Form.ppsx
Learning script: N/A


Feature of the Day: BAI Format

Electronic Reconcile now introduces support for the Bank Administration Institute (BAI) file format

Original article: Feature of the Day: BAI Format
Link to presentation: GP2013 FOD Add BAI Format to Electronic Reconcile.ppsx
Learning script: N/A

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Read More

Reconciling unchanged bank statements

Just recently, I worked on a case with a partner, whose client had a checkbook setup. For the past serveral months, the bank account associated to the checkbook has had no transaction activity. The client still receives a bank statement each month with no transactions.

When the client would try to enter the cutoff date information into the Reconcile Bank Statment window, even though the difference is zero, the system is not letting them reconcile the statement.

Reconcile Bank Statement window

They keep receiving a message that they need to mark the items they want to clear.

Select Bank Transctions window - error when attempting to reconcile

As a result of not being able to complete the reconcile, the Last Reconciled Date field is not being updated on the Checkbook Maintenance window.

Checkbook Maintenance window

To overcome this issue, we had the client enter both an interest income and an other expense adjustment for a penny ($0.01), as shown below:

Reconcile Bank Adjustments

Once we returned to the Reconcile Bank Statements window and clicked on the Reconcile button, the process went through. Since Microsoft Dynamics GP does not post zero balance transactions to the same account in the General Ledger, then we were able to effectively not affect the GL. The added bonus, of course, and the problem needed to be solved - updating the last reconciled date on the checkbook - was taken care of with this workaround.

Reconciled Checkbook

Of course, we could have made the changes directly in SQL by updating the Checkbook Master table (CM00100), but that would have left no audit trail of the reconciliation for the accounting department. As for those pennies... they are just that, pennies. The adjustments were documented with notes that explained clearly that they served just as a workaround so auditors would not throw a fit.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Read More

From the Newsgroups: Safe Pay and Absolute Value of all Documents

Welcome to another edition of From the Newsgroups, where you will find real life cases of everyday issues. This edition comes courtesy of the Microsoft Dynamics GP Partner forum:

Q: I have setup Safe Pay Configurator. I am having issue with the overall [file] total, which I assigned as a Standard field, Check Amount, and then Amount type, Net Total. When we were testing for the trailing record, the overall document amount is coming out as Issued - Void which is correct because it's a net total, but the issue is our voids are coming without the negative sign so the value is off. Below is the example:

Issued: 1,000

Void: 100

Overall total: 900

Our bank is requesting absolute value [Ed: Checks + Voids] so overall total should be 1,100.

I exported the configurator and imported it to Fabrikam and it works/calculate correctly. Only thing we have different from Fabrikam is Multicurrency is not activated. When I tested it in Fabrikam, here's the result:

Issued: 1,000

Void: -100

Overall total: 1,100

Why is my format working in Fabrikam but doesn't on our production company?

Please advise.

Interestingly enough, it turns out this issue is related to a missing chunk file. Here is the answer from the support engineer.

A: In order to get the absolute value, you will need to install a .cnk file into the GP code folder. The .cnk file would need to be installed on all workstations that generate the Safe Pay file. The file updates the code that generates the file and adds a function that gives the total of the checks and voids. Unfortunately I can't explain why it works in Fabrikam and not in the live company. It does not work correctly in my Fabrikam install so maybe it was the way you generated the transactions for your testing.

If you are experiencing a similar situation or simply need to submit the absolute amount of all documents in the file (checks + voids), please open a support incident with the Microsoft Dynamics GP support team.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com

Read More