Maximo Open Forum

 View Only

  • 1.  Missing GL Debit Account on Invoice Line

    Posted 02-06-2023 05:04
    Hello Everyone,

    Our AP team is trying to create an invoice but the GL debit account field is not auto-populating when copying the PO line. The PO was created back in Dec'2022 and had 2 lines. The first PO line was received and invoiced in Dec'2022 itself. The GL debit account on the 1st invoice line was populated from the 1st PO line without any issues. The second PO line was received in Jan'2023 and now the system is not populating the GL debit account field while using the 'Copy PO Lines' button to enter the invoice. 

    Can anyone please suggest/explain what causing this issue? I have verified everything that I can check. Both the PO lines have the correct GL debit account numbers but somehow the system is not fetching the GL account number when entering the invoice for the 2nd line.

    Can anyone please suggest what else can I check and what could be the reason for the system to not bringing the debit account number from the PO lines?
    #EverythingMaximo

    ------------------------------
    Devendra Verma
    SenecaGlobal
    ------------------------------


  • 2.  RE: Missing GL Debit Account on Invoice Line

    Posted 02-06-2023 06:07
    Hi Devendra,

    Have you checked the logs while the copy POLINE operation is going ON? Looks like some process or setting running behind and is nullifying the field.

    Technically , When you click on the copy PO button, Maximo would have tried to copy the GL Debit account from the PO line like the other Po line fields, but it's not getting populated may be due to some error which you may get in the logs or the field is getting clear out by some other processes like custom automation script.

    1. Could you please check any custom script present in the invoiceline.glebitacct field or on the Invoiceline/invoice object.
    2. if there is no script causing the issue, then turn the exception logger to debug and sql logger to info and monitor the logs during the copy operation from POLine to Invoiceline. (Don't turn the logger in prod, replicate it in lower instance and turn the logger in lower instance only)
    3. Also check that GLAccount is a valid one in COA app ,not expired. 

    Mostly its a custom setting or script which is making that field null or stopping it from populating from POLine.

    ------------------------------
    Subhransu Sekhar Sahoo
    Tata Consultancy Services
    ------------------------------

    Original Message


  • 3.  RE: Missing GL Debit Account on Invoice Line

    Posted 02-07-2023 09:48
    We are experiencing a similar problem. No scrips on INVOICELINE/INVOICECOSTS.
    Still investigating...

    ------------------------------
    Regards
    Bruno Portaluri (MaximoDev)
    ------------------------------

    Original Message


  • 4.  RE: Missing GL Debit Account on Invoice Line

    Posted 02-07-2023 10:13
    My environment also doesn't have any scripts running on the INVOICELINE or INVOICECOST. This is really a strange issue as the PO has 2 lines and when the invoice was entered for the first line, the system populated the GL debit account correctly but it is not bringing the account number when the team is entering the invoice for the second PO line.
    I have checked the logs as well but could not find anything that can point out the error. 

    I am still checking but I guess we will have to run the SQL to manually update the account number on the INVOICECOST file if we doesn't find the reason or solution. I really want to understand why it is happening before we update the account number.

    ------------------------------
    Devendra Verma
    SenecaGlobal
    ------------------------------

    Original Message


  • 5.  RE: Missing GL Debit Account on Invoice Line

    Posted 02-20-2024 08:43

    Hi Devendra,

    Couple of things to check here:

    1. Try using the same GL string when creating a new invoice line. Some times the GL account is invalid or outdated or a component of the GL string is deactivated. If GL string is invalid then Maximo does not apply the GL string on invoice line.
    2. Sometimes users do not have access to all the GL components. You may need to check security groups access to GL components used for the transaction. We faced this issue.



    ------------------------------
    Biplab Choudhury
    BPD Zenith Australia
    ------------------------------

    Original Message


Related Content