[Gallery 54]

When I print a receiving report it does not show negative quantities....even if I specifically filter for "less than zero". I am looking to print a report that documents when items are removed from POS and returned to artist (vendor). Our procedure is to "DE receive--receive in negative qty those items that are being switched out for seasonal adjustment, returned for quality problem etc. Please advise.
Thanks.
Heather Hennigan

[RetailEdge Moderator]

You need to choose the detailed receiving report option. In a summary report the negative quantity filter is looking for negative total quantities. The detailed report is looking for each instance of receiving and filtering on the negatives.

Hope this helps.

When I print a receiving report it does not show negative quantities....even if I specifically filter for "less than zero". I am looking to print a report that documents when items are removed from POS and returned to artist (vendor). Our procedure is to "DE receive--receive in negative qty those items that are being switched out for seasonal adjustment, returned for quality problem etc. Please advise.
Thanks.
Heather Hennigan

[Gallery 54]

Ok...but oddly enough the detail report lacks the detail...detail report does not show description.
Any way to keep description and negative qty too?
Thanks

[RetailEdge Moderator]

You raise a point that we have to deal with all the time: what to put on the reports.

The difference between a detail report and a summary report is typically the detail shows every single instance of receiving or sales. So in order to do this we need to include the date information or in the case of sales ticket number and date. On the detailed report we also need to include relevant information about the purchase order and what location it was received into. So then we run out of room. And we have already shrunk the font and flipped the report to landscape and so there is not much more we can add to that report especially descriptions that can be 250 characters long. We always try to balance the reports and add as much information as we can without compromising readability. But there is only so much you can fit on a page.

A couple of things.

1. The detailed report shows the stock numbers of the items. This is why it is important to create meaningful stock numbers so that you can easily see from looking at the stock number what the item is. Whether it is in a list or a report, etc.

2. You might also try creating purchase orders for the returns to vendor. This is pretty typical and can give you some really useful information at the end of the year. You could create return POs with a naming convention like RTV-Ven1, RTV-Ven2. All of the items on these purchase orders will be negative. Then you can run your Historical Receiving by Purchase order report and set a filter for PO=RTV- and get a list of all the returns to vendor. This report will give you the descriptions you wanted as it does not have to display as much information at the detailed receiving report.

Ok...but oddly enough the detail report lacks the detail...detail report does not show description.
Any way to keep description and negative qty too?
Thanks