[tswilson21]

I need to build a report that will show a trend of how many items go on backorder for a given month including the qty that went on backorder. This is used to gauge performance as relative to inventory management. So I would like to see how many times last month a sales order included an item that was backorderd and the qty of that item.

Every way I have built this report it has worked fine, until that item gets received and fulfilled. The backorder quantity is removed from the Sales Order thus breaks the historic report. Every report I produce can only show me the current items that are on backorder, which is not what I need. Does anyone have a thought on how to go about making this report?

Thank you,
This is a cached copy. Click here to see the original post.

[evan_goldberg]

You will probably need to script this, where copies the backorder quantity into a custom field e.g. “original backorder quantity”.

[tswilson21]

Thanks for taking the time to respond Evan. I was thinking about heading in that direction. Looks like it is the best course of action. Regards.

[Author]

Posts