Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Cash Manager and void checks (VC)

Posted on by 650

The Check/Deposit Reconcilliation report includes VC tran types and the status is "O". How can the users update the status to "C"?

SL2011 FP1

report 20620.rpt

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Manager and void checks (VC)

    Agree.  The bug has been around for several versions.  Many bugs are not ever addressed if they don't cause corruption of data and have a minimal impact.

  • Bill Degnan Profile Picture
    Bill Degnan 650 on at
    RE: Cash Manager and void checks (VC)

    So is this a bug that Microsoft has to address?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Manager and void checks (VC)

    I have no other way.

  • Bill Degnan Profile Picture
    Bill Degnan 650 on at
    RE: Cash Manager and void checks (VC)

    Hi Elaine,

    I did implement the suggested change. The Cleared amount for the voided checks is 0.00. The problem is the outstanding amount is still listed (-6375.68, -4419.00, -4169.00) and the status is "O" (outstanding).

    What is the proper way to 'clear' these void checks?

    Thanks,

    Bill.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Manager and void checks (VC)

    Hi Bill,

    You are saying that you made the suggested modification and the check and void check still show an O status?

    What does the clear amt show?

    If the clear amt shows as zero, that is the goal of the workaround suggested and the only thing I have for this error.

    The improper display does not change the cleared or outstanding amt since the cK and VC offset each other.  But, it does improperly display the documents as outstanding when they are not.

  • Bill Degnan Profile Picture
    Bill Degnan 650 on at
    RE: Cash Manager and void checks (VC)

    Hi Elaine,

    The amounts still display in the Oustanding Column and they still have a status of O (outstanding).

    Would you like to see a sample of the report?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Manager and void checks (VC)

    And they show as outstanding.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Manager and void checks (VC)

    Hi Bill,

    I printed my report and see the same thing.  This is our bug 10298 which says:

    Void check displays cleared amount on Check/Deposit Reconciliation report (20620.rpt)

    The workaround says this.

    Customize the report as a workaround.

    The ClearAmt field is printing directly from the WrkCaDetail table.

    Create a new formula @ClearAmt with the following formula:

    IF {WrkCADetail.Cleared} = 0 and {WrkCADetail.ClearAmt} <> 0.0 THEN

    0.00

    ELSE

    {WrkCADetail.ClearAmt}

    Replace the ClearAmt field with the formula.

    This says if the cleared flag is false meaning the check is outstanding, but it has a clear amount, print zero.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans