Skip to Content
author's profile photo Former Member
Former Member

Check print date

Dear experts,

Our customer wants to know the check printing date. Is there any SAP table have this information?

I tried with CHO2 table. This table only tells me the "printedby" userid.

The OCHO table doesn't have the print date either.

The creation date in OCHO table is the date we created the check but not the date we printed the check

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 10, 2015 at 11:05 PM

    Thanks for the answer Nagarajan. I still want to have somewhere to put the print date. It is not the same date as payment date

    @Douglas,

    I tried to use trigger in SQL. But I don't know how to add code transaction notification SP

    This trigger is when a table gets changed not add / update a marketing document

    If you can send me a sample, that would be great

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Jim,

      I regret to say, I tried catch the printer action but the Transaction Notification not support "printed" action over the checks for payment, I am sorry, but this is another "solution"

      1- Create a TableUser : checksPrinter

      2- [U_checkkey], [U_checknum], [U_printdate], [U_documentdate]

      3- Execute by "Alert Managment" every day or every hour in each day a Query that detect the check are printed and don't in a Table User, assign to your user and run.

      If do you execute this query every day, you can detected how day is printed by checks for payment.

      I Tried this solution is sucessful.

      my skype account: soportesap.ejje

      Declare

      @ProcessOnCheck Integer, --

      @CheckRecord Integer,

      @CheckRecord2 Integer,

      @Counter Integer = 0

      set @ProcessOnCheck = (select count (*) FROM OCHO T0 Where [Printed] = 'y' and CheckKey not in (select code FROM [dbo].[@PRUEBA]))

      set @CheckRecord = (Select Count (*) from [dbo].[@PRUEBA] )

      While (@Counter <= @ProcessOnCheck )

      Begin

      set @CheckRecord = @CheckRecord +1

      set @Counter= @Counter +1

      Insert Into [dbo].[@PRUEBA]

      ( code,name, U_checkkey, U_checknum, U_printdate, u_documentdate, U_PR)

      select

      @CheckRecord,@CheckRecord, CheckKey, CheckNum, getdate (), PmntDate, banknum

      FROM OCHO T0

      Where

      Printed = 'y' and CheckKey not in (select U_checkkey FROM [dbo].[@PRUEBA]) and CheckKey = ( select max(T2.checkkey) from OCHO T2 Where Printed = 'y' and CheckKey not in (select U_checkkey FROM [dbo].[@PRUEBA]))

      End

  • Posted on May 07, 2015 at 09:07 PM

    Hi Jin,

    can you try with a Transaction Notification, when printed a Check the table OCHO has update, the column "printedby" maybe do you use how trigger and SP Write into U_Table

    Make another U_Table with three columns,

    Docentry_check, Number_check, Date_printed

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 08, 2015 at 08:55 PM

    Hi,

    Please check this thread

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.