Skip to main content
Solved

Transaction Date to first day of next month

  • December 5, 2025
  • 5 replies
  • 51 views

Forum|alt.badge.img

Hi gurus. How do I create an Import Scenario that changes the transaction dates of Open Move Transactions dated in the current month to update to the first day of next month?

Users make the move transactions ahead of time and so when they go to close out EOM, they can’t because there are "open Move transactions". The import aims to just shift them to the first day of the next month e.g. 30/11/2025 > 1/12/2025. 

Data provider would be a GI of open move transactions.

Best answer by MarkD

Hi ​@Chris Hackett and All, sharing to everyone how I did it. This import scenario updates the transaction date of all Move transactions (Balanced and On Hold status) in the current month to first day of next month. I added restrictions to target the specific branch that I want to update.

 

 

5 replies

mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+6

@MarkD Can you share sample screenshot of transaction which you want to change the date?


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • December 5, 2025

@mohammadnawaz51 - Transaction Date of a ‘Move’ in production order

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • December 9, 2025

@mohammadnawaz51 - This is my import scenario, but it adds a new Move Transaction record instead of updating an existing one:


Data provider is the Move GI:
 

The goal is to update all Open (Hold/Balanced) Move Transaction dates to the first day of following month. So, if I have Move Transactions dated Dec 2, Dec 4 and Dec 5, the GI aims to update them to Jan 1, 2026. Once the import works, I will set an automation schedule to run it every end of month during their month end closing.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • January 8, 2026

Hi ​@MarkD were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Answer
  • January 18, 2026

Hi ​@Chris Hackett and All, sharing to everyone how I did it. This import scenario updates the transaction date of all Move transactions (Balanced and On Hold status) in the current month to first day of next month. I added restrictions to target the specific branch that I want to update.