Auto Posting of SB Interest - 2011-12

A Software is developed to post SB Interest Year - 2011-12 to Sanchay Post Automatically.
The Software will be available to you within sort period.

V. D. Vadher
SA Gondal HO
Gondal - 360311.

Mob. 98793 22447

Sub Account Day End Error - Solution

If you face an error in Sub Account as ' Invalid Object name sotransit020412' then run following script in Query Analyser. Problem will be solved :

==================================================
USE [supplysubaccounts]
GO
/****** Object:  Table [dbo].[sotransit020412]    Script Date: 02/04/12  15:12:11 V. D. Vadher ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sotransit020412](
    [fromso] [char](3) NULL,
    [toso] [char](3) NULL,
    [remittancedate] [datetime] NULL,
    [sentorreceived] [char](1) NULL,
    [amount] [numeric](15, 2) NULL,
    [adjusted] [bit] NULL,
    [dummycolumn] [timestamp] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sotransit020412]    Script Date: 02/04/12  15:12:11 V. D. Vadher ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
USE [bosupplysubaccounts]
CREATE TABLE [dbo].[sotransit020412](
    [fromso] [char](3) NULL,
    [toso] [char](3) NULL,
    [remittancedate] [datetime] NULL,
    [sentorreceived] [char](1) NULL,
    [amount] [numeric](15, 2) NULL,
    [adjusted] [bit] NULL,
    [dummycolumn] [timestamp] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF