An Easy Way to Generate a Large Cash Receipts EFT Batch from a Large Invoices Batch

If you are looking for a convenient way to generate EFTs from batches of SOP invoices, check out my step-by-step breakdown below. It’s a little heavy on screenshots, but hopefully, they help visually guide you through the process.

First, create a Lockbox using the “Lockbox Maintenance” window.

1-p

Then create an invoice batch, and before posting the invoices, run the following Smartlist:

2-p

Send the Smartlist to Excel and verify your line total equals the total of your batch. Your spreadsheet should resemble the image below:

3-p

Highlight the “Document Amount” column and the “Subtotal” column in your spreadsheet, and then open the “Format Cells” window. Click the “Number” tab, select “Number,” and make sure you have two decimal places and the “Use 1000 Separator (,)” box is not checked. Click “OK.”

4-p

Next, highlight the “Document Date” column your spreadsheet, open the “Format Cells” window, click the “Number” tab, select “Date,” and choose the MM/DD/YY format. Click “OK.”

5-p

Save your spreadsheet as a CSV file in the “Lockbox” folder, which is located in the “ClientShare” folder.

6-p

Your file should look like the one below:

7-p

Once you confirm that you have the right file, you can post the invoices.

Click the “Transactions” button, then open the “Sales” drop-down menu and select “Lockbox Entry” (highlighted below). This will open the “Lockboxes” window.

8-p

Select the Bank ACH Lockbox to open the “Lockbox Entry” window.

9-p

Then enter a Batch ID. I suggest INVEFT followed by the date (MM/DD/YYYY).

10-p

Once you finish entering the Batch ID, a window will pop up asking you if you want to add the batch. Click “Add.”

11-p

This should open the “Receivables Batch Entry” window. Verify that the “Checkbook ID” is correct, and click “Save” (highlighted below).

12-p

After you click “Save,” you should be taken back to the “Lockbox Entry” window. Click the “Transactions” button (highlighted below) to open the “Lockbox Transactions” window.

13-p

If everything is correct (green check marks all the way down), click the “Create Batch” button (highlighted below). This will create the Cash Receipts Batch.

14-p

Next, you can go to SQL to run the following query: update RM10201 set EFTFLAG=1 where EFTFLAG=0 and BACHNUMB Like ‘INVEFT%’. This should set the Cash Receipts to EFT (see the highlighted checkbox below).

15-p

Then go back to the “Receivables Batch Entry” window. Make sure the System Date is set to the exact date that you want to generate the EFT file, and then click the “Post” button (highlighted below).

19-p

Click the “Transactions” button, then open the “Sales” drop-down menu and select “Generate EFT File” to open the “Generate EFT Files” window.

16-p

Again, make sure the System Date is the exact date you want to generate the EFT file for the bank, and then click the “Generate EFT File” (highlighted below) to generate the file one more time.

17-p

The file should be located at E:\ClientShare\ACH and called “Collections” plus whatever you named your EFT format.

Finally, upload the file to the bank for processing.

I hope you found this helpful, and if you have any questions, feel free to contact me.

 

Posted in Dynamics GP | Tagged , , | Leave a comment

Review of Microsoft Dynamics GP 2013 Financial Management by Ian Grieve

Review of Microsoft Dynamics GP 2013 Financial Management by Ian Grieve.

 

I know of Ian Grieve from his Dynamics GP blog website www.azurecureve.co.uk/, so I was interested when I found out it was writing a “How To” Dynamics GP 2013 book. His blog has always been a great resource for knowledge and guidance in the past. Ian’s book condenses down a wealth of GP knowledge into easy to read, instructive paragraphs. As we all know, Microsoft Technical manuals can be a bit overwhelming for the layman. Ian takes all of that knowledge, plus his experience and gives the reader a blueprint on how to setup and maintain a successful Dynamics GP Financial Management System.

 

Analytical Accounting budgeting can be difficult. Ian tackles Analytical Accounting and specifically the budget in the first chapter.

The book takes what has always been a “murky water” part of GP and shines some clarity on how to actually utilize these powerful modules in GP to their full potential. It was equal to a cliff note for GP Financials not a deep dive but an easy book to read.

Posted in Uncategorized | Leave a comment

Dynamic Conversations

Dynamic Conversations is a quick look at what my favorite Dynamics GP blogs and bloggers have been talking about this week. Enjoy!

Convergence 2013 officially kicks off tomorrow—I’ll see you there!

Developing for Dynamics GP

Check out David Musgrave’s newest “Quick Tip.”

Inside Microsoft Dynamics GP

Have you downloaded the Convergence App yet? “This app will improve your overall Convergence experience. There is a tag scan so you don’t have to collect paper business cards. Also you can find out what’s happening now, so you are always up to date.” Download it here!

The Dynamics GP Blogster

Mariano Gomez has already posted some great pictures from New Orleans, especially the beignet from Café du Monde. His PreGAME at Convergence 2013 session, “Implementing Microsoft Dynamics GP 2013 Web Client,” starts at 4:00 PM.

DynamicAccounting.net

And Mark Polino posted a link to a great article by Tonya Jones, “Tips for Navigating the Expo @ Convergence.”

Enjoy the conference!

Posted in Convergence, Convergence 2013, Dynamics GP, GP 2013, Microsoft | Tagged , , , , , , , | Leave a comment

Dynamic Conversations

Dynamic Conversations is a quick look at what my favorite Dynamics GP blogs and bloggers have been talking about this week. Enjoy!

Developing for Dynamics GP

“After just over two and half years, the day has finally arrived when the next release of Microsoft Dynamics GP is made available for download.” David’s post is full of great links to help you get your system ready for the GP 2013.

 Inside Microsoft Dynamics GP

And today’s daily feature is: Shipping!

 Dynamics GP Land

Steve Endow ran into an issue with the IntelliSense feature in SQL Server Management Studio, and in this post he spends some time troubleshooting the problem.

 The Dynamics GP Blogster

Mariano Gomez celebrates the release of GP 2013 and introduces us to Microsoft
Azure
, a flexible cloud platform.

 DynamicAccounting.net

And Mark Polino covers everything else, including the free, Excel-based table and field reference for Microsoft Dynamics GP 2013.

Happy holidays!

Posted in GP 2013, Uncategorized | Tagged , , , , , , , , , , | Leave a comment

Dynamic Conversations

Dynamic Conversations is a quick look at what my favorite Dynamics GP blogs and bloggers have been talking about this week. Enjoy!

Developing for Dynamics GP

Meet the new Windows Phone 8. David Musgrave links to a few high-profile video introductions—part of the Windows Phone “Meet” series.

Inside Microsoft Dynamics GP

And today’s daily feature is: PTO Manager Enhancements!

Dynamics GP Land

Christina Phillips takes a moment to help clarify the difference between the two “L” words—“localization” and “language.”

The Dynamics GP Blogster

Mariano Gomez offers “5 Ways to Prepare for the Microsoft Dynamics GP 2013 Web Client” in an article he wrote for MSDynamicsWorld.

DynamicAccounting.net

And Mark Polino covers everything else, including how to clear data from physical tables in Dynamics GP.

I hope everyone had a wonderful Thanksgiving!

Posted in Dynamics GP, GP 2013, Microsoft, Uncategorized, Windows 8 | Tagged , , , , , , , , | Leave a comment

Dynamic Conversations

Dynamic Conversations is a quick look at what my favorite Dynamics GP blogs and bloggers have been talking about this week. Enjoy!

Developing for Dynamics GP

Are you having trouble with the Support Debugging Tool after installing the latest version? David Musgrave troubleshoots the problem for you.

Inside Microsoft Dynamics GP

Microsoft listens—yesterday, Microsoft announced they would be reducing the price of the Microsoft Dynamics 2013 Customization Suite to $6,000. Well done, partners.

And today’s daily feature is: Build Check Exception Report!

Dynamics GP Land

Steve Endow confronts “the most baffling Dynamics GP issue” he’s ever seen.

The Dynamics GP Blogster

Mariano Gomez wraps up his Microsoft Dynamics Web Client installation analysis and compiles his “Feature of the Day” Week 11 Digest.

DynamicAccounting.net

And Mark Polino hits his 5,000th post…and counting.

 

Posted in Dynamics GP, GP 2013, Microsoft, Uncategorized, Windows 8 | Tagged , , , , , , , , , , , | Leave a comment

Dynamic Conversations

Dynamic Conversations is a quick look at what my favorite Dynamics GP blogs and bloggers have been talking about this week. Enjoy!

Developing for Dynamics GP

If you’re using GP 2013 Web Client Beta and struggling to print or export data, check this out: Aaron Donat shows you how to use Silverlight 5 to enable trusted applications to run inside the browser.

Inside Microsoft Dynamics GP

And today’s daily feature is: Update 1099 Information!

Dynamics GP Land

Have you ever wondered, “How do I find the eConnect 2010 version?” Yes? Well, Steve Endow shows you how here.

The Dynamics GP Blogster

Follow Mariano Gomez on his two-part Microsoft Dynamics GP 2013 Web Client Beta installation journey.

DynamicAccounting.net

And Mark Polino has a string of good posts about—you guessed it—Microsoft Dynamics GP 2013 Web Client Beta.

Posted in Dynamics GP, GP 2013, Microsoft | Tagged , , , , , , , , , , | Leave a comment