Expression in an Invoice Layout

Legacy Contributor

I'm trying to create an invoice layout that shows the discount field if a certain code is present (Sales, Options and the two letters for the alternative layout in the Document Design box)
I've added sprfls.sc_doc to test it shows on the design but when the design is saved then printed the details of that field don't show.
I've checked that the data is there to be printed and 'verify' on the expression is fine.
Any ideas - thanks

alan-bourke

Opening SPRFLS isn't enough, you need to locate the right record for the sales account. Which would probably be something like:

Iif(Seek(SNAME.sn_cprfl + Iif(Empty(SNAME.sn_cprfl), SNAME.sn_account, Space(8)), "SPRFLS", "CODE"),iif(!empty(sprfls.sc_doc),.t.,.f.),.f.)