Hi,
You need to join the document table with the OSLP table to get the name of the same employee as the same is stored in the OSLP table.
Check this :
select t2.slpname, t1.docnum
from oinv t1
inner join oslp t2 on t1.slpcode=t2.slpcode
Kind Regards,
Jitin
SAP Business One Forum Team
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.