Enterprise Business Integration

JiniSoft at Home Page

Li Cheng Guang

Telephone Billing
Enterprise Billing
Enterprise Business
Enterprise Commerce
High-Speed Cluster Object-Orient Database

Financial Management
- Purchase System
- Purchase Diagram
- Sale System
- Sale Diagram
- General Ledger System
- Report

Human Resource
Manufacturing
Front Office

Enterprise Commerce Planning
Enterprise Intelligence Planning

Customer Relation
Transaction Diagram
Relation Diagram
Accounting Format

Tax Return

ReturnTax.jpg (32942 bytes)

  • Run Auto TransactionNo from RunningNumber
  • Default Transaction Date by System
  • VIEW & GET: Tax Return of Inventory
  • VIEW & GET: Ivoice Number Reference -> InvoiceHdr

    • SELECT InvoiceHdr.Amount FROM InvoiceHdr WHERE InvoiceHdr.InvoiceNo = àÅ¢·Õè Invoice And TransactionType = Purchase Invoice

  • QUERY:

    SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, ReturnTaxHdr.TaxReturnAmount, ReturnTaxHdr.ReturnType, ReturnTaxHdr.ReceiveDate, ReturnTaxDtl.ReferPurchaseInvoice, ReturnTaxDtl.ReferSaleInvoice, ReturnTaxDtl.TaxAmount, ReturnTaxDtl.TaxReturnAmount FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, ReturnTaxHdr, ReturnTaxDtl

Bank Statement

BankStatement.jpg (32359 bytes)

  • Run Auto TransactionNo from RunningNumber
  • Default Transaction Date by System
  • countBook from TB Library and Detail Amount
  • QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, BankStatementHdr.AccountBook, BankStatementHdr.StatementType, BankStatementHdr.Date, BankStatementHdr.Item, BankStatementHdr.Amount, BankStatementDtl.TransactionType, BankStatementDtl.TransactionNo FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, BankStatementHdr, BankStatementDtl

Bank Reconcile

  • Run Auto TransactionNo from RunningNumber
  • Default Transaction Date by System
  • countBook from TB Library
  • QUERY:

    SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, BankStatementHdr.AccountBook, BankStatementHdr.StatementType, BankStatementHdr.Date, BankStatementHdr.Item, BankStatementHdr.Amount, BankStatementDtl.TransactionType, BankStatementDtl.TransactionNo FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, BankStatementHdr, BankStatementDtl WHERE Compare BankStatementHdr.StatementType = Receive / Payment / Deposit / Withdraw

Budgetting

Budget (Income) / Sale Purchase (Expense)

    Budget For Budget or Sale Purchase
    Original Company
    TransactionType Budget or Sale Purchase
    TransactionNo  
    TransactionDate  
    CostCenter  
    Library Inventory Type
    AccountCode Budget Account Code
    Quantity  
    Price Price per Unit
    Unit  
    Amount  
    Status As O-Budget I-In Bidding / Purchase F-Finish

BudgetTrans.jpg (28385 bytes)

  • Run Auto TransactionNo from RunningNumber
  • Default Transaction Date by System
  • countBook from TB Library
  • VIEW & GET: CostCenter

    • SELECT CostCenter, Department FROM CostCenter

  • VIEW & GET: Account Code, Product from Purchase Budget or Sale Forcash, Purchase Unit

    • SELECT Name FROM Library

  • QUERY:

    SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, Budget.CostCenter, Budget.Library, Budget.AccountCode, Budget.Quantity, Budget.Price, Budget.Unit, Budget.Amount, Budget.Status FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, Budget

Last update : Monday, 7 January 2002 07:00 ( Thailand )

Jini, Java and all Java-based are trademarks of Sun Microsystems, Inc.



JiniSoft Corporation

Copyright @ 1990 - 2008   Mr. Roongroj Rojanapo ( )

33/1478 Soi 52, Chockchai 4 Road, Ladprao, Bangkok 10230, Thailand


E-mail : info @ jinisoft.com
Mobile : 081 615-5135  ( Dtac )