Sage 100

Discounts from the Total tab of an invoice - posts to the Discount account setup in Division Maintenance, reading it at the time of invoice posting, right? There's no place to store a GL account for that in the invoice. Have a client who has had the Discount post to a different account than it listed in Div Maintenance - and strangely enough, it's to another Discount account (they have them by product line). How would it get another account, and how would it know to pick THAT account? I copied everything to a test company and did another invoice for the same customer and it posted to the correct account just as it should. Is there ANYTHING quirky about getting the GL account for that posting?????

What about posting by Dept, Segment or By Warehouse?

Nope.

So, are you saying it is posting to a completely different Main GL Account number? What version? Any enhancements? Custom Scripting?

Completely different account, although the account is still a discount account (like Sage would know that). 2015 latest SU, no enhancements or scripting.

My first thought is: that is so cool! I cannot see anywhere within Sage 100 to set this up in the standard product. If this is accurate, then the only thing I can think of that they might be doing is using a miscellaneous item code to record the discount on the lines. However, I wouldn't be surprised if I am simply missing a setting somewhere.

I checked and the amount was in the Discount field

Is National Accounts turned on?

Nope.

Is it possible someone changes the account number in division maintenance before creating the invoice and then changed it back?

That would just about have to be it, although I think they would have to change it back after they updated (not stored in Header), and don't really think anyone is bright enough to know to do that at the client's. But nothing else plausible coming up....

If it happens more than once you could put in a script to write the user code and date to a text file whenever someone changes something in division maintenance. Not sure if the Sage 100 activity log records changes to division maintenance but I doubt it..

They could also update the sales journal and then modify the GL_DailyPosting file to change the account number. They would have to be wise enough to use the correct account key but if the key is the same structure as the account number then not too hard to figure out.

There is DEFINITELY no one there that could do that!