AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Retainage Opening B...
 
Notifications
Clear all

Questions Retainage Opening Balance

 
Everything Else
Last Post by Tim Rodman 5 years ago
5 Posts
3 Users
1 Reactions
2,384 Views
RSS
johnymt
Posts: 8
 johnymt
Topic starter
June 29, 2020 11:23 am
(@johnymt)
Active Member
Joined: 5 years ago

What is the best way to enter the retainage opening balance (from legacy system)? These are project related retainage.


Topic Tags
retainage opening balance
4 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
July 4, 2020 9:00 pm
(@timrodman)
Famed Member
Joined: 10 years ago

As far as I know, you have to load in AR Invoices and let them post to the General Ledger to get Retainage to populate on the projects. But you could load in summary AR Invoices (one per project) with totals. Since you have to post to the General Ledger, do this before you load your Trial Balances.

Just make sure you check Apply Retainage and populate the Retainage Amount field. Or populate Retainage Percent and let it calculate Retainage Amount for you.

You can even do this with an Import Scenario if you want.

image
image

Reply
Ryan Brink
 Ryan Brink
(@rbrink)
Joined: 5 years ago

Member
Posts: 6
September 24, 2020 4:03 pm
Reply toTim RodmanTim Rodman

@timrodman Is this possible in Migration Mode for my cut-off point open AR? My Apply Retainage button disappears and my import scenario breaks on bills with retainage when I apply the above to the scenario. I have a good GL trial balance so I need in migration mode to avoid duplicating. Thanks!


Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3193
September 25, 2020 3:55 am
Reply toRyan BrinkRyan Brink
Tim Rodman

@rbrink I don't think it works in Migration Mode because AR hits the GL in order to hit the Projects module.


Reply
johnymt
Posts: 8
 johnymt
Topic starter
August 2, 2020 9:35 pm
(@johnymt)
Active Member
Joined: 5 years ago

Thanks Tim.


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  retainage (1) , opening balance (1) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 96 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×