×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

RM fully applied items show on MC aged trial balance

RM fully applied items show on MC aged trial balance

RM fully applied items show on MC aged trial balance

(OP)
We currently have 3 customers with fully applied documents appearing on the MC Historical Aged Trial Balance (and also on the Aged Trial Balance with Options). Originating currency (USD) balance is $0; functional balance is = to the gain/loss for the SOP document in MC020104.

I've tried check links, reconcile, unapply/reapply (which usually works).  The items have been moved to history using Paid Transaction Removal, but were unapplied using the Professional Services Tools Library to see if unapply/reapply would fix the problem.

I could try removing the gain/loss from MC02104 to see if that works, but am wondering if there are other related tables that need to be updated too?  Has anyone else encountered this problem?

Year end is approaching and I'd like to remove the items from the TB before the audit to avoid audit concerns.   

RE: RM fully applied items show on MC aged trial balance

I would check to see if any of the current transaction amounts on the documents have more decimal places than your currency setup shows.  There might be fractions of pennies left on them and that could be why they are showing on some reports - as SQL stores 5 decimal places for all currency fields.

Victoria Yudin
Dynamics GP MVP 2005 - 2010
Use Crystal Reports and SSRS with GP:
http://www.flex-solutions.com/gpreports.html
blog: http://victoriayudin.com

RE: RM fully applied items show on MC aged trial balance

(OP)
Hi Victoria,

Thanks for the suggestion and I will check that on the one customer who's amounts look like they should be cleared.  The other 2 customers have functional balances of (170) and (196) and originating balances of $0.  The FX amounts didn't clear during the apply process and the transactions still show on the HATB even after the Remove Paid Transaction process is run.

I'm just wondering if I can remove those Gains/Losses from only the MC01204 table or if there is somewhere else I need to remove them from.  I'm going to take a backup and try it out in our TEST environment.

Regards,
Lisa

RE: RM fully applied items show on MC aged trial balance

Hi Lisa,

If everything else looks ok and those balances should just be 'removed', maybe an easier solution would be to do a write off under Tools > Routines > Sales ? Write Off Documents?  If the GL should not be hot, you can either delete or reverse the GL entries created by this.  Just keep an eye on your AR to GL reconciliation so it doesn't get messed up by this.  I would personally prefer doing this inside GP over messing with the tables.

Victoria Yudin
Dynamics GP MVP 2005 - 2010
Use Crystal Reports and SSRS with GP:
http://www.flex-solutions.com/gpreports.html
blog: http://victoriayudin.com

RE: RM fully applied items show on MC aged trial balance

(OP)
Hi Victoria,

I've never used the Write-off feature; it will be useful when we need to clear out small amounts.

Unfortunately, it this case it doesn't work.  I tried both over & under payments with the limit set at $200 (higher than the originating balances) and no documents were found.  I retried using a 5K limit (higher than the SOP invoice amount) and still no documents were found.  The invoice is fully paid as is shown by the $0 originating balance so the write-off routine isn't finding anything clear.

Regards,
Lisa

RE: RM fully applied items show on MC aged trial balance

(OP)
Problem solved!  I tried everything in our TEST company first including running reconciliations and paid transaction removals to ensure there were no unexpected/undesired affects.  

For 1 of the customers, I used the Professional Services Tools Library to unapply the payment as the document had already been moved to history. I reapplied the payment in the usual way and reconciled the customer after which the HATB was OK.

For the other 2 customers, I had to update the amount in field Total_Gain_or_Loss_on_Cu in MC020104 to correct the functional amount showing on the HATB - in one case I had to remove the entire amount from the field; in the other I just had to reduce the amount by $0.01.

Lisa :)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close