Lasons Enterprises Stock Tracking System with Payroll

Stock Tracking System for LASONS ENTERPRISES (a distribution channel) is one of the best tool to track and keep record of your stock with details of purchases and sales from different vendors and to different clients.

The system records all the transactions on daily basis and monthly basis.  Provides entire set of reports required to track the exact position of the business.  The software comes with auto backup system which relaxes you from being worried about the recovery of the software of data loss.

Stock Tracking system / Inventory Control System includes the following modules:

·         Stock Complete Record

·         Vendor Details

·         Employee Payroll System

·         Purchase record

·         Sale Record

·         Cash & Credit Transactions

·         Bank withdrawal and Payment Details

·         Daily Expenses & other income record

·         Wastage record

·         Sale & Purchase return

Following reports are generated:

·         Stock Register

·         Daily Sale Report

·         Invoice Report

·         Income Report

·         Expenses Report

·         Cash Summary Report

·         Vendor Detail Report

·         Bank Withdrawal Report

·         Bank Deposit Report

·         Cash Received Report

·         Cash Payment Report

·         Item wise Report

·         Vendor wise Report

·         Cash flow Report

·         Item wise Profit & Loss

·         Ledger with Item Detail

·         Vendor Transaction

·         Full Payable Report

·         Full Receivable Report

·         Vendor Ledger

·         Profit Report

Vendor & Item wise Profit & Loss

Connecting Oracle Express 10g with Oracle Forms 6i

Hi readers...

Recently I was going through my old stuff in Oracle that I was doing before my professional life started with Databases.  I found many of the applications build with Oracle 8i and Oracle Forms 6i (Developer 2000), tried to run them the the problem I was facing was 'no oracle 8i database'...

I thought to connect the same with Oracle Express 10g Database but Forms and Reports gave error.  After some study in database material I found that Oracle Express 10g Database is not compatible with Forms 6i because of its 'Character Set'...

Now the problem was to change the Oracle Express 10g Database Character Set to older version so that forms can be connected...

When Oracle Express 10g Database is installed on SQL command prompt connect with admin database user as

sys/password as sysdba

when connected apply following commands one by one...

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

Finally you will be able to connect with Forms 6i and run and migrate your applications...

Thanks for reading...

Ask for further help as and when you required...