Monday, September 7, 2009

Remove Transactions from Reports -->Purchasing -->Analysis -->Received /Not Invoiced

Received/Not Invoiced report in Reports-->Purchasing-->Analysis the report was showing transactions in POP Received/Not Invoiced. Instead Matching the Invoice for those Receipts user created other Invoices and correct the Accrual Journal Entry of the Received Transactions.


Now the problem is Inventory Qty and GL A/c Balance is right so we cannot pass the Purchase Return Entry because GL and Inventory Qty will get affect.


To remove the transactions from the Received/Not Invoiced Report need to Edit the PO and closed the PO Line Items i.e. Goto Transactions -->Purchasing -->Edit Purchase Orders select your PO and edit the status of Line item from “Received” to “Closed”





Once you had done the PO which has Receipt but Not Invoiced will not appear in above Report.
I have found another problem if there is no purchase order and user entered only Receipt and which is not Invoiced than execute the following update Statement.

Update POP10500 set QTYMATCH = QTYSHPPD where DEX_ROW_ID= 'XXXX'

Replace XXX with Dex_row_id of the receipt on POP10500.

Hint : You can close non receipt PO Line Item from the Edit Purchase Orders window.

3 comments:

  1. This is awesome! Thanks for posting!! Allows me to give something to management they didn't even ask for. Of course I always mention I didn't create it myself and I keep your comments in the backup copies. :)

    One of our companies has about 100,000 items so I'm thinking I could give them a report where the correlation is only above a certain percentage.

    Thanks again!

    ReplyDelete
  2. Stef,
    Glad to know that above posting is helpful to you.

    Thanks
    Sandip

    ReplyDelete
  3. I have couple of scenarios/issues for items received not invoiced.
    A) PO's were closed long time ago and on the received not invoiced report items are shown without PO#, instead items are listed with ***** as the PO#

    B) I have items that stills eating in my Received not invoiced, PO has been closed, but items still being pending to be matched to a vendor invoice

    How can I clear items from the two scenarios above?

    Thanks

    ReplyDelete