Bank rec. not posting? 1

[WalterHeisenberg]

I got a report from our Accounting department they keep trying to post a bank rec. but get the message "Successfully posted 0 bank reconciliations out of 1 banks specified." When I look at the bank rec. they are trying to post, there was only a single check issued out of this account this month with no other activity. Other bank accounts with plenty of activity posted just fine. Has anyone come across this before?

Info:
Sage Accpac 5.6 PU2
SQL Server 2008 R2

 

[ettienne]

There must be an error message before the "Successfully posted 0 bank reconciliations out of 1 banks specified." message.

 

[WalterHeisenberg]

I did a dump/load to get the production data in our sandbox so I could view it firsthand and do not get any other error messages. I also tried to just hit calculate and save and post again with no luck. The user now thinks this bank may not have posted the last few months as well.

 

[WalterHeisenberg]

One piece of additional information, the bank that is not posting shows the last Reconciliation Year/Period to be current. In our test environment I tried to set the reconciliation date to a future date but got the same message stating 0 out of 1 reconciliations posted successfully.

 

[ettienne]

Not enough info to offer you any help... there must be something you are missing.

 

[DjangMan]

There is likely a restart record that is in the live company that is not in the test company.

 

[WalterHeisenberg]

I thought that might be the case too Djangman and went through yesterday and checked restart maintenance. There were no restart records.

 

[DjangMan]

Run rvSpy and see what the log says.

 

[WalterHeisenberg]

I don't see any errors or anything that jumps out at me looking at the RVSPY log. Anything in particular I should be looking for?

 

[DjangMan]

Any .browse statements that don't return any records when .fetch is called.

 

[WalterHeisenberg]

These are the only sections that seem interesting to me. This is the only fetch that does not seem to return records unless I am looking at this wrong. One thing that strikes me as odd is I see view calls where the bank is different than the bank I am trying to post. Thanks for the help.

[6fc] GL0001: GLAMF    [12:46:42.18].Read(view=0x0490BFDC)
         [6fc] 1 <==[12:46:42.19;t=0;ovh=0] {**NOT-FOUND**}

[6fc] BK0003: BKTT     [12:46:42.48].Read(view=0x0491A5D4)
         [6fc] 1 <==[12:46:42.49;t=0;ovh=0] {**NOT-FOUND**}

[6fc] BK0001: BKACCT   [12:46:43.15].Read(view=0x04920AAC)
         [6fc] 1 <==[12:46:43.16;t=0;ovh=0] {**NOT-FOUND**}

[6fc] BK0820: BKRSTRT  [12:47:11.73].Read(view=0x048BF284)
   [6fc] 1 <==[12:47:11.75;t=0;ovh=0] {**NOT-FOUND**}

[6fc] BK0001: BKACCT   [12:47:13.32].Browse(view=0x048DE314, filter=(NULL), direction=forward)
   [6fc] 0 <==[12:47:13.33;t=0;ovh=0] {}
   [6fc] BK0001: BKACCT   [12:47:13.34].Fetch(view=0x048DE314)
      [6fc] BK0021: BKTNUM   [12:47:13.36].Put(view=0x048CF19C, field=1, size=8, verify=0, buffer='\43\48\41\4d\48\53\20\20' -> 'CHADEP  ')
      [6fc] 0 <==[12:47:13.37;t=0;ovh=0] {}
      [6fc] BK0845: BKTRANH  [12:47:13.38].Cancel(view=0x049428C4)
         [6fc] BK0001: BKACCT   [12:47:13.39].Get(view=0x048DE314, field=1, size=8)
         [6fc] 0 <==[12:47:13.40;t=0;ovh=0] {buffer='\43\48\41\4d\48\53\20\20' -> 'CHADEP  '}
         [6fc] BK0840: BKTRAND  [12:47:13.41].Cancel(view=0x0490BEAC)
            [6fc] BK0845: BKTRANH  [12:47:13.42].Get(view=0x049428C4, field=1, size=8)
            [6fc] 0 <==[12:47:13.43;t=0;ovh=0] {buffer='\43\48\41\4d\48\53\20\20' -> 'CHADEP  '}
            [6fc] BK0845: BKTRANH  [12:47:13.44].Get(view=0x049428C4, field=2, size=4)
            [6fc] 0 <==[12:47:13.46;t=0;ovh=0] {buffer='\00\00\00\00' -> '????'}
         [6fc] 0 <==[12:47:13.47;t=47;ovh=47] {}
         [6fc] BK0001: BKACCT   [12:47:13.48].Get(view=0x048DE314, field=27, size=4)
         [6fc] 0 <==[12:47:13.49;t=0;ovh=0] {buffer='\32\30\31\32' -> '2012'}

 

[WalterHeisenberg]

I think I may have figured out what is happening here. The only activity on this account was issuing 1 check which is still outstanding. In testing other accounts, it appears if there is nothing clearing, voided, or reversed you get the 0 out of 1 message when you try to post the reconciliation.

 

[DjangMan]

You should still be able to post a bank rec even if nothing has changed during the month. Try clearing the check and then save the reconciliation - don't post. Then exit the screen, re-open and go to that bank. Un-clear the check and save, then post. See if that helps.

 

[WalterHeisenberg]

I followed your instructions but still got the 0 out 1 message when posting. I went ahead and cleared the one check in our test company and posted the reconciliation and it gave the proper 1 out 1 message. I don't recall this behavior in other versions of Accpac but it does seem like the 0 out 1 error is repeatable. At least in our environment it is!

 

[DjangMan]

You're behind on one product update for 5.6 - PU3 is the latest. If your test box is isolated from the live box you might consider installing PU3 to see if that resolves the issue.