|
Posted by Jason on July 11, 2008, 10:21 am
Please log in for more thread options
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?
> 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.
>
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap