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
Opening a Closed 10...
 
Notifications
Clear all

Questions Opening a Closed 1099 Year

 
Everything Else
Last Post by Tim Rodman 7 years ago
5 Posts
3 Users
0 Reactions
2,813 Views
RSS
beaker
Posts: 26
 beaker
Topic starter
March 29, 2018 9:55 pm
(@beaker)
Trusted Member
Joined: 9 years ago

Is it possible to re-open a 1099 Year after it has been closed?

When I go into the Close 1099 Year (AP507000) screen and press the CLOSE YEAR button, the Status gets set to Closed, but there is no OPEN YEAR button which would be nice.


4 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
March 29, 2018 10:01 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hi Beaker,

I don't know of a way to open a closed 1099 year within the Acumatica application, but you can run this if you have access to the database:

UPDATE AP1099Year SET [Status]='N' WHERE CompanyID=YourCompanyIDHere AND FinYear=2014 AND [Status]='C'

Reply
beaker
Posts: 26
 beaker
Topic starter
March 29, 2018 10:02 pm
(@beaker)
Trusted Member
Joined: 9 years ago

Perfect, that did the trick. I made sure to change "YourCompanyIDHere" to my Company ID.


Reply
Shawn P Slavin
Posts: 196
 Shawn P Slavin
March 30, 2018 9:54 am
(@shawn-p-slavin)
Estimable Member
Joined: 5 years ago

Don't forget Tim, if you are in a SaaS environment and therefore don't have access to the database, you can always reach out to your reseller. They can open a case with Acumatica and they can run the script on your behalf.  Where there's a will, there's a way.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
April 2, 2018 9:58 am
(@timrodman)
Famed Member
Joined: 10 years ago

Absolutely. Thanks for pointing that out @shawn-slavin. Resellers are key to Acumatica's success.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 41 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

  • Tim Rodman Julian Schrenzel
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.

‹›×

    ‹›×