Report

• General Ledger Report
• General Ledger
• Trial Balance
• Profit-Loss
• Balance Sheet
• Cost of Sale
• Cost of Manufacturing
• Account Receivable Report
• Sale Diary Report
• Receipt Diary Report
• AR Outstanding Report
  • By Original
  • By Customer
  • By Date

  SELECT (Populate, TransactionType, TransactionDate, TransactionNo, AR/ReturnChq  - Dr(Amount: Case Type = IV, RT), Cr (Amount: Case Type = RV, ChangeChq), Balance (Start from Type IV + Dr – Cr), PrepaidChq - Dr(Amount: Case Type = RV, ChangeChq), Cr (Amount: Case Type = PayIn, Sale), Balance (Start from Type RV and Payment = CQ + Dr – Cr), ReceiveDtl.PaymentType, ReceiveDtl.DocumentNo, ReceiveDtl.DocumentDate, ReceiveDtl.DocumentBank, ReceiveDtl.DocumentBankBranch) From TransactionHdr WHERE Original, Customer, Date (End of) Range from Screen

• AR Balance Report
  • By Original
  • By Customer
  • By Date

  SELECT (Populate) From TransactionHdr WHERE Original, Customer, Date (End of)

  Range from Screen

• Account Payable Report
• Purchase Diary Report
• Payment Diary Report
• AP Outstanding Report
• AP Balance Report
• Inventory Report
• Outstanding Report
  • By Original
  • By Code, Type
  • By Department
  • By Date

  SELECT Original, Department, Code, InventoryString.Name, TransactionType, TransactionHdr.TransactionDate, ReferTransactionNo, ReferDocumentNo, From, To, Quantity, Cost, Amount, RemainQty = Sum (RemainQuantity), RemainAmt = Sum (RemainQuantity * Cost) From InventoryTransaction WHERE Original, Code, Type, Department, Date ตาม LotDate, LotDateNo (last lot) and RemainQuantity <> 0

  range from screen

  If cut many lot per invoice,  Amount = Sum (Amount), Quantity = Sum (Quantity), Cost = Sum (Amount) – Sum (Quantity)

• Inventory Balance Report
  • By Original
  • By Code, Type
  • By Department
  • By Date

  SELECT Original, Department, Code, InventoryString.Name, RemainQty = Sum (RemainQuantity), RemainAmt = Sum (RemainQuantity * Cost), Cost = RemainAmt / RemainQty From InventoryTransaction WHERE Original, Code, Type, Department, Date ตาม LotDate, LotDateNo (last lot) and RemainQuantity <> 0

  range from screen

• Inventory Report
  • By Original
  • By TransactionType
  • By Code, Type
  • By Department
  • By Date

  SELECT (Original, Department, Code, InventoryString.Name, TransactionHdr.TransactionDate, From, To, Price, PriceDate, Quantity, Unit, ExpiryDate) From InventoryTransaction WHERE Original, TransactionType, Code, Type, Department, TransactionHdr.TransactionDate

  range from screen

• Inventory Stock Report
• Inventory Stock at Purchase
  • By Original
  • By Code, Type
  • By Department

  SELECT (Original, Department, Code, InventoryString.Name, Inventory.ReorderLevel, Inventory.LeadTime, RemainQuantity, Inventory.UnitStock) From InventoryTransaction WHERE Original, Code, Type, Department, (RemainQuantity = Inventory.MinStock)

  range from screen

• Over Stock Report
  • By Original
  • By Code, Type
  • By Department

  SELECT (Original, Department, Code, InventoryString.Name, Inventory.MaxStock, Inventory.LeadTime, RemainQuantity, Inventory.UnitStock) From InventoryTransaction WHERE Original, Code, Type, Department, (RemainQuantity > Inventory.MaxStock)

  range from screen

• Minimum Stock Report
  • By Original
  • By Code, Type
  • By Department

  SELECT (Original, Department, Code, InventoryString.Name, Inventory.MinStock, Inventory.ReorderLevel, Inventory.LeadTime, RemainQuantity, Inventory.UnitStock) From InventoryTransaction WHERE Original, Code, Type, Department, (RemainQuantity > Inventory.MinStock)

  range from screen

• Expiry Date Stock Report
  • By Original
  • By Code, Type

  SELECT (Original, Department, Code, InventoryString.Name, PriceDate, ExpiryDate, Diff (ExpiryDate with CurrentDate), RemainQuantity, Inventory.UnitStock) From InventoryTransaction WHERE Original, Code or Type

  range from screen

• Stock Status Report
  • By Original
  • By Code, Type

  SELECT (Original, Department, Code, InventoryString.Name, PriceDate, RemainQuantity, Inventory.UnitStock, PurchasePrice WHERE TransactionType = Purchase / Receive, SalePrice WHERE TransactionType = Sale / Issue, ProfitPerUnit (SalePrice – PurchasePrice), ProfitAmount (RemainQuantity * ProfitPerUnit))

  From InventoryTransaction WHERE Original, Code or Type and (RemainQuantity <> 0)

  range from screen

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 )