[Carolus Daniel]

I am trying to clear my AR trial balance of  small amounts that are overpaid or underpaid; however,  I am not able to process the write off with out it being sent to batch recovery.  

The error reads (details attached) 

Unhanded script exception:
SCRIPTS – data error

Exception_Class_Script_BAD_PARAM

It then sends the batch to recovery

Ideally, I would like to set up GP to write off documents from a customer account by creating a batch and having our controller review and post it.

Can anyone offer some guidance as to how we need to set up this process and if there are any permissions that may be causing this to go to batch recovery.  

Thanks

——————————
Carolus Daniel
Senior Finance Administrator
Jacksonville Port Authority
Jacksonville FL
——————————

[Bert Green]

Carolus,

Just a shot in the dark, but do you have GL accounts in the Writeoffs and Overpayment Writeoffs in the Account screen?

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
——————————
——————————————-

[Bert Green]

Carulos,

I am putting this out for everyone to see. So since your GL accounts are setup the next question is has the AR portion of the writeoff been posted and is the GL portion be the batch that is not posting? Or is the writeoff still in a work status in AR?

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
——————————
——————————————-

[Bob Lash]

GP only allows write offs for underpayments or other positive amounts.  I asked my AR clerk to try a write off through Cash application process with a zero payment.  She tried to post a zero payment with a write off (of finance charges that we know the customer won’t pay – $2.59) and the system allowed to put in a batch and we’ll post it.  Check your expense distribution on the entry to be sure it is posted to your preferred GL account.
She always has to create a debit memo to wipe off Overpayments then apply the payment to the DM.

——————————
Bob Lash
General Manager
Ti-SALES, Inc.
Sudbury MA
——————————
——————————————-

[Bert Green]

It will do overpayments, you have to use the drop down arrow to change from under to over payments. However, out of the box it only does some of the types for over payments. We had a customization done that will do all over payments types.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
——————————
——————————————-

[Leslie Vail]

The error message causes me to think it’s passing a bad parameter value to a function or procedure in Dexterity. I would look at the RM20101 table and look for any columns that are blank or have data in them that doesn’t follow the other records in the table. You can write off Over or Underpayments, and each of them have a default account that the value is printed to.
Kind regards,
Lesie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
PO Box 600965 Dallas TX 75965
leslievail@earthlink.net
972-814-8550

——————————
——————————————-

[Carolus Daniel]

So I was unable to print from the transactions window,  so I had our controller move it out of batch recovery and I printed the edit list.   Now it is showing a $0.00 transaction see below.  Any recommendations?

 

——————————
Carolus Daniel
Senior Finance Administrator
Jacksonville Port Authority
Jacksonville FL
——————————
——————————————-

[Leslie Vail]

I would look at that transaction in the SQL Table RM10301. You mentioned you had several transactions to write off. Can you query the RM20101 table in the database and find another customer that has a document to write off and then go through the write off transaction with that single customer? if that works, there might be something amiss with the customer on your edit list.
I’ll check back to see if you have found an answer already.

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-