"Replace all" disabled in "Reversal entry" table?

lavanyaballurgilavanyaballurgi Member Posts: 235
hello Experts,

I found that when we are using "reverse transaction" option of any G/L entry it opens "reverse transaction entry" form. Here if we try to replace something by using REPLACE option i.e. Ctrl+H the button "Replace all" is in-active.
The issue is that we've some journal vouchers (with some 200 lines) which need to be reversed every month. Since "Replace All" is disabled the user has to use "Replace" 200 times to change the "Posting Date" to the current month.
Can someone help?

Comments

  • ChinmoyChinmoy Member Posts: 359
    Could not find the issue. See the screenshot attached. I have got the Ctrl+H screen with "Replace All" button enabled and it works perfectly.

  • lavanyaballurgilavanyaballurgi Member Posts: 235
    Oh i am sorry. I should be a little more specific. issue is with the field "Posting Date". For Description field it work fine.
  • ChinmoyChinmoy Member Posts: 359
    Oh yeah.. I found it, but I guess it is true for all date fields. It seems that you cannot use replace All for date fields.
  • lavanyaballurgilavanyaballurgi Member Posts: 235
    Hope Microsoft has some genuine reason for this. anyways so there is no other option to resolve my issue?
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    It may not be for all Date fields becuase we can do replace all in General Journal Forms and etc.

    as an alternative, you can create a function to replace all via code..
  • lavanyaballurgilavanyaballurgi Member Posts: 235
    coding.... seems to be only option for now... anyways is this a bug?
  • MarkHamblinMarkHamblin Member Posts: 118
    coding.... seems to be only option for now...
    Well, there is one other potential option if you're using the classic client. We have a tool we've used for years to paste from Excel into NAV. You could export the lines to Excel, change the date there, and paste the new dates back into NAV. The ability to paste from Excel into NAV is extremely useful.

    The tool is called NavXtender- we haven't put it on Mibuso as a download yet (but are planning to), but you can grab a copy here: http://www.dynms.com/tools/NavXtender.zip

    Simply extract the files, run the EXE, and you'll get new main menus in NAV. The new "NavXtender" menu in NAV will have a "Paste Lines" function, which pastes a column of data at a time. There's a tray icon that you can use to close the app and remove the menus.

    It doesn't require any code changes and adds some new menus to NAV, along with a number of other functions. The download includes some useful scripts for development as well - you can check the XML config files for the scripts and the included manual if you want to create your own custom menus and scripts (again, no NAV changes required).

    - Mark
Sign In or Register to comment.