Does someone know the SQL to enter a global account adjustment at HQ? I don't mind doing the style 350 manually. I just want to process a group of adjustments quickly. For example:
UPDATE a table and give a $5 credit WHERE AccountNumber = '500123' or UPDATE a table and give a $5 credit WHERE AccountNumber LIKE '500%'
I can associate it with a store location if required.
I guess the question is really twofold. First, do I just need to change Customer.AccountBalance, or do I need to create a new receivable by inserting a record in The AccountReceivable and AccountReceivableHistory tables? Second, will HQ send the account adjustments to the stores if I just update Customer.AccountBalance, and what exactly does a worksheet 350 do from the perspective of the database?
Have something to add? Share your thoughts — no account required.
Ask the community — no account required