Crystal Report Sales Invoice Form Back Order

We currently have customer that accept Back orders. On the sales order the user is able to input items that are on back order. However, if a product is on back order the invoice form drops that product.

The sales order:

This is the invoice: The two products are dropped out.

We are hoping to edit the form crystal report that it shows the back order product as well at the same time indicated that those products are on back order.

Any suggestions how I can do this.

  • 0

    It can be done, but it's not easy.  If you want the easy, but incorrect way, you can simply modify the crystal report and change the criteria for showing the lines.  However, on a reprint, depending on timing, the form will be different.  The correct way to do it is recreate the balances from start through the form date.  You need to include revisions, shipments, retruens, etc.  We had to build a lot of logic to do that and had to use a stored procedure to run.  The SP runs through a new detail section and subreport.

  • 0 in reply to Michael DePasquale

    Are you able to guide me the right direction of doing it the right way. We simply like to print the back order product as well as the other products on the invoice for those that accept back orders. 

    We are not that versed with crystal so any help would b appreciated.