Open Forum

Expand all | Collapse all

Unable to Auto Invoice

  • 1.  Unable to Auto Invoice

    Posted Oct 11, 2019 05:19 PM
    I have a user that is unable to invoice a PO nor able to view a receipt. From the GP PO inquiry window I can see that the remaining PO subtotal is $0 which would indicate that there is/was a receipt. I have checked the POP tables to verify a vendor ID as well as the RCT# on POP10500; however when i attempt to query the POPRCTNM in the POP10600 i get NULL. I have also queried the POP30300 for the RCT but that too gives NULL. The status of the PO was received which i changed/updated to released and had the user try a reconcile but no luck there either. Any suggestions on where else to look or what to have the user try. Thank you

    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Unable to Auto Invoice

    Posted Oct 14, 2019 08:18 AM
    Have you tried the window: Transactions>Purchasing>Enter/Match Invoices
    Enter the invoice number, vendor and see if the PO is there.

    That's my best guess.

    ------------------------------
    Nancy Stephenson
    The Kerner Group, Inc
    Norfolk VA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Unable to Auto Invoice

    Posted Oct 14, 2019 09:24 AM
    Hi Nancy,

    Thank you for the prompt response. When I search for the RCT number in the (enter/match invoices) Purchasing invoice entry I get a message stating "this receipt number already exists on a purchase order or in history. Please enter another receipt." The RCT doesn't appear in the receipt header or the receipt line history table

    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Unable to Auto Invoice

    Posted Oct 14, 2019 09:31 AM

    Try using a different number.

     

    Receipt Number should auto default. Do not change that number. Continue to the next field.

    Vendor Doc. Number: try adding a dot  ( . )  to the end of the invoice number so it isn't a duplicate

    Vendor ID: enter the vendor ID

     

    Then click on Auto-Invoice at the top.

     

    Does the PO show up?

     

    Those are my tricks.

     




    Conference-GPUG_200x200


  • 5.  RE: Unable to Auto Invoice

    Posted Oct 14, 2019 11:18 AM
    Hi Nancy,

    the problem with that is we don't know the invoice number, normally i would be able to get it from the POP tables but there is practically nothing there let alone the invoice number.

    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Unable to Auto Invoice

    TOP CONTRIBUTOR
    Posted Oct 14, 2019 11:44 AM
    Edited by Ryan Galang Oct 14, 2019 11:44 AM
    Hi Renee,

    In the Purchasing Invoice Entry window, what happens if you manually type in the RCT number for the invoice, does the transaction load?
    You can try deleting* this and then try to re-invoice.

    * Please try on test company / create a backup first




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

    Conference-GPUG_200x200


  • 7.  RE: Unable to Auto Invoice

    Posted Oct 14, 2019 01:49 PM
    When I search for the RCT number in the (enter/match invoices) Purchasing invoice entry I get a message stating "this receipt number already exists on a purchase order or in history. Please enter another receipt." 

    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------

    Conference-GPUG_200x200


  • 8.  RE: Unable to Auto Invoice

    TOP CONTRIBUTOR
    Posted Oct 14, 2019 04:53 PM
    Hi Renee,

    Have you tried running PO Reconcile? If not, you can give that a try (specify PO in question) and set it to 'Print Report Only' for now.

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

    Conference-GPUG_200x200


  • 9.  RE: Unable to Auto Invoice

    Posted Oct 14, 2019 05:30 PM
    yes see below/attached



    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------

    Conference-GPUG_200x200


  • 10.  RE: Unable to Auto Invoice

    Posted 30 days ago
    Hi Nancy,

    I managed to try your suggestion and the PO in question does not appear in the "select PO items" window. Any other suggestions??

    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------

    Conference-GPUG_200x200


  • 11.  RE: Unable to Auto Invoice

    Posted 30 days ago

    Sorry, that was the best I had.

    You might need to open a case with tech support.

     




    Conference-GPUG_200x200


  • 12.  RE: Unable to Auto Invoice

    GPUG ALL STAR
    Posted 30 days ago
    Renee,
    The last thing you can try before reaching out to the partner for support, is to take a full backup of your company before running a checklinks in the POP module against this company.. No users allowed in the system while you're running this, but it will surely come back with some results. If there is a broken link between the documents, this will fix it and you'll either be able to move the documents to history, or worst case redo the receiving.
    Ideally if you have a TEST company, you could restore the LIVE company to it and run the check-links in the TEST company, so you can do this during business hours without impacting other users..
    Beat

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Conference-GPUG_200x200


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