print open lines sales order sap b1 using crystal report

[MarkOenema]

Dear all,

I got a question about printing open lines after making AR invoice.

If we are printing a sales order after making an AR invoice, it prints all the lines also the ones which are already printed on the invoice.

How can we only print the open lines which didn't have been put on the invoice? 

For printing we use Crystal reports.

Please advise,

Regards

Mark Oenema

#sap b1

[BattleshipCobra]

Hi Mark!

You can do this by using "Suppress" with a formula to suppress the finished rows (Crystal Reports considers Suppress as fully hiding in a report). 

In the formula you will put:

{RDR1.OpenQty} = 0

Edit the report into Crystal Reports Designer and go to Report >> Section Expert

When you click the formula button (number three in the above image) you will be able to enter a formula which will suppress the specific section based on some criteria:

Find the RDR1 table, then find OpenQty and double-click to put it in the formula box (number three) and then add a "= 0" which just means whenever the row has zero quantity remaining open the suppress will equal True and it will suppress it (you can also just paste my formula from above assuming you are using SAP layouts).

This can also be used to show partial amounts.  You could show "Quantity" as "Ordered Quantity" and then "OpenQty" as "Remaining Quantity" or whatever you want.  And then use the formula above to suppress fully delivered rows.

Let me know if this helps, if you don't have Crystal Reports Designer installed somewhere get it from your SAP Partner (or if you are a partner then download it from the Laundpad), you should have one included license for CR Designer with your SAP licenses,

Mike

[MarkOenema]

Dear Mike,

Thanks for your reply. I checked on my server and only could find the following:

I don't think this is the program you mean is it?

Thanks in advance.

regards

[BattleshipCobra]

Hi Mark, yes what you are showing is Crystal Reports Designer. You have to go to the sales order, click the pencil icon along the top, then click "Manage Layout" (before pushing this note which layout is in BOLD, this is your default). Find the bold layout name, click it, then click "Edit". This should edit the layout out to the CRD program (the one you are showing) where you can make the changes. I can't tell if you have the CRD integration so you may have to save the file and manually import it. Hopefully you have an SAP Partner who could help you with that part or I can keep trying via the forum.  There should be a little menu item along the top of the CRD called "Add-ins >> SAP Business One" where you can push "Save" or "Save As" (if it's a system layout you can't save over it).  Let me know!