1. Home
  2. Point-Of-Sale Software
  3. Not Recvd Report?

Not Recvd Report?

Is it possible to create a report that would show everything on a PO that is not recvd? We generate a few large POs each week to the same few vendors, and specify no backorders from each. We receive the orders into RMS, commit them and generate a recd items report to reconcile with the invoice. When we commit we cancel the backorders, but we do not get is a report of items that are not shipped - since there are usually only a few and they are automatically re-ordered the following week, it is usually not a problem, but we need to know about items that are not shipped for a few weeks in a row.

Any ideas?

Reply to
Tad L
Loading thread data ...

Tad,

When you commit your purchase order and choose not to save it as a BackOrder you are deleting all the items that were not received and setting the Qty Order equal to the Qty Received to Date. Because a closed PO cannot have an item on there that was not received. So running a report on closed po's and items that were not received on them is impossible. But what you could do is use a purchase order estimation report and set a filter that shows all items that were last received before a certain date. There is a report like this in the Reports Library on the Customer Source website.

formatting link
downloaded you will need to add the Last Updated Column, you can open the report using Notepad and put the column below in the file. Begin Column FieldName = "Item.LastReceived" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Last Rcv'd" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 900 GroupMethod = groupmethodNone ColFormat = "" End Column

Rob

"Tad L" wrote:

Reply to
Rob

Thanks Rob - I'll try that ( after Xmas ) - but is it possible to recv the PO, print the recd report, then NOT cancel the Backorders, and then print a back-ordered report? I haven't been able to find one, and I don't know how to set the filters so qty recdqty ordered - That would be alot easier for me -

Tad

"Rob" wrote:

Reply to
Tad L

Tad,

Send me an email, I have a report that may help you out.

Rob rob at retail-pos.com

"Tad L" wrote:

Reply to
Rob

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.