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
Reconcile Assets vi...
 
Notifications
Clear all

Questions Reconcile Assets via Import Scenario

 
Everything Else
Last Post by Tim Rodman 7 years ago
6 Posts
2 Users
0 Reactions
2,701 Views
RSS
Royce Lithgo
Posts: 557
 Royce Lithgo
Topic starter
November 18, 2018 9:44 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

I've built a simple IS to reconcile assets to a specific GL Account. Basically i want the import to select the first row on the Reconciliation tab after setting the GL account to the value hardcoded in the IS. The IS works fine and creates the FA Transaction, but for some weird reason, the Transaction Amount is zero. If i do the same thing manually, it works fine.ย 

Any ideas?

The fact that the FA Transaction is being created means that the Selected box was checked. If you press Process button with no box checked, it doesn't create an FA Tran. The FA Tran also has the 1599 account, so that means that criteria was correct.ย 

The transaction amount on the FA tran isn't being picked up from the Selected Amount column, which should happen via the code behind the Selected box. It's almost like that code doesn't get executed when the box is selected via Import Scenario.ย 


5 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
November 27, 2018 10:21 pm
(@timrodman)
Famed Member
Joined: 10 years ago

When I click the selected box, the Selected Quantity gets populated with the Open Quantity value and the Open Quantity value goes to zero.

But the Selected Amount column does not get populated with the Open Amount value. Does it for you?


Reply
Royce Lithgo
Posts: 557
 Royce Lithgo
Topic starter
November 27, 2018 10:53 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

Because your example is already reconciled - you need an asset with Unreconciled Amount <> zero.ย  😀ย 

Yes, for me when clicking Selected, Selected Amount defaults to Unreconciled Amount (assuming the tran you are reconciling against has an amount greater or equal to the Unreconciled Amount.ย 

example:


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
November 27, 2018 11:49 pm
(@timrodman)
Famed Member
Joined: 10 years ago

That's what I get for trying to sound intelligent about Fixed Assets ๐Ÿ™‚

I'm not sure here, but that would indeed be strange if the Import Scenario behaves differently from the manual behavior on the screen. That would negate everything that I've experienced with Import Scenarios.


Reply
Royce Lithgo
Posts: 557
 Royce Lithgo
Topic starter
November 28, 2018 1:14 am
(@roycelithgo)
Honorable Member
Joined: 6 years ago

Ok well that's exactly what's happening for me and it means I have to manually reconcile all assets when we convert our data. Really unhappy about this.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
November 30, 2018 7:11 am
(@timrodman)
Famed Member
Joined: 10 years ago

Try StackOverflow. There must be some technical reason why. My bigger question is what other situations cause Import Scenarios not to behave like the screen.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 51 Online
  • 2,389 Members
Our newest member: Dan Hunting
Latest Post: Generic Inquiry Screenid changes to ScreenId=00000000
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

  • Julie Baker
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.

โ€นโ€บร—

    โ€นโ€บร—