MIGRATED-PAGES‎ > ‎

Other Reports[MIGRATED] http://wavelet.asia/customer-portal/2011/06/28/other-reports/

Report Name
 Step By Step Guide
 Description / Usage / Benefits
 Official Receipt Listing
 Please refer to Official Receipt Listing.
Sometimes, management would like to take a detailed view on the collections, from cash sales to deposit and payment for credit sales are listed here. With separate columns on cash, cheques, post dated cheques and credit cards, managers will be able to get a firm grasp of the cash flow for the company. Users can drill down to individual Official Receipt, and trace the invoices accordingly through the user friendly interface.
 Official Receipt By Credit Card Please see Official Receipt By Credit Card.
This report is useful when it comes to inspecting your credit card receipts at the end of the day. Normal operating standards would require you to vouch the credit card receipts against this report. This check helps you deter fraud and errors in a way that, if :
  • credit card sales entered in EMP, but no receipt printed from the machine to verify the sales - the cashier did not swipe credit card.
  • the amount entered in EMP different from credit card receipt.
  • payment mode entered in EMP is via credit card, but actually the customer paid by cash and vice versa.
 Monitor Outstanding Documents Also check Monitor Outstanding Document.
Monitoring customer credit is extremely important. This report consolidates outstanding invoices grouped by customer from various branches on a real time basis. All customer accounts that have exceeded credit limits or credit terms will be highlighted. Managers could suspend or black list these accounts to prevent further credit sales to these accounts for better control of credit risk.
 Detailed Transaction Records By Customer Check out Detailed Transaction Records.
This report allow users to generate the detailed transactions for specific customers. With this report, users will be able to see exactly how much gross profit has been generated from each customer from the transaction history. Primarily, it includes Invoice, Sales Return and Credit Memo.
  • Filters :
    • Salesman - Choose a salesman name to view only his / her customer records.
    • Customer From / To - To view customers from one PKID to another, like a customer code range.
    • Display Format - Default, Group by Salesman (Details), Group by Salesman (Summary 1), Group by Salesman (Summary 2). Each of these formats differentiates between the columns and how it's displayed.
  • Columns :
    • Standard Price - List Price in Add Item.
    • Discount
    • GP% = GP / Standard Price x 100%
 Periodic Stock Balance and Movement Summary1. Location - Select one or All location.
2. Enter Date Range - From and To.
3. Select Item Code - From and To.
4. Choose a category.
5. Click 'Generate Report Now'.
This is a combination of many reports into one. Different fields are plucked from various reports and combined into. Even though it looks very complicated, this report is actually a complete stock movement of IN and OUT, together with the quantity. The balance quantity of item codes will be indeed, accurate.
  • Sales (+)
  • Sales Return (-)
  • Purchase (+)
  • Purchase Return (-)
  • COGS
  • GP
  • Transfer (+/-)
  • Stock Adjustment (+/-)
 Periodic Stock Balance and Movement By Category1. Location - Select one or All location.
2. Enter Date Range - From and To.
3. Select Item Code - From and To.
4. Choose a category.
5. Group by - 2 levels. Each category is separated by 2 levels.
6. Click 'Generate Report Now'.
This report is the exact report as Periodic Stock Balance and Movement Summary, except that categories can be grouped by different levels.
 Stock Movement Report By GRN 1. Just enter the GRN PKID.
2. Click 'Submit'.
3. Enter date range - From and To.
4. Select Location.
5. Click 'Submit'.
The areas displayed is again, exactly the same as Periodic Stock Balance and Movement Summary, but instead of showing ALL item codes, this report only show the item codes in specific GRN. Therefore, this report is narrowing down into GRNs.

To tell this report apart from Inventory > Stock Reports > Stock Movement Details by GRN Report,
Stock Movement Report By GRN breaks down sales, purchases and transfers into Invoices and GRN. So you will be able to see what invoices sold items from which GRN. However, the balance for both reports will be the same.
 Stock Movement Details By GRN Report
1. Key in the GRN PKID.
2. Click 'Load GRN'.
3. Enter dater range of how far items from invoices were sold from that GRN.
4. Click 'Generate Report'.
This report is concentrated on one GRN at a time. The PKID is entered and the detailed information of the GRN is shown - item code, price, quantity, related supplier invoice and most importantly, the stock movement. The stock movement is shown by any stock-in or stock-out transactions with the related documents (GRN, invoice, sales return, stock transfer).
 Multi Branch Daily Sales, Purchases and Collection Report1. Enter date range.
2. Select Branches.
3. Click 'Submit'.
Users such as higher level management may find this report very useful. At one glance, users will be able to see the sales, gross profit, GRN, trade-in, purchases from suppliers and collection from customers. It is somewhat a brief bird's-eye view of the management of the business on a daily basis.
 Purchase Report By GRN With Inventory Category Grouping1. Select Branch or All Branches.
2. Enter date range.
3. Select 1 level from 'Inventory Category Grouping'.
4. Click 'Submit'.
This report shows all the inflow / purchase of stock for a certain Inventory Group. This inflow includes GRN, Trade-In and Purchase Return done within the date range.






ċ
Unknown user,
Aug 17, 2009, 10:48 PM
ċ
Unknown user,
Aug 17, 2009, 10:41 PM
ċ
Unknown user,
Aug 18, 2009, 12:14 AM
ċ
Unknown user,
Aug 17, 2009, 10:25 PM
ċ
Unknown user,
Aug 17, 2009, 10:20 PM
ċ
Unknown user,
Sep 13, 2009, 10:23 PM
ċ
Unknown user,
Aug 17, 2009, 11:37 PM
ċ
Unknown user,
Aug 17, 2009, 11:34 PM
ċ
Unknown user,
Aug 20, 2009, 12:37 AM
ċ
Unknown user,
Aug 17, 2009, 11:43 PM
Comments