We have a similar requirement and have never found a parameter that would reflect this. We had to alter the crystal report documents that print. We added a subreport to show any items that were on the order but not on any shipments. The full backorders show on every invoice (meaning we've never shipped a partial quantity and an item is backordered), it shows on every invoice as a backorder until something has shipped. If we have a partial shipment, it reflects the original order quantity and the amount shipped on that invoice. If there is a subsequent shipment that does not have any of the product from the partial shipments, those do not show.

I'm confused. Are you asking to diminish the original ordered quantity on the item should the quantity available for that product / site record be insufficient to ship?

Example:

- Customer orders 10 widgets from site NA012

- 0 widgets exist in site NA012

- Set the ordered quantity to 0

Is that what you are asking or am I completely misunderstanding?

Can you give a simple example please?

Thanks,

Bob

Depending on your level of experience with crystal reports:

I think I would probably edit the Delivery document (BONLIV) and use the corresponding fields from SORDERQ,

SORDERQ.SHTQTY shows the number "backordered".  You'd probably have to change the grouping to SORDERQ instead of SDELIVERYD so that on BONLIV you could loop through the SORDERQ records, additionally if you don't want to reprint completely fulfilled lines, use a suppress filter.

Best of luck

In our case, no, we wanted

Example 1:

- Customer orders 10 widgets from site NA012

- 0 widgets exist in site NA012

- The ordered quantity stays at 10, the quantity on the shipment would reflect 0 shipped.

Example 2:

- Customer orders 10 widgets from site NA012

- 5 widgets exist in site NA012

- The ordered quantity stays at 10, the quantity on the shipment would reflect 5 shipped.

Example 1: We need a way to show the customer that we received their order and we don't have stock to fulfill it. We always have to refer back to order table from shipment or invoice (depending where we are looking or document we are printing) to see what was ordered if we don't have any stock available. In example 2, the partial shipment of 5 is fine when the 5 ships, but if we have a second shipment/invoice fulfilling other backorder items and these widgets aren't in stock, there is nothing to reflect that they are still on backorder. Only way around this that we found was altering crystal reports to reflect accordingly.

Thanks Lexi

That was my thought, was hoping to avoid.  Its good to get confirmation I was on right track and not missing something simple. Seems like a big oversight for a product this size not to handle backorders better

Thanks Regular Guy  for taking the time to answer, appreciate your detail  Have extensive Crystal experience but not with X3 fields yet so appreciate your table references.  Will let you know how I go :)  Its the loop of seeing if I can find a field for total shipped to day or having to sum deliveries that made me steer clear of this in the first place.

Appreciate your help

@Lexi: Thanks, that makes sense to me. I checked to see if we have an enhancement on it already, I didn't see one already in place. This link is how you can get that enhancement built: www5.v1ideas.com/.../Top

This enhancement makes a lot of sense.

Bob

>>Only way around this that we found was altering crystal reports to reflect accordingly.

This thread is very old but it appears this is still an issue.

On partial shipments and invoice on shipment, Items that are on a sales ordered but back ordered, and have no shipment of that item on that  invoice, do not show up on the invoice.  So it might be natural for the customer to question if the items "missing" are still on order.

We are thinking of a modification to push ALL lines of a Sales Order to an invoice every time the invoice is created or perhaps a switch on the customer record to show back ordered unshipped item on invoices per customer preference. 

Has anyone resolved this?  Someone mentioned that might have modified crystal to produce this. 

Did you ever get this modification done? I have a need for the same requirement.

I think so.    I think we have an invoice modified to show back orders. 

Sorry for the late reply but i'm having issues with getting notices from this forum.