ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Populate statement field
http://www.istechforum.com/YaBB.pl?num=1364840745

Message started by carolg on 04/01/13 at 11:25:45

Title: Populate statement field
Post by carolg on 04/01/13 at 11:25:45

We would like to populate the "Statement" field for all customers to "Y". No one has been checking that box and we now want to send out monthly statements. Where can I go to do this. I believe it is in the file layouts?

Title: Re: Populate statement field
Post by kevind on 04/01/13 at 13:35:28

Try UT-K-B Global Field Replace

Specify BKARCUST as the File name, change the field BKAR.STATEMENT from N to Y.

This should replace all instances of N to Y. Be sure to backup BKARCUST first incase there is a problem.
(You should always backup a datafile before doing any global search and replace activities.)