1. On the Cards menu, point to Sales, and click on Customer.
2. Select an Address ID for the Statement To field.
4. Test the query again and now this customer will pull in. To build a query, click on Transactions, point to Sales and click on Build Query. Select the query filters as desired, and click on Query.
select * from RM00101 where STADDRCD = '' and INACTIVE = 0
After identifying the active customers that have a blank Statement To Address ID, then use the steps in the Resolution section above to select an appropriate Address Id in the Statement To field for each customer.
ID Bài viết: 2411688 - Xem lại Lần cuối: 08-06-2012 - Bản sửa đổi: 1