• 1-12 of 12
  • Leigh Holling

    Hi the supplier sites,


    We know attachements at the Supplier Profile level do not attach.


  • Leigh Holling



    yes they come from requistion aswell, however we would never want any attachments to the PO 'From Supplier' eg anything attached in the supplier module should not pull onto a PO ever.

  • Leigh Holling

    done it thanks

  • Leigh Holling

    This is Fab can you amend this to show the attachments at supplier site level?

  • Leigh Holling
    Hi thank you I have looked at this and it will only allow me to restrict individual templates by day. So for example not allow a user to claim above £13 for over 8 hours but I cannot figure out how to restrict expense type meals maximum of £25 which would then cumulate any expense template with the expense type meals.
    Can you provide some guidance or screenshots of how to do this if its possible please?
  • Leigh Holling


    Do not think I can do it with a single expense purley because they are different rates.


    For example Under 5 hours Max is ..... over 5 hours under 8 hours Max is ...... over 8 hours under 12 hours Max is..... over 12 hours less than 24 hours max is.......

    Can I include a time field or even a number of hours field in the expense and then apply a rates rule based on that? This would be the ideal route.


    Can anyone shed light on how I could implement a rule under approval rules to stop certain combinations of expenses within a single date or single expense report?


  • Leigh Holling

    This is brilliant,


    Any chance you can provide the same for suppliers?

  • Leigh Holling

    Note in the Lookup if the BI_URL is there so that you can also drill to other subreports should you need to however it is not needed to purely drill to financials,

  • Leigh Holling

    Hi Sure,

    I have only done this for Invoice Number, will update if and when I do it for any other transaction such as PO number, Supplier etc, but the guidance can be easily adapted to do these yourself.

    First step create a common lookup to find your instance Go to Setup and Maintanence>Manage Common Lookups

    Then create a new lookup that looks like the attached image

    Then in the Data model you want to drill from first create a list of values with the below in the SQL query section name it L_AP_LINK

                    select replace(MEANING, '[DUMMY]', '')  ||





    lookup_type = 'XX_INSTANCE_PARAMETERS'



    This will create a direct URL to the transaction by using the Lookup you created and the Invoice_ID in place of the [P_INVOICE_ID].

    Next create a string and menu parameter called P_AP_LINK that uses the List of values you just created, give it a display name of AP Link and untick the Can select all and Multiple selection options. 

    In your data set add a column Replace(:P_AP_LINK, '[P_INVOICE_ID]',  api.invoice_id)  AS "AP_INVOICE_LINK this will populate the invoice ID into the [P_INVOICE_ID] of the URL. Ensure that this api.invoice_id references the AP_INVOICES_ALL table and the INVOICE.ID column.

    Next go to your report or create one click and in the properties section of the Invoice Number column go to the URL section and put in {/DATA_DS/G_1/AP_INVOICE_LINK}, Note the G_1 should refer to the name of your data set change if necessary.

    Now its a good idea to apply some format  to the invoice number to make it look like it can be clicked on to your users, I turned it blue and underlined. 

    I also chose to hide the P_AP_LINK link parameter from the report by using the parameters section of the edit report and un-checking the show box.

    Hope this helps :)

  • Leigh Holling

    Hi All,

    I have managed to get the above process working, if anyone else is struggling let me know. Happy to provide clarity.



  • Leigh Holling



    do you have a deeplink guide for BIP I know it can be done but I am looking for the guidance or method to help me do this, i know i need to create parameters to pass invoice ID into which will then from part of the URL to drill.

  • Leigh Holling



    Thank you for this i have tried this one, but when I download the data model attached to looked it i cannot import (unarchive) it. i get a compression error.


    If anyone else could import it and send me the code as a .txt file that would be easier.