-
Posts
-
I’m impressed that once a code is entered ie:20050601, by moving to the next item to be reconciled and pressing F3 it will enter the next sequential number (20050602).
However, we still need a “Search” method to find the next cheque number (or deposit). The Ctrl F from nv1 works, but required the extra step of saying which direction to search.
Henry.
Hold down the control key and click on ther reference title (this will highlight the colum). Type in the cheque/deposit number you are searching for and you will be taken to it if it exists.
Regards,
Martin
Thanks, I’ll try it. The other items was the code. ie:20050601 for Jun 1, 2005. By increasing the number with every transaction and you have 2000 items on the statement, your last number will be 2005062000. Next month you start with 20050701 and carry on.
When you make a mistake and have reconciled 50 items since the last sub-total on the statement how do you find the error. In nv1 we switched to the XR view (which sorted by the code , we used 2050601, 2050602,etc changing the code with each sub-total) and went to the last or previous reconciled balance. The error was from that point down.
In nv2 using the example above if you sort by the reconcile column I’m not sure if items will be sorted correctly, ie: will 20050701 be behind 2005062000?
The other problem is in nv2 with a different code for each item reconciled, you don’t have a clear idea of the Reconcile points as we did with nv1 (in nv1 we only changed the code at a sub-total which matched).
In Account > Bank > Reconcile and click on the Name of your Bank Account (Blue Table) and change the postings explorer view to closed (X). Hold down the control key and click on Reconcile (this will highlight the colum) and type in your reconcile text. In your example, 20050701 will ahead of 2005062000 if the chevron (V) next to reconcile is downward and behind if the chevron is pointing upward.
In regards to your reconcilie coding in NV2, you could adopt something like 200506-01-01 for subtotal one and then 200506-02-01 for subtotal two etc. Just a thought.
Regards,
Martin
Martin:
If using the 200505-01-01 will nv2 not make the next number 200506-01-02 then 200506-01-03. If this is the case you may be suggesting that at each sub-total (usually at the end of the day on the stmt) we change the middle code: ie: June 1st ends at 200506-01-75, we then type in at the 1st June 2 item 200506-02-01, and then let nv2 increase by one till then end of June 2nd.
Will that keep the reconciled items in the correct sequence to identify the last reconciled sub-total and any error would be from that point down?
Post Edited (07-29-05 10:50)
Henry.
It’s working for me and I can increment by the day as per the example above. Changing the view to Closed (X) from ledger and clicking on Reconcile with the chevron down (V) shows the transactions in the correct order.
I suggest you convert a set of books on your end and test it.
Regards,
Martin
Great, I suggest you add the process to the Manual as an example to follow.
Users entering a non-separated code will have no problems until they make errors and try to find them. Which could be difficult, like the original “R” entry.
ps: I have converted and will test it.
Thanks
Martin:
Just tried Bank Rec again. When I enter a new reconcile code, ie: 20510-01-01 then went to another item to reconcile and pressed F3 it entered 2050608. This was a previous code I used.
Tried it several times and still getting the old code increased by one number. What am I missing?
Look at the ledger view of the bank account. It’s using the reconciliation format values entered on the top of the ledger.
Regards,
Martin
Posting Explorer is the Ledger view, but I don’t see any reconciliation format at top of the screen.
In the Reconcile column I do have items reconciled, such as: 2040101, 2040102, etc.
These are the NV1 codes when we imported the data.If I wish to use 20510-01-01 as the new code(rather than 2051001), how do I get nv2 to recognize this as the new format? Don’t tell me I have to change the old ones!
Martin:
Recognizing that many of my clients have been using nv1 since 1987, and we’ve never purged any data, they possibly have 25,000 or more bank items reconciled using codes such as: 990101 to 2050930.
Or is it possible to just change “One” old entry to “20509-01-01” so it will pick up the new code? I’m not in the books, but by changing an old will it change the position of that entry and therefore not accept it as the starting code?
The F3 feature in reconciling the bank account looks at the highest reconciled value in the bank account and increments on it. You must change the reconciled text values prior to NV2 to be lower than the current method of reconciling of you want the F3 increment to work for you.
Nice idea about the save and put and then F3 but that does not work.
Regards,
Martin
- You must be logged in to reply to this topic.
