When I print out a statement for one of our customers, it shows three seperate entries for one invoice number. One of the entries is supposed to be there and shows an Original Amount and an Outstanding Amount. The other two entries look to be from an adjustment and a payment. Both just show only an Outstanding Amount though the payment entry is a negative amount. To me, these two entries should cancel out each other and they should not appear on the Statement. They do not affect the balance of the Statement but I need for them to be not showing on the Statement but cannot find a way to accomplish this and I have tried a few different ways. Any advice?

Hi Shelley,

When you print customer statements, do you have the 'outstanding transactions only' checkbox selected? This will suppress transactions with a 0.00 current balance.

What type of detail section do you have on your statement specification? 'With matching details' or 'Without matching details'? This can be determined by opening the specification designer and the statement spec you use.

Using 'with matching details' will print all applied transactions along with the invoice, such as payments, credits or adjustments. And if the invoice is still outstanding then the matched transactions will print along with it. I presume that this is what you use.

The 'without matching details' section prints each transaction independantly, but will not list which payments or credits or adjustments were applied to which invoices. This section type re-calculates the current amount rathter than just listing the original amount of each transaction.

If you are using Receivables 90A, you could try opening your specification, save it to a new file name, and change the detail section type to the other type, to see if you like these results better. Don't forget to also edit the 'specification options' and give the new spec a different title, so you can see the two different specs listed when printing. If you are using Receivables 81A or earlier, you also have to switch all the field codes to match the appropriate section type (D vs L codes).

Sorry for taking so long to get back to this. I guess I wasn't very clear on what I wanted to do. The items I mentioned above appear on the Statement however what I need to do is to remove these transacations from the customer record altogether. I believe I have tried using Credit/Debit Notes and Adjustments but they seem to make it worse and only adds in another transaction on their history. I know this has to be an easy operation and that I am missing something somewhere, but can't figure it out. No one around here knows Adagio and can figure it out either.

Shelley:

Without actually seeing the data I would not be comfortable advising you on how to clean these up. Trying to blinding fix something like this up would most likley only make is worst.

AccSys Solutions has just opened up an office in Winnipeg and we would be very glad to help you out. As the largest Adagio dealer in the world, we are the Adagio experts.

If you would like immediate assistance please call our technical support department at 204 944 0302 or toll free at 1.888.534.4344. I'm out of the office this afternoon but if you have some time tomorrow I would appreciate the opportunity to discuss how AccSys you support you going forward.