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?
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.