Skip to Content

Check number assigned after they are printed

Hello all,

I have a problem involving check payments and was wondering if it requires customization or if there are existing structures within SAP capturing the information that I need.

The Problem: Checks that are printed a day or more after the outgoing payment is created have a check number assigned at that time. Nothing (as far as I can tell) changes in the database to tell me that this check now has a check number (no field in OCHO). I have a nightly report that grabs all the checks written the previous day that have a check number. The problem arises when the check is printed after this report. That check will still have a create date of the day it was entered into SAP, but will not have a check number until it is printed and so it will never be picked up by the report.

Does anyone know of any other information that can tell me that there are checks that have been updated?

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 Nov 01, 2012 at 07:03 PM

    Try:

    SELECT DISTINCT

    a.checknum AS 'Check No.',

    a.CHECKSUM AS 'Amount',

    CASE WHEN d.cardname = 'Special Purchases' THEN e.NumAtCard ELSE d.cardname END AS 'Payee',

    a.Checkdate AS 'Date Issued',

    a.Canceled AS 'Canceled'

    FROM OCHO a

    LEFT OUTER JOIN OACT b ON a.VendorCode = b.AcctCode

    INNER JOIN ODSC c ON a.BankNum = c.BankCode

    INNER JOIN OCRD d ON d.CardCode = a.VendorCode

    LEFT OUTER JOIN OPCH e ON a.TransRef = e.ReceiptNum

    WHERE DateDiff(d,a.CreateDate,GETDATE())<=1

    AND c.BankCode = 'Bank-xyz'

    AND a.CHECKSUM >= 0.0

    AND a.checknum <> 0

    Add a comment
    10|10000 characters needed characters exceeded

    • Lailus,

      I was able to make a custom solution to this problem by creating a temporary holding table for checks that have not yet been assigned a check number yet. I store the CheckKey number and then I updated my queries to look for any matching checkKey's that now have a check number. To keep the temporary holding table current, I created a stored procedure to look for new checks without a check number and delete those that are either canceled or that now have a check number. I run this stored procedure through the job agent in ms SQL server management studio. It all seems to work, I was just hoping to avoid all that customization and query off of existing SAP table structures to detect these scenarios. Thanks for your help!

  • Posted on Oct 30, 2012 at 04:13 PM

    Hi,

    You can check Note No. :1151535 and confirm the working of the check number and its printing logic.

    Kind Regards,

    Jitin

    SAP Business One Forum Team

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Jitin,

      Thank you for your response, but I'm not sure what you are referring to with "Note No.:1151535"? I searched SCN for this number and nothing comes up. Also, I'm unclear on what you mean by "confirm the working of the check number and its printing logic". Could you please elaborate a bit more?

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2012 at 08:28 PM

    Hi,

    Could you post your SQL query for the report?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Here is the SQL:

      SELECT DISTINCT

      a.checknum AS 'Check No.',

      a.CHECKSUM AS 'Amount',

      CASE WHEN d.cardname = 'Special Purchases' THEN e.NumAtCard ELSE d.cardname END AS 'Payee',

      a.Checkdate AS 'Date Issued',

      a.Canceled AS 'Canceled'

      FROM OCHO a

      LEFT OUTER JOIN OACT b ON a.VendorCode = b.AcctCode

      INNER JOIN ODSC c ON a.BankNum = c.BankCode

      INNER JOIN OCRD d ON d.CardCode = a.VendorCode

      LEFT OUTER JOIN OPCH e ON a.TransRef = e.ReceiptNum

      WHERE CAST(a.CreateDate AS DATE) = CAST((GETDATE()-1) AS DATE)

      AND c.BankCode = 'Bank-xyz'

      AND a.CHECKSUM >= 0.0

      AND a.checknum <> 0

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.