Document Printing

[RahF]

Hello Experts

Would like to get your expert opinion if the below is possible

In the document printing dialogue box

As a default it displays Order Date From

Is it possible to change this to Order Due From???

We need to print all production orders that have been scheduled for a certain day

At the moment printing them one by one is taking a lot of time

What other options are available in SAP B1 v9.1 to print all production order by their due dates other than document printing?

Thanks and Regards

Rahul

[kothandaraman_nagarajan · Accepted solution]

Hi Rahul,

I don't think to print all production orders for single click. May be you can filter those planned or released order by creating query or print production order while adding document via print perfrence.

Thanks

[RahF · Accepted solution]

Hi Nagarajan

Thanks for the reply

I guess it's not possible

I am now looking at using Boyum to achieve what I am after

Thanks and Regards

Rahul

[kothandaraman_nagarajan · Accepted solution]

Thank you for your feedback. Please close this thread by marking helpful answers.

[alfax20]

SAP should change this to add due date to print wizard for production orders.  It's possible for other documents like AR Invoice and all.  But production orders sorting by due date is not possible.

[julie_jamieson2]

Easiest way would be to create a crystal report to use the due date as the parameter and add it to the menu

[RahF]

Hi Julie

Would the crystal report let me select all the production orders & print all together?

Would it them mark the production orders as printed??

Thanks and Regards

Rahul

[Former Member]

Hi Rahul,

Document printing on Production Order is based on Work order date(Posting Date).

Document Printing is not possible at dua date.

Regards

Bhanu

[frank_wang6]

Not possible.

Frank

[RahF]

Thanks Frank

I had a feeling that it might not be possible to change to due date

Would you happen to know any other way to bulk print by due date?

Thanks and Regards

Rahul

[frank_wang6]

well, there is no simple way, but it is possible to do it through programming.

Basically, you will need to let user input the date range through Query, and then pass the date range to a program where it will output the printout to a certain folder or printer (this can be achieve through Crystal Report runtime), and then you will need to use DI to mark the document as printed.

Frank

[RahF]

Hi Frank

I have done the query

SELECT

T0.[DocNum] as 'Production Order #'

FROM OWOR T0

WHERE

T0.[DueDate] = [%0] AND 

T0.[Printed] = 'N' AND 

T0.[Status] NOT IN ('L','C')

ORDER BY T0.[DocNum]

How do I achieve the printing through Crystal Report runtime and how to use DI to mark the document as printed.

Thanks and Regards

Rahul

[frank_wang6]

http://www.rainforestnet.com/crystal-reports-exporter/

above is the command line to run crystal report

regarding DI, u will have to check with SDK or u will need some help. It is kind of complicate, can not do it over forum.

Frank