Tax Return

• 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

• 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

• 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 )

Apple, Mac, iMac, iPhone and iPod are trademarks of Apple, Inc.

Jini, Java and all Java-based are trademarks of Oracle Corporation.

JiniSoft Corporation

Copyright @ 1990 - 2012   Mr. Roongroj Rojanapo ( )

89/1 Khao Lam Road, Saen Suk, Chon buri District, Chon buri 20130, Thailand

E-mail

:

roongroj @ jinisoft.com ( JiniSoft @ Facebook & Line )