SPE script to check if the Customer record has notes

Question

Hi guys, 
 Could someone pls help me creating a SPE script that check if the Customer record has notes? 
 Thanks in advance. 
 Best Regards, 
 Daniel

zpmarcos · Answer

daniel.gomes what you need is something like this: 
 Funprog BPC_HAS_NOTES(YBPCNUM)
Value Char YBPCNUM

 Local File NOTE [F:YNTS]
 
 Local Integer YHASNOTES : [L]YHASNOTES = [V]CST_ANO
 
 Filter [F:YNTS] Where BPCNUM=YBPCNUM
 If rowcount([F:YNTS])>AVOID.AINT
 [L]YHASNOTES = [V]CST_AYES
 Endif
 
 LogicClose File [F:YNTS]

End [L]YHASNOTES 
 It returns 2 if the customer as notes, and returns 1 if it doesn't. 
 I haven't tested, but it should work. 
 Best Regards

Sage X3

SPE script to check if the Customer record has notes

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING