General Discussion Topics

[rsisk101]

There definitely was a change to the store procedure right in the validation for the error you are getting. 7.2 July 2008 update and in 7.3.

[tbrasel]

It would be great if you could supply code to allow the negative discount....

Otherwise, I will have to mod it as this is a big issue for us.  We get $.01 overpayments all the time, due to rounding, and need to write them off.

Thanks!

[rsisk101]

As I said in my earlier post, this is definitely a defect and needs to be reported to Customer Support for a proper fix.

I attached the store procedure I modified to figure out what was wrong, basically the discount was not being accounted for during the validation. I marked all the changes with -- RDS to make them easy to find. I also removed some of the code so the procedure won't compile on purpose so it doesn't accidently get installed on someones system.

[markp]

I was wondering if anyone knew how to configure which GL account discounts go to.  I've spent sometime trying to figure it out.  Right now discounts are going to our suspense account and I was hoping to have it go to the proper income statement account.

Thanks in advance.

[JZ]

It is under the customer class screen...

It displays options for setting GL Accounts for Discounts, Write-Offs, etc....

[markp]

Thanks for such a quick reply.  I found that, but had a follow up question:

Is there a way to over ride the general setting for all customer classes?  Right now all the customer classes have discounts going to suspense.  We have a couple hundred classes.  Is there a way that I can change this without having to go to each individual class and change it?

[JZ]

Yes, you would need to update the DiscTakenAcctKey field in the tarCustClass table.

[markp]

Yeah, I don't really know how to get to that table to modify it (I suppose it's probably through sql).  Plus, I'm getting the error that was mentioned before and I don't know how (or think I should try) to update the code to change the validation check. 

Thanks for the assistance though!

[tbrasel]

You can change them with Dataporter. 

Open the Customer Class screen at the main tab to one of the records. 

Launch dataporter, map and export the record. 

Delete all columns except the Customer Class Name and Account you want to change. 

Copy and paste all the Customer Class names and accounts into the sheet.

Run the Import Data function.

You should see it change all the accounts.  I just tested in 7.3 and it worked great.  Should be consistent for all versions.

Hope this helps!

[markp]

Where can I find / what is Dataporter? 

FYI: I have v 7.2.