Hi,

I was asked to create a GridView that would show all the customers that have a Zero balance outstanding and that have debits and credits under the current amount (the payments have not been matched to the invocies).

I was able to create 2 gridviews, one for the customer master and one for the transaction and link them but I have to go through every single customer in the Master list to find the ones in the transactions that have amounts.

I am using 2 Filters, one on each of my gridviews to only show records that have a Zero balance and records that are NOT zero in the current amounts.

I would like to be able to show 1 report with every zero balance customer that has figures zot euqal to Zero in the current amounts.

Hope someone can help
Thanks
Yann

Perhaps you could use a 'composite table' that combines the AR customer master and the current transactions tables into a single view. Then you can use a filter that searches for the customer outstanding balance = 0 AND transaction current balance <> 0. This should list all transactions (invoices and cash) for the zero-balance customers.

If you use the 'Write-off batch' function in AR and only choose to write off Balances of a range from zero to zero, this will create an adjustment batch that will select all of the same transactions that the GridView view above would select.

Thanks for the reply.

While I was waiting for a response I decided to try the same thing but in Crystal Report. Since I am a lot more familiar with Crystal I had no issue pulling the information that way.

On another note, I was curious why the same tables that are available in GridView are not available for Crystal. I used the AR 8.1 Tables in GridView but in Crystal they are Called ARW10 and they all wear a different name than in GridView.

In GridView I am using the A/R Customers Master but in Crystal it's called ARW10 Customer Information. The GridView A/R Transactions is called ARW10 Customer Extensions in Crystal.

As for the Write-Off Batch, I don't think this does what we are trying to do. We want to see all the invoices that are not matched so that we can match them.

Thanks
Yann

Hi Yann,

Don't worry about the naming convention for the Crystal tables. ARW10 is correct for that version. Dictionaries used by GridView and Crystal Reports are different, thus the individual table names may be slightly different.

Using the write-off batch function is a quick, correct and easy way of taking all transactions for zero-balance customers and applying a transaction to each (an adjustment) so that they don't appear on statements and period end can clear the transactions to history. All GL accounting is correct. The only places where you couldn't do this if a customer had a post-dated deposit and their balance happened to be zero, or if you use multi-currency.

Using write-off batches for matching up invoices to cash is way faster than doing zero dollar cash entries and manually doing the matching.

Using the Write Off function is exactly what you want to do for the task at hand. Way faster than doing in manually.

Doesn't work. I had a list of invoices that were not matched. And the report said there was nothing to match. I tried it four different times. Nothing. In this case doing it manually is much faster (and a lot less frustrating)

Dawn

With the write-off function I suspect you chose to Write Off "Transactions" and should have selected to Write Off "Balances".

Running the function creates an Adjustment Batch for review before posting. Works GREAT for me.

David

It works fine Dawn. David's comment is probably correct in diagnosing the behaviour you experienced.

You can use the Write-off function to write off interest transactions or invoices with a small amount remaining (which is why you'd want to select "transactions").