Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Cash Manager and void checks (VC)

(0) ShareShare
ReportReport
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

*This post is locked for comments

  • 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans