How to bring tthe Show History Instance Number into ALD

[Former Member]

Hi Everyone

Each time an order is amended the Show history will log it with a new instance number which my client wants to use to resend the document to their customer each time a change is made.

I need to bring the Instance Number from the Show History window of a Sales Order into the Print document using ALD or PLD - Can this be done??

Thanks

asma

Message was edited by:

Marc Riar

[Former Member]

You need to create a UDF with a Formatted Search, where the query should be for example on the Sales Order:

SELECT MAX(LOGINSTANC) FROM ADOC WHERE DOCNUM = $[ORDR.DOCNUM]

Set as auto refresh when Document Number changes.

Then you can display this UDF on the layout with ALD or PLD.

[Former Member]

Thankyou for this answer - however unless the user leaves the record and comes back in the UDF does not refresh and the output document will require immediate printing therefore it will retain the old number.

I think we're just going to resolve it properly using SDK but thanks again - it may come in handy somewhere else in the future 🐵

Kind regards