Bank details on sales Invoices (SOP/Invoicing)

Legacy Contributor

I have a customers that wish to print the corresponding bank details held in C/B on their sales invoices. This would be a very simple task if NBANK was open at the point of printing the invoice! Does any one know of a simple way of doing this? Some invoice design are held in report layout, but EC document design are set as alternative document design (customer profiles).

Thanks Simon

alan-bourke

The way I would approach it is to add a report title band. Then open NBANK as follows:

iif(sqopen("S","nbank"),"","")

Then on the report detail etc. get what you need from NBANK, via a SEEK or whatever:

iif(used("nbank"),iif(seek("XYZ","NBANK","NBANK1"),nbank.nk_code,"")"")

Then add a report footer and:
iif(sqclose("NBANK"),"","")