Categories
8.3.1 CASH Invoice JRW SQL

Financial Queries, Data Extract & Reporting

In Master Terminal 8.3.1 the Item Selector Query, Summaries, SQL Extract and JRW Views have been enhanced to include Invoices, Invoice Lines, Cash Payments and Cash Receipts.


ITEM SELECTOR

Now includes modes for Invoices, Invoice Lines, Cash Payments and Cash Receipts.

Queries can be saved and used to create JRW reports in Report maintenance.

All 4 modes include limited cargo &  vessel data as well as data on the actual queried item.


The attributes available are:

  • Bill of Lading
  • Business Unit
  • Cargo Consignee
  • Cargo Id
  • Cargo Type
  • Date Posted
  • Date Start
  • Debtor
  • Debtor Account Code
  • Debtor External Reference
  • External Invoice Number
  • Financial Period
  • Invoice Total
  • Invoice type
  • Is Storage
  • Sequence Number
  • Status
  • Terminal
  • Vessel
  • Voyage
  • Voyage Arrival Date
  • Voyage Sailing Date
  • Bill of Lading
  • Business Unit
  • Cargo Id
  • Cargo Site
  • Cargo Type
  • Debtor
  • Debtor Account Code
  • Debtor External Reference
  • Debtor Type
  • External Invoice No
  • Financial Period
  • GL Code
  • HMS Resource Type
  • HMS Resource Used
  • Invoice Amount
  • Invoice Line Sequence
  • Invoice Line Type
  • Invoice Line Value
  • Invoice Posted Date
  • Invoice Seq Num
  • Invoice Status
  • Invoice Type
  • Is 20
  • Is 30
  • Is 40
  • Is 45
  • Is 53
  • Is Direct Delivery
  • Is Storage
  • Port of Destination
  • Port of Destination
  • Port of Origin
  • Port of Origin
  • Terminal
  • Trans Consignee
  • Trans Consignor
  • Trans Customs Agent
  • Trans FF
  • Trans TODO Task
  • Trans TODO Task Resources
  • Vessel
  • Voyage
  • Voyage Arrival Date
  • Voyage Sailing Date
  • Bill of Lading
  • Business Unit
  • Cargo Consignee
  • Cargo Consignor
  • Cargo Customs Agent
  • Cargo Freight Forwarder
  • Cargo Id
  • Cargo Type
  • Cheque Bank Name
  • Cheque Branch
  • Cheque Date
  • Cheque Number
  • Customs Entry Number
  • Debtor
  • Debtor Account Code
  • Debtor External Reference
  • Debtor Type
  • Invoice Number
  • Is 20
  • Is 30
  • Is 40
  • Is 45
  • Is 53
  • Is Direct Delivery
  • Is Storage
  • Payment Method
  • Payment Value
  • Port of Destination
  • Port of Origin
  • POS Number
  • Receipt Date
  • Receipt Number
  • Terminal
  • User Name
  • Vessel
  • Voyage
  • Voyage Arrival Date
  • Voyage Sailing Date
  • Bill of Lading
  • Business Unit
  • Cheque Bank Name
  • Cheque Branch
  • Cheque Date
  • Cheque Number
  • Customs Entry Number
  • Debtor
  • Debtor Account Code
  • Debtor External Reference
  • Payment Method
  • POS Number
  • Receipt Date
  • Receipt Number
  • Receipt Value
  • Terminal
  • User Name
  • Vessel
  • Voyage
  • Voyage Arrival Date
  • Voyage Sailing Date


SUMMARIES

From the item selector the results can be sent to the standard Summaries screen.

Summaries now include Invoices, Invoice Lines, Cash Payments and Cash Receipts.


All the attributes available in the item selector are available in the summaries for Invoices, Invoice Lines, Cash Payments and Cash Receipts


DATA EXTRACT

The SQL Native Extract for Invoice and Invoices has been extended with new attributes; and the following new tables have been added:

  • Cash Payment
  • Cash Receipt
  • Payment Method
  • Todo Task Resource Types
  • Todo Task Resource Usage
  • HMS Transactions






REPORT MAINTENANCE

The report maintenance screen has been enhanced to include cash payments and cash receipts.



Leave a Reply

Your email address will not be published. Required fields are marked *