Outsatanding AR Customer Balance deletiing.

[dbant2009]

Can anybody provide me a method of clearing an outstanding balance for a customer. I have tried running the create writeff for the -0.04 and ACCPAC tells me no records were selected. When we run an ATB and statement after all invoices are paid it shows the outstanding ballance of
-0.04. This has been an outstanding amount for several months and wondered if ther is any way I can get this amount to disappear. We are using ACCPAC 5.4A on SQL server.

 

[Jay Converse]

A writeoff batch is how you do it, check your work. If there are truly no outstanding documents, run a data integrity check.

 

[ettienne]

Run a data integrity check, there could be a mismatch between AROBL and AROBS.

 

[DjangMan]

If you have a rounding issue the document value might be recorded as -0.042. Run your write off batch for the range -0.03 to -0.05 and see what happens.

 

[dbant2009]

I have tried to create an interest batch using the parameter of -0.03 to -0.05 ans still no batch is created. I have ran a data integrity and this did not show anything for the customer in question. I can expalin more what has happened in this situation. This is a US customer that when the payment was applied to the document there was a rounding difference. There were four occurrences that had the rounding difference leaving the -0.04 outstanding for this custmer. I would like to fix this so that it stops showing as a outstanding balnce for this custome.

 

[Jay Converse]

Set the writeoff selection from -1000000 to 1000000, that will get everything.

 

[dbant2009]

I increased rhe value to 1,000,000.00+/- and still no batch was created. Any other ideas.

 

[Jay Converse]

You said "I tried to create an interest batch". It's supposed to be a write-off batch.

 

[DjangMan]

You can try viewing the ARCUS and AROBL records using a database tool to see what the value of the documents actually are. You can also, with NOBODY in Accpac, change the function currency code to three decimals and see if any rounding issues appear. Make sure you change the decimals back to where they were before you let anyone into the system.

 

[dbant2009]

Sorry I meant create writeoff batch not create interest batch.

 

[dbant2009]

We tried changing the currecny to three decimals and the reult was major data integrity problems and had to have the database repaired. Not going to try that again, any other suggestions.

 

[DjangMan]

Goodness! How long did you leave it at three decimals for? Should have been for no more than 5 mintues and with no users in the system.

If you're having the database repaired - have them fix your original issue, too.

 

[ettienne]

Contact your Accpac BP. Something is off in your database and needs to be fixed with a bit of data surgery.