Q45: OCRD GroupNum - where can I find the 'Name' fields?

[Former Member]

I am searching in vain for the field that gives the text/name to go with GroupNum, can anyone help??? (I do not have the acces to define a new field)

This is the field that gives the payment terms for BPs, I just want a list by Supplier e.g.

30 days nett

30 days month end etc

Not

-1

5

etc

Thanks,

Robin

[Former Member · Accepted solution]

Hi Robin.......

For Payment Terms name just join OCTG table with OCRD you get Payment Group Name......

Try This.....

SELECT T0.[CardCode], T0.[CardName], T1.[GroupNum], T1.[PymntGroup] FROM OCRD T0  
INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum

Regards,

Rahul