Daily Accounts Head Problem

execute the attached script using script tool.
if the accountheads are required for the current date execute the following:
use treasury
go
update_megh66_accountheads

if the accountheads are required for a particular date:
use treasury
go
update_megh66_accountheads_bydate 'ddmmyy'
in this ddmmyy explanation is as follows:
if the date is 16/04/2010 then it will be equal dd/mm/yyyy so the ddmmyy will be 160410. This can be applied to any date on the same analogy.Download

Point of Sale Submit Account Problem after SP1

The Error in POS Submit Account-
Run time error '3704' operation is not allowed when the object is closed
Run time error '440' Automation error OK
counter13042010.exl

Invalid Column Name pliotl in SOSummaryb030510 - Temporary Solution

Change the Column name / Date and Run this Query

USE BOSUBACCOUNTS
ALTER TABLE Sosummaryb030510 ADD pliotl Numeric(15,2) NULL

UPDATE  Sosummaryb030510
set pliotl =0

Day End Problem

Temporary Solution
Download

Sub Accounts Missing Head Problem

1. Please Download this attached file and run with script tool executor ..
2. after this .. pl. execute the query mentioned below in SQL Query Analyzer ...

execute treasury..update_megh66_accountheads_bydate '010510'

Pl. also check ..
the option 'Convert Temporary Fields' under tools menu through supervisory login ..
If the missing heads are listed, then make them permanent ...
During the course you may need to perform undo day's work .. perform day end and day begin once again