Clear Companies script & custom tables

This is a funny story… or funny now that I’ve figured out the problem I had earlier today. This story begins with a DEV/TEST environment for Dynamics GP where I was setting up some scripts to automate the process of restoring from PROD to DEV. I posted a blog article about this earlier this year in fact, but I didn’t get into the Clear Companies script.

Continue reading “Clear Companies script & custom tables”

Quick Journals

The last couple of #TipTuesday posts have been around some older “new” features – copy journal entry and backout/correct journal entry. Today I thought I would write a quick tip post around one of the lesser known options for creating journal entries in Dynamics GP: quick journals. Next week for my last #TipTuesday of the year, I’ll have a post about the other option which is clearing entries.

Continue reading “Quick Journals”

Backout or Correct Journal Entry

Today’s #TipTuesday is the “cousin” of last week’s tip on the Copy Journal Entry feature, the Backout or Correct Journal Entry feature in Dynamics GP. This week’s tip was introduced in GP 8, so it too has been out for quite a while. I love this feature and I find many users are still manually reversing or correcting journal entries without utilizing this. The best part about this is the control – a user cannot backout the same entry twice and the original entry plus the new entries are forever linked with the history of any backout and correction. Doing these types of corrections manually means there is always room for error, always questions of “did this ever get corrected?”, etc.

Continue reading “Backout or Correct Journal Entry”

Getting a list of write-offs follow up

Last week, my #TipTuesday was a post about how to get a list of write-offs of receivables transactions. I went through what I called the “easy” way but it had a few caveats. It would work in what I believe to be only the most perfect of scenarios. This is the follow up where I’ll walk through in fairly high level detail a way that should be a lot more reliable as it’s based on the apply table(s) in Dynamics GP.

Continue reading “Getting a list of write-offs follow up”

Getting a list of write-offs

A few months ago, when I first started this #TipTuesday series, one of my first posts was around writing off small customer balances. A reader posted a comment last week with a great question: how do you get a list of invoices written off (for an audit, for example)? What I am going to describe below is what would work if you record write offs using the Write Off Amount field in GP or use the Write Off Documents routine I describe in the blog linked above. The key is this is looking only for documents with a “write-off” amount.

Continue reading “Getting a list of write-offs”

Posts navigation

1 2 3 4 20 21 22
Scroll to top