Open Forum

 View Only
  • 1.  Remove Receipts without Purchase Order from RNI report

    Posted Dec 14, 2021 11:14 AM
    We accepted returns from customers at $0 unit cost, in an attempt to track the quantities and serial numbers due to regulatory requirements. 

    A dummy vendor ID was created to summarize receipts for all the returns, but they were not associated with any purchase order.  An item card was created to distinguish the returned product from saleable stock, and they were placed in a Site ID created for this purpose only. 

    Now I have 15 pages of received not invoiced reporting summarizing all these returned product receipts and I cannot figure out how to get rid of it.  For PO number, the report displays "*****", and the amounts total to $0.00.

    We have tried Auto-Invoice, but the receipts are not found to mark/invoice.  There seems like there must be a way to connect the non-PO receipts by way of the Vendor ID, but I haven't found it yet.

    Any ideas how to get these receipts marked as matched and eliminate them from the Received/Not Invoiced by Vendor Report without a PO to match against or close?

    Many thanks in advance for any suggestions.



    ------------------------------
    Sharon Dunn
    Combined Systems, Inc.
    Jamestown PA
    ------------------------------


  • 2.  RE: Remove Receipts without Purchase Order from RNI report

    SILVER CONTRIBUTOR
    Posted Dec 14, 2021 03:31 PM
    Hi Sharon,

    If you just want to filter those out from the RNI, you can open the report in the Report Builder and edit the dsGP dataset to filter out any records for that Site ID or Vendor ID.


    ------------------------------
    Aref Karam
    Data Consultant
    LTI Information Technology
    Ann Arbor MI
    ------------------------------



  • 3.  RE: Remove Receipts without Purchase Order from RNI report

    Posted Dec 15, 2021 09:49 AM
    Thanks for the input.  I'm really looking for a way to permanently mark these transactions so they don't collect on the RNI report.  There are other occurrences of receipts without a purchase order in the ordinary course of our business, such as receipt of customer materials for custom manufacturing, receipts of samples, etc.  so there are multiple sites and vendors that would have to be filtered.

    ------------------------------
    Sharon Dunn
    Combined Systems, Inc.
    Jamestown PA
    ------------------------------



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