Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

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.

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

System Queries on SAP

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

, , , ,