Memanfaatkan System Queries di SAP

Terdapat banyak sekali fitur dari SAP Business One standard yang terkadang tidak diketahui banyak orang ataupun terlupakan oleh pengguna.

Tahukah anda, bahwa terdapat 66 “query cuma-cuma” yang disediakan gratis oleh SAP Business One dan merupakan bagian dari fitur standard bawaan SAP Business One itu sendiri..?

Ya benar, 66 tidaklah sedikit bukan?
Semua query tersebut dapat anda gunakan untuk beragam tujuan, mulai dari mencari tahu laporan tagihan aging, laporan posisi stok, total nilai penjualan, total saldo piutang business partner, dll.

Anda dapat menggunakan semua system query tersebut secara cuma-cuma. Silahkan anda lihat terlebih dulu, putuskan kemudian query-query mana saja yang akan berguna dan dapat membantu anda memperoleh data yang anda inginkan. Tidak perlu bersusah payah memulai dari 0 (nol) lagi untuk merumuskan suatu query laporan.

Baca juga:

• Memberikan Hak Akses untuk User Query
• Query Daftar Top 5 Item berdasarkan Sales

Silahkan akses dari menu bar: SAP Business One Main Menu – Tools – Queries – System Queries

Berikut ini adalah daftar lengkap dari nama-nama SAP Business One standard system query tersebut:

 

1	30 Days’ Rev. and Gross Profit (Customer Comparison)
2	Aging of Payables Overdue (10-Day Interval)
3	Aging of Receivable Overdue (10-Day Interval)
4	Balance Due
5	Best Selling Items by Sales Amount
6	BP Bank Accounts Query
7	Checks for Payment in Date Cross Section Report
8	Credit Limit Deviation
9	Customer Receivables Aging with a 30-Days Interval
10	Customer Receivables by Customer Cross-Section
11	Customers by Receivables Overdue
12	Customers by Sales Amount
13	Customers Credit Limit Deviation
14	External Reconciliation by Due Date
15	External Reconciliation by Exact Sum
16	External Reconciliation by Sum (FC)
17	External Reconciliation by Transaction Number
18	G/L Account Location in Balance Sheets Templates
19	Goods Return Amount
20	Gross Profit Margin % (Year to Date)
21	GRPO Not Invoiced
22	House Bank Accounts Query
23	Inbound Inventory Value
24	Internal Reconciliation by Due Date
25	Internal Reconciliation by Exact Amount
26	Internal Reconciliation by Transaction Number
27	Inventory Days of Supply (By Warehouse)
28	Inventory Turnover
29	Inventory Turnover (By Item Group)
30	Inventory Turnover (By Item Warehouse)
31	Inventory Turnover for Last 6 Months
32	Inventory Value
33	Item Groups by Inventory Value
34	Locate Exceptional Discount in Invoice
35	Locate Journal Transaction by Amount Range
36	Locate Journal Transaction by FC Amount Range
37	Locate Reconciliation in Bank Statement by Row Number
38	Locate Reconciliation/ Row in Bank Statements by Exact Amount
39	Month-End Inventory Value for Last 6 Months
40	Monthly Average Fulfillment Days of Sales Orders by Customers
41	Monthly On-Time Delivery Rate by Number of Orders by Customers
42	My Open A/P Invoice
43	My Open A/R Invoice
44	My Open Inventory Transfer Requests
45	My Sales Orders Not Delivered
46	Number of Open Deliveries
47	Number of Open Sales Orders
48	Number of Open Sales Quotations
49	Number of Open Service Calls
50	Opportunity
51	Outbound Inventory Value
52	Purchase Order Not Received
53	Purchased Items by Purchase Amount
54	Revenue Versus Gross Profit for Last 6 Months
55	Sales Invoice
56	Sales Order
57	Sales Return Amount
58	SP Commission by Invoices in Posting Date Cross-Section
59	Total Payable Amount
60	Total Purchase Amount
61	Total Purchase versus Goods Return for Last 6 Months
62	Total Receivables Amount
63	Total Sales Amount
64	Transactions Received from Voucher Report
65	Vendors by Payables Overdue
66	Vendors by Purchase Amount

Catatan: Tersedia di SAP versi 9.2 ke atas

Baca juga:

• Laporan Kustom – Query Daftar Sales Order (SO) Header dan Detail
• Query Daftar Purchase Order (PO) Header – Detail
• Cara Menambah Database User HANA

Originally posted 2018-03-01 13:25:52.