Skip to Content
author's profile photo
Former Member

Display Transaction Number

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 05:07 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 06:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded