ES - Maintain Vendors - Grouping Payments

[lonegator21]

We are converting to ES, and I've been fielding questions from coworkers. One that has been asked and I cannot find the answer to is: Can all vendor payments be defaulted to "Grouping payments". I know that in AP-->Vendors-->Maintain, I can select a vendor, go to the Financial tab, and check Group Payments there. But I have not found a selection anywhere that will do this universally for all vendors. If it cannot be done for all vendors at once in the system, I'm assuming this is just a field in a specific database and a simple SQL query could be written to change this universally. Is that correct?

 

[crystalreporting]

All vendors that convert from Progression have the 'group payments' option off by default (should be round the other way). I usually take care of this with a quick SQL statement;

update cicmpy set GroupPayments = 'Y' where GroupPayments = 'N' and crdcode is NOT NULL

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[crystalreporting]

The flag is actually an 'A' (in case some tries to use this at a later date....);

update cicmpy set GroupPayments = 'A' where GroupPayments = 'N' and crdcode is NOT NULL

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com