Subaccountsfield links not created for------- Error in Non BO SubOffices

One day I got a call from one Sub office. Which dont have a branch office. They tell that while viewing the daily account an error occurs. It shows sub account field links has not created for that day. This error occurs mostly in offices which do not have a Branch office. The particular sub accounts field links table for that day is not created is the problem. In this situation most of system administrators firstly go to table open sub treasury table and rename the previous sub account field links table to today’s table. This procedure was not proper. When you do this there is a chance for repeating the error. A simple SQL query can solve this problem. The query is shown below.

Use Subtreasury

select *into subacfieldlinkstodaysdate from subacfieldlinkspreviousdate


If Any one want this  solution/Query  Please mail to me ---saparavur@gmail.com




When we have  this problem occurs in more than days. Then the following will solver the problem

Use Subtreasury

Drop table subacfieldlinks281111 ---The problem dates

select *into subacfieldlinks281111 from subacfieldlinks221111--The date in which daily account is properly taken

Drop table subacfieldlinks291111 

select *into subacfieldlinks291111 from subacfieldlinks221111

Drop table subacfieldlinks301111 

select *into subacfieldlinks301111 from subacfieldlinks221111

Note: Before doing any database operations. Please take the backup of the database