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
Import Scenario to ...
 
Notifications
Clear all

Questions Import Scenario to Reverse Journal Transactions (GL Batches)

 
Everything Else
Last Post by Tim Rodman 6 years ago
5 Posts
4 Users
1 Reactions
3,771 Views
RSS
Posts: 1
 Wayne Bromfield
Topic starter
March 22, 2019 11:08 am
(@wayne-bromfield)
Member
Joined: 7 years ago

I have created an import scenario to reverse journal batches already posted in build 2017R02.

When I run the import scenario, I get the error message " Error: The record cannot be saved."

I have tried with and without the dialog box, which shouldn't be necessary as the manual process does not have a pop up.

Any idea why the action SAVE is not working?

 

 

Active Target Object Field / Action Name Commit Source Field / Value Ignore Error Native Field / Action Name Native Object Name
True Batch Summary <Key: Module> False =[BatchModule.Module] False @@Module BatchModule
True Batch Summary <Key: BatchNbr> False =[BatchModule.BatchNbr] False @@BatchNbr BatchModule
True Batch Summary <Action: Cancel> False   False <Cancel> BatchModule
True Batch Summary Module True Module False Module BatchModule
True Batch Summary <Action: Cancel> False   False <Cancel> BatchModule
True Batch Summary Batch Number True Batch Number False BatchNbr BatchModule
True Batch Summary <Dialog Answer> True ='Yes' False ?? BatchModule
True Batch Summary <Action: Reverse Batch> (ReverseBatch) True   False <ReverseBatch> BatchModule
True Batch Summary <Action: Save> True   True <Save> BatchModule

 


4 Replies
Royce Lithgo
Posts: 557
 Royce Lithgo
March 24, 2019 10:50 pm
(@roycelithgo)
Honorable Member
Joined: 5 years ago

I have done this. Here's mine, specifically for reversing AP batches:

ps. next time recommend starting a new topic rather than posting on an unrelated one.


Reply
Tim Rodman reacted
Siva Katakam
 Siva Katakam
(@sivakatakam)
Joined: 5 years ago

Eminent Member
Posts: 13
August 27, 2019 11:31 pm
Reply toRoyce LithgoRoyce Lithgo

@royce-lithgo

Did you get the solution for this ? Am also facing same problem. Please share your solution


Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 5 years ago

Honorable Member
Posts: 557
August 27, 2019 11:48 pm
Reply toSiva KatakamSiva Katakam
Royce Lithgo

@siva-katakam

I don't understand your question. I already posted the solution for reversing journals.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
September 28, 2019 3:03 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hey Royce,

Thanks for sharing your solution. I modified it slightly and put the Module in the Data Source rather than hard coding "AP". But I'm not able to get it to work.

Here's my Import Scenario:

Here's my Excel file data source:

When I run the Import Scenario, I get this error:

Error: The record cannot be saved.

I can click ACTIONS -> Reverse Batch manually on the Journal Transactions (GL301000) screen:

It's just the Import Scenario that isn't working for me. Any ideas?

Note: I moved this to a separate Topic since we're now talking about reversing a journal entry, not changing the Item Class on a Stock Item like the original Topic:

https://www.augforums.com/augforums/acumatica-import-scenarios/using-an-import-scenario-to-change-the-item-class-on-a-stock-item/


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 8 Online
  • 2,324 Members
Our newest member: Michael Kiley
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.

‹›×

    ‹›×