Display Transaction Number

[Former Member]

Hi,

Is there any way to display Transaction No, while processing Transaction. For, e.g

Once I click on 'Add' button to process A/P invoice or A/R Invoice or A/R Credit Note, it should display 'Trans No'. This field is visible as Trans No in Journal Entry form.

If so, can anyone help me in resolving this issue.

Regards

Ronald

[former_member583013]

Hi Ronald,

Answering your question you cannot invoke SHIFTF2 on Add. SHIFTF2 is the key combination to fire the query manually which is saved in a particular field.

There are only 2 ways to go about this.

One creating a formatted search as Dinesh suggested and refresh the A/P invoice or A/R Invoice or A/R Credit Note with the transaction no.

Two, using the SBO_TransactionNotification Stored Procedure at the database level and updating this user field. This will need some coding and you would need to identify the ObjectTypes for (A/P invoice or A/R Invoice or A/R Credit Note ) and update the user field with the transid

Suda

[Former Member]

You can do this thru UDF .

You have to assign the folowing query to that UDF. SELECT T0.TransId FROM OINV T0 WHERE T0.DocNum = $[oinv.DocNum]

But, we have to do this manually since, before updating the invoice the system wont know the journal no. Hence, after updating the invoice, we have manually press Shift + F2 in that UDF.

[Former Member]

Hi Dinessh,

Thanks for your prompt reply. Is it possible to associate Shift+F2 event with 'Add' button.

Regards

Ronald

[Former Member]

Sorry Ronald,

After adding the document only, we are getting trans. no.

According to me it is impossible to have an UDF like that. We can manually do like that.