Open Forum

Expand all | Collapse all

Received not Invoiced Report doesn't tie out

  • 1.  Received not Invoiced Report doesn't tie out

    Posted Jun 08, 2020 01:21 PM
    Hello,

    My received not invoiced purchasing report has never tied out to the GL detail. Can anyone provide insight on how to go about reconciling this? The totals on the receipt numbers in the GL do not match the totals on the receipt numbers on  Received not Invoiced report.

    #Functional
    #GeneralLedger
    ​​​

    ------------------------------
    TRACEY Stewart - Powell
    Riverchase Dermatology and Cosmetic Surgery
    Fort Myers FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Received not Invoiced Report doesn't tie out

    TOP CONTRIBUTOR
    Posted Jun 08, 2020 02:17 PM
    Hi Tracey,

    This can be your starting point:
    • Information about why the values on the Received/Not Invoiced report may not match the general ledger in Microsoft Dynamics GP
    • https://support.microsoft.com/en-ph/help/951236/information-about-why-the-values-on-the-received-not-invoiced-report-m


    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Received not Invoiced Report doesn't tie out

    Posted Jun 09, 2020 08:25 AM
    ​Tracy,
    I have found that if Purchasing incorrectly modifies a purchase order the line that is adjusted does not expense out.  Another issue could be human input error, I always check the source of all entries to see if one or more is there by mistake.  Depending on the number of items, you could tick and tie the debits and credits to see where the issue is to determine the entry required to correct.

    ------------------------------
    Patricia Kahre
    Southland Printing Company
    Shreveport LA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Received not Invoiced Report doesn't tie out

    TOP CONTRIBUTOR
    Posted Jun 09, 2020 10:12 AM

    I have a series of blogs on balancing the GL to the various subledgers, including the RNI report:

    https://dynamicsgptipsandtraps.wordpress.com/



    ------------------------------
    Bruce Strom
    Programmer Analyst
    Paradise GP Consulting, Inc.
    Sunrise FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role