[Top] [All Lists]

Re: New to GP: Using SmartLists to reconcile the subsidiary A/R "ledger"

Subject: Re: New to GP: Using SmartLists to reconcile the subsidiary A/R "ledger" (customer-level) to actual G/L?
From: "Mark Polino [MVP] ("
Date: Wed, 31 Oct 2007 09:47:29 -0700
Newsgroups: microsoft.public.greatplains
The SQL on is designed to show you if you are
balanced. The idea is that once balanced, if you look at this every
day in a quick snapshot, when you are out of balance, you know what
day it happened and a day is easier to solve than a month. Simply do
this has dramatically reduced the amount of time we spend chasing

Feel free to email me if you try it an get stuck.

Mark (

On Oct 31, 11:22 am, dexman77 <[email protected]> wrote:
> On Oct 31, 8:59 am, Zarlot <[email protected]> wrote:
> > My problem is that reconciling between the "account transactions"
> > smartlist (filtered for a given month) for the receivable account is
> > time-consuming.  I reconcile to the "receivables
> > received today" filtered for a given month...for the credit side ...
> > then for the debit side, I reconcile to "Sales transactions.... *"
> > This is difficult b/c there is not a common field between these
> > tables.  For example, the "account transactions" SmartList has J/E #s,
> > but of course the customer-level tables do not.  Am I using the right
> > SmartLists?  I'm very new to GP, so any help would be appreciated.
> > Thanks,
> If you are comfortable with using SQL, Dynamic Accounting
> ( has information to balance subledger the
> the GL in the SQL section on the side bar.
> Troy

<Prev in Thread] Current Thread [Next in Thread>