Oracle Apex ERP GUIDE Document

ERP GUIDE
DOCUMENT
Phone No. 0323-6683663 M Waqas ERP

Implementer
Phone No. 0304-5771644 M Abbas
Software Engineer
Email: info@multi-techno.com
Website: www.multi-techno.com
First floor ghori arcade satyana road
Faisalabad.
2nd Office no 36 Jeff Heights Lahore,
Pakistan
Table of Contents
About Us ................................................................................................................................................. 1
Key System Strengths ............................................................................................................................. 1
Enhanced Business Reporting:............................................................................................................ 1
Better customer service: ...................................................................................................................... 1
Improved Inventory Costs: ................................................................................................................. 1
Boosted Cash Flow: ............................................................................................................................ 1
Cost Savings: ...................................................................................................................................... 1
Features of the Proposed System: ........................................................................................................... 2
1.Application setup ................................................................................................................................. 2
1.1Company Setup ................................................................................................................................. .3
1.1.1Subsidiary ....................................................................................................................................... 3
1.1.2 Location… .................................................... ………………………………………………………………………………4
1.1.3 Accounting Preferences……… ..................................... …………………………………………………………….….5
1.1.4 Transaction Auto Number…………................................... ………………………………………………………..….6
1.1.5 Transaction Status……………… .......................................…………………………………………………………..….7
1.1.6 Data Import Forms From Excel ..................................................................................................... 8
1.2 Manage Role & Responsibilities ........................................................................................................ 9
1.2.1 Role & responsibility setup ............................................................................................................ 8
1.2.2 Module Object ............................................................................................................................... 9
1.2.3 Menu ............................................................................................................................................ 10
1.2.4 Responsibility ............................................................................................................................... 11
1.2.5 Role .............................................................................................................................................. 12
1.3 Manager Users ................................................................................................................................ 13
1.3.1System User Management............................................................................................................ 13
1.3.2 System Administration ................................................................................................................. 14
1.3.3Activity Dashboard ........................................................................................................................ 15
1.3.4 Top Users ..................................................................................................................................... 16
1.3.5 Transaction Delete Log ................................................................................................................ 17
1.3.6 Transaction Verify ........................................................................................................................ 18
1.3.7 View Attachments ........................................................................................................................ 19
1.4 Setup Taxes ..................................................................................................................................... 20
1.4.1 Nexus............................................................................................................................................ 20
1.4.2 Tax Agency ................................................................................................................................... 21
1.4.3 Tax Control Account ..................................................................................................................... 22
1.4.4 Tax Type ....................................................................................................................................... 23
1.4.5 Tax Item ....................................................................................................................................... 24
1.4.6 Tax Group ..................................................................................................................................... 25
2. Financial Module ........................................................................................................................... 26
2.1Financial ....................................................................................................................................... 27
2.1.1Journal Entries........................................................................................................................... 28
2.1.2Recuring Journal ....................................................................................................................... 29
2.1.3 Journal Approve ....................................................................................................................... 30
2.1.4 Budget ...................................................................................................................................... 31
2.1.6 Setup Budgets .......................................................................................................................... 33
2.2.Cash & Bank ................................................................................................................................ 37
2.2.1 Make payment ........................................................................................................................ 38
2.2.2Make Deposit ............................................................................................................................ 39
2.2.3 Employees advances ................................................................................................................ 40
2.2.4 Employees Loans...................................................................................................................... 41
2.2.5 Funds issues ............................................................................................................................. 42
2.2.6 Funds receiving ........................................................................................................................ 43
2.3Accounting setup ......................................................................................................................... 44
2.3.1Charts of accounts .................................................................................................................... 45
2.3.2Currencies ................................................................................................................................. 46
2.3.3Currency rates ........................................................................................................................... 47
2.3.4Payment terms.......................................................................................................................... 48
2.3.5Accounting period ..................................................................................................................... 49
2.4Set up taxes .................................................................................................................................. 50
2.4.1Nexus ........................................................................................................................................ 51
2.4.2Tax Agency ................................................................................................................................ 52
2.4.3Tax Control account .................................................................................................................. 53
2.4.4Tax types ................................................................................................................................... 54
2.4.5Tax items ................................................................................................................................... 55
2.4.6Tax Groups ................................................................................................................................ 56
2.5 Classification ............................................................................................................................... 57
2.5.1Departements ........................................................................................................................... 58
2.5.2Classes ....................................................................................................................................... 59
2.5.3Countries ................................................................................................................................... 60
2.5.4State .......................................................................................................................................... 61
2.6Financial Reports.......................................................................................................................... 62
2.6.1Accounts Ledger........................................................................................................................ 63
2.6.2Trail Balance .............................................................................................................................. 64
2.6.3Balance Sheet............................................................................................................................ 65
2.6.4Profit/loss statement ................................................................................................................ 66
2.6.5Daily collection reports ............................................................................................................. 67
Inventory Management System: ....................................................................................................... 57

Purchase Management System: ........................................................................................................ 69
Accounts Payables: ........................................................................................................................... 71
Sales and Order Management: .......................................................................................................... 92
Accounts Receivables: ...................................................................................................................... 93
CRM With Order Booking App:..................................................................................................... 112
Project Management System: .............................................................. Error! Bookmark not defined.
Production Management System: ........................................................ Error! Bookmark not defined.
HR and Payroll System: ...................................................................................................................... 8
Key Business Intelligence Features .................................................................................................... 120
1. Ranking Reports.......................................................................................................................... 142
2. What-If Analysis ......................................................................................................................... 142
3. Executive Dashboards ................................................................................................................. 142
4. Interactive Reports ...................................................................................................................... 143
5. Geospatial Mapping .................................................................................................................... 143
6. Operational Reports .................................................................................................................... 143
7. Pivot Tables ................................................................................................................................ 143
8. User-Specific Security ................................................................................................................ 143
About Us
Multi-Techno is an ERP Software, Systems design and Implementation IT firm. Our system is
an industry customized ERP System designed for your organization. We feel proud to
present you our technology automations systems and applications that have promising cost
reduction, business cycle improvements, effective, efficient business resources utilization
and get your all business insight on just one click on your Smart phones, tablet PCs and
Laptops.
Key System Strengths

System will be implementing in Oracle Apex 22.0.1 and Oracle 19c
database
Enhanced Business Reporting:
 Better reporting tools with real-time information
 A single source of truth, one integrated database for all business processes
Better customer service:

 Better access to customer information
 Faster response times
 Improved on-time delivery
 Improved order accuracy
Improved Inventory Costs:

 Only carry as much inventory as needed, avoid these common issues
 Too much inventory, and higher overhead costs
 Too little inventory, and longer customer fulfillment times
Boosted Cash Flow:

 Better invoicing and better collections tools to bring cash in faster
 Faster cash means more cash on-hand for the business
Cost Savings:
 Improved inventory planning
 Better procurement management
 Better customer service
 Improved vendor relationship management
1
Multi-Techno | Integrated Solutions
Features of ERP System
Modules of the Proposed System:
 Administration/Securities Management System
 Financial Module/Fixed Asset
 Inventory Management System
 Purchase Management System
 Accounts Payables
 Sales Management System(POS)
 Accounts Receivables
 CRM with Order Booking App
 Project Management System
 Production Management System
 HR and Payroll System
A brief description of the Features of the System is as follows:

System to be developed in Oracle 19c database
Oracle Apex & jasper Reports all Reports can Export to PDF ,Excel CSV Format
 1. Application setup:
The Administration module allows you to control the operation of Business Process, and
manage all users and groups. This chapter describes how to start the Business process,
explore the administration interface. It covers the base data that is linked into the other
modules for transactional purpose. Its main features include:
Company Setup: Manage User:

 Define Subsidiary  System User Management
 Define Locations  System Administration
 Accounting Preferences  Activity Dashboard
 Transaction Auto Number  Top Users
 Transaction Status  Transaction Delete Log
 Data Import Forms from Excel  Transaction Accounting Verify
 View Attachments
Manage Role/Responsibility:
 Role & Responsibility Setup Setup Taxes:
 Modules  Nexus
 Module Object  Tax Agency
 User Menu Define  Tax Control Account
 User Responsibility Define  Tax Types
 User Role Define  Tax Items
 Tax Groups
2
1.1 Company Setup:
 Define Subsidiary
 Define Locations
 Accounting Preferences
 Transaction Auto Number
 Transaction Status
 Data Import Forms from Excel
1.1.1 Subsidiary:
Here we can see the administration setup is divided into different items firstly we’ll define
the company setup in which first item is subsidiary, Subsidiary is used for the company
information. The purpose of this tab is how to establish or create company information to use
this tab. When you open the subsidiaries tab on the left corner (create) button click on it then
another page open put the some requirements like: Company Name, Address, Email,
Currency, GST no NTN no, Logo. Then click on right side down create button easily create
the subsidiary information.
3
1.1.2 Location:
Here we can set the multiple number of Warehouses, Branches and stores location. Firstly we
can add the location name, description, parent location, city, country, address.
4
1.1.3 Accounting Preferences
In this tab we can set the accounts by default. Accounting preference is started expenses
account set by name and with account number like cash in hand, petty cash, and highlight
with numbers like 1000123 cash in hand type name also exist here. We can set different
accounts by default e.g. Income Accounts, Cash Accounts, Receivables Accounts, Payables
Account, Bank Accounts, Assets Accounts Gain, Loss Accounts.
5
1.1.4 Transaction Auto Number:
In this tab we can set the transaction auto number of each transaction type.
When we open the transaction tab we can see Transaction type,
Form type, Prefix, Number length, Subsidiary, Location, Department, Month Wise, Year
Wise, Auto Number Format.
All transactions number are differentiate on the behalf of location, subsidiary, department,
month wise and year wise.
6
1.1.5 Transaction Status:
Transaction status is the last part of the Application setup in this tab we can see the
transaction type and create the status by default such as for example transaction type show on
the create page like Employees Loans there are different type of status are set approved,
rejected, pending approval. Posted status in which condition of the transaction posted,
unposted.
7
1.1.6 Data Import Forms from Excel
In this tab we can define the data upload by excel formats.
8
1.2 Manage Role/Responsibility:
 Role & Responsibility Setup
 Modules
 Module Object
 User Menu Define
 User Responsibility Define
 User Role Define
9
1.2.1 Role & Responsibility setup
This part of the Application setup is Manage role & responsibilities In this part we’ll see the
all over roles, responsibilities according to their directions. For example Accountant Manger
is a role further in which roles are define responsibility like financial module, order booking
app, trading reports etc.
10
1.2.2 Module Object
In this setup we’ll define module object in which we can see overall forms of the modules.
Like module title is accountant, object name is transaction accountant verify, object type is
reports or forms, transaction type is used for the transaction like cheque, work progress.
11
1.2.3 Menu
Here we can define the menu. We can create menu from different forms in which menu
name, menu title, description, sort order, effective form, and effective to.
12
1.2.4 Responsibility
Her we can define responsibility have different forms and menu. Responsibility perform
different roles. We can assign directly forms to the responsibility.
13
1.2.4 Role:
We can define location, subsidiary, class, department so we can differentiate the user rights
and responsibilities. In this tab we can define the roles according to the require forms. We can
assign multiple responsibilities. For example if a user need the CRM we can only assign that
role. The user easily access those functions according to their requirements.
14
1.3 Manage User:
 System User Management
 System Administration
 Activity Dashboard
 Top Users
 User Feedback
 Transaction Delete Log
 Transaction Accounting Verify
 View Attachments
1.3.1 System User Management:
An individual or (system) process working on behalf of an individual who has permission to

access information and information systems in order to carry out specific tasks.
15
1.3.2 System Administration
In order to make sure that computer systems are working successfully and efficiently, system
administration include maintaining and administering both the hardware and software
components of the systems. In this tab including some other functions like Dashboard, Top
users, Application Error log, Page Performance, Page View.
16
1.3.3 Activity Dashboard
Users can control all of their employees' and administrators' activity placed on several
applications from a single dashboard by using the Schedule Activity Dashboard. We can see
the status of activation of single user.
17
1.3.4 Top Users
In this tab we can easily define the top users who are represent their activation status
according to time.
18
1.3.5 Transaction Delete Log
In this tab we can define the delete portion of the transaction. We can see the login id,
transaction id, and transaction number, transaction type, and trandate, delete reason, delete
date, delete by, each and every thing is clearly define with their reasons.
19
1.3.6 Transaction Accounting Verify
Here we can define the subsidiary, location and project. To verify the transaction.
1.3.7 View Attachments
In this tab we can see the attachments of documentation. When enter the data of any company
their location, subsidiary and class, department define. Then attach some documents like their
quotation, their business card etc.
20
1.4 Setup Taxes:
 Nexus
 Tax Agency
 Tax Control Account
 Tax Types
 Tax Items
 Tax Groups
21
1.4.1 Nexus
Next part of the application setup is the setup taxes. In this tab we can define the country
details. Country name, description, nexus id and state.
22
1.4.2 Tax Agency
In this tab we can see the multiple vendor’s primary information. Vendors name, tax agency,
purchase manager, city, district, country, state, email, phone number, bill address, ship
address, and factory address these type of information is necessary in tax agency.
23
1.4.3 Tax Control Account
In this tab taxes is interlink with chart of account. When we create the taxes account their tax
is show automatically in chart of account. Name, Account no, Description, Tax Account
Type, Account type theses information is important for the tax control account.
24
1.4.4 Tax Type
Here we can see the types of taxes set by own requirements. In this tab we can define the
name and description show GST, Liability sales tax act, nexus, and purchase sales tax act.
25
1.4.5 Tax Items
Tax item basically called tax code. Tax code is impalement according to the ratio of tax allow
by the state in different business for example VAT 10%. Name, Description, Rate, Tax
Agency, Country, State etc.
26
1.4.6 Tax Groups
We can combine different groups of taxes apply on the time of transaction.
27
2. Financial Module:
A general ledger contains all the accounts for recording transactions relating to a company's
assets, liabilities, owners' equity, revenue, and expenses. In modern accounting software or
ERP, the general ledger works as a central repository for accounting data transferred from
all sub ledgers or modules like accounts payable, accounts receivable, cash management,
fixed assets, purchasing and projects. The general ledger is the backbone of any accounting
system which holds financial data for an organization. The collection of all accounts is
known as the general ledger. Each account is known as a ledger account.
Financial Classification
 Journal Entries  Department
 Recurring Journal  Classes
 Journal Approve  Countries
 Budget  State
 Quota
Setup Taxes:
Cash & Banks  Nexus
 Make Payment  Tax Agency
 Make Deposit  Tax Control Account
 Employee Advance  Tax Types
 Employee loan  Tax Items
 Funds Issue  Tax Groups
 Funds Receiving
Accounting Setup Financial Reports:
 Charts of Accounts  Accounts Ledgers
 Currencies  Trail Balance
 Currency Rates  Balance Sheet
 Payment Terms  Profit or Loss Statement
 Accounting Periods  Daily Collection Report
 Cash In Out Flow
28
2.1 Financial
Financial
 Journal Entries
 Recurring Journal
 Journal Approve
 Budget
29
2.1.1 Journal Entries
Journal Entries is the sub part of the financial tab. Here we can define the multiple function to
represent the different types of journals like liability, opening customer, receivable accounts,
and supplier, opening cash account, opening equity account, payable account, fixed assets,
these are the some type of journals we can create in this part of financial module.
Here are some examples how to add journal on this tab and how to work it firstly we can
see the Opening Cash Account.
30
31
How to create Supplier payable opening account
How to add Customer Receivable Opening
32
How to add Opening Fixed Asserts
33
2.1.2 Recurring Journal
Define recurring journal formulas for transactions, such as accruals, depreciation charges, and
allocations that you repeat each accounting period. In this tab we can set the time period
recurring interval monthly, yearly quarterly.
34
2.1.3 Journal Approve
A journal can be approved either immediately after creation and submission or at a later time
by choosing it from the list of journals. Journals can be approved individually or in groups.
The status of a journal changes to "Approved" after your approval, at which point it can no
longer be updated. In this tab we can change the status like journal pending approval. Then 2
options show approve or reject. Who have rights they can chose the status according to the
situation.
35
2.1.4 Budget
Here we can specify the amount of budget. Budget is based on year quarter period.
For example we can set the target amount of any asserts and use in throughout the year. In
the end of year we can analysis the target amount of budget and the real amount.
36
2.2 Cash & Banks
 Make Payment
 Make Deposit
 Employee Advance
 Employee loan
 Funds Issue
 Funds Receiving
37
2.2.1 Make Payment
Here we can make the payment according to different accounts like cash in hand, petty cash.
In this tab we set the payment type such as cash payment voucher and bank payment voucher.
In this we can enter the expense account and cheque clearing data.
38
2.2.2 Make Deposit
Here we can define the how to make deposit. In this tab we can provide to the suppliers.
Suppliers automatically deposit cash and enter the information in this tab to create this.
39
2.2.3 Employee Advance
In this tab we can define the employee advance payment. Here we can set the employee
advance salary report. We can provide salary in advance to their workers. In this condition
this tab is used.
2.2.4 Employee Loans

In this tab we can define the status of employee loan. Which worker get loan in advance.
Then we can provide the loans to the employee. Each month deduction by their salaries.
40
2.2.5 Funds Issue
Funds issue play vital role in the transactions occur between 2 locations.
Funds issue intercompany from one location to other location.
2.2.6 Funds Receiving
41
In this we can receive funds from other location. We can select the account type where we
receive funds then we click on the approved funds or pending approval.
2.3 Accounting Setup

 Charts of Accounts
 Currencies
 Currency Rates
 Payment Terms
 Accounting Periods
42
2.3.1 Chart of Accounts
There is the 3rd part of the financial module is chart of account in this tab we can define 5
types of Accounts like Assert, Liability, Stockholder Equity, Revenue, Expense, Statistical.
 In Assert we can add other current asserts, fixed asserts.

 In Liability we can add other current liability, long term liability.
 In Stockholder Equity we can add opening balance equity, retained earnings.
 In Revenue we can add income, other income.
 In Expense we can add cost of goods sold, admin expense, factory overhead, administrative
expense, selling expense, and depreciation expense, gain/loss account, landed cost.
43
In this tab we can see how to create the chart of account click on the create button enter
name, description, parent account, account type, restricted to location and also restricted to
subsidiary. Then other data automatically fill.
44
Here we can make the parent account for this just account type enter then all data fill
automatically.
2.3.2 Currencies
The purpose of the tab is to create multiple currencies according to the country. For
example United Arab Emirates use Dirham symbol is AED.
45
2.3.3 Currency Rate
In this tab we can use to define the rate of currency. For example base currency rate is
rupee and receive currency in dollars this tab can exchange the rate easily.
2.3.4 Payment Terms
46
Here we can define the payment terms to other ones. In this procedure we can fix the
payment time period. Such as payment due date is 30 days. We can change according to
your interest.
2.3.5 Accounting Period

In this tab we can provide open access on the current accounting period. In this we can
close the previous month period nobody enter the data. Next accounting period run
according to the present month.
47
2.4 Classification
 Department
 Classes
 Countries
 State
2.4.1 Departments
In this tab we can define the department according to roles.
48
2.4.2 Classes
Here we can differentiate on the bases of business type or requirements. Select those
classes which are your requirement.
2.4.3 Countries
In this tab we can define the country vise differentiation. Full country name represent short
name of country for example Pakistan is full name short name pk.
49
2.4.4 State
In this tab we can see the country define with their state.
50
2.5 Financial Reports:
 Accounts Ledgers
 Trail Balance
 Balance Sheet
 Profit or Loss Statement
 Daily Collection Report
 Cash In Out Flow
2.5.1 Accounts ledgers
In this tab we can define the account's beginning balance, all debits and credits made
throughout the period, and the account's closing balance are all displayed in the ledger. All
balance sheet and income statement accounts, including accounts receivable, accounts
payable, sales, and payroll, can be kept in a company's ledger.
51
2.5.2 Trial Balance
This makes it easier to create accurate financial statements at the conclusion of each
accounting period and guarantees that every journal entry is balanced. In this tab we can
see the asset, liability, equity, revenue, expense.
52
2.5.3 Balance Sheet
The assets and liabilities of a firm are show in detail on a balance sheet, which is a financial
statement. The first side show the assets in which 2 types of assets current assets and fixed
assets on the other side is liability in which first show current liability and long term liability.
In stockholders equity in which present the opening balance equity, opening stock, opening
supplier’s payables and cash flow statement used to assess a company's performance is the
balance sheet.
53
2.5.4 Profits/ loss in statement
A business's financial statements include a profit and loss account that details its financial
performance. It provides an overview of a company's financial performance over a specific
time period (usually one year), including both income and expenses.
54
2.5.5 Daily Collection report
The Collection Summary report gives you an overview of the receipts, cash that were
collected, how they were applied (invoices, debit memos, service charges, or left unapplied),
and the typical number of days it took to collect the money. This information can help you
evaluate a client's payment patterns.
55
2.5.6 Cash in outflow
Here we can see the opening balance, closing balance in cash flow management, cash in and
out details are present in the shape of a statement. Further, by indicating how the money
went in and out of the firm, the statement of cash flows provides the connection between
the financial reports.
56
3. Inventory Management System:
An inventory management system is a tool that allows you to track goods across your
business’s supply chain. It optimizes the entire spectrum spanning from order placement
with your vendor to order delivery to your customer, mapping the complete journey of a
product.
Items Setup: Items Reports:

 Items  Items Ledger
 Items Category  Stock Movement Report
 BINS  Inventory Profit Margin
 Unit Types  Items Detail Ledger
 Item Barcode Generate  Items Detail Closing Report
 Price type  Inventory Transfer
Inventory :  Inventory Adjustment
 Inventory Adjustment  Transfer Order
 Inventory Transfer  Items Closing As On Date Report
 Transfer Order  Minimum Stock Report
 Pending Delivery Challan  Re order Level Report
 Pending Receive order list
3.1 Item Setup:

 Items
 Items Category
 BINS
 Unit Types
57
 Item Barcode Generate
 Price type
3.1.1 Items
In this tab we can create the new items and edit the previous items. In which we can click on
create button the write the item name, description, unit type, brand name, item color, model,
item size. In this we can see the item types like services, raw material, assembly. In this we
can define the sales and purchase description. We also attach the pictures of the items.
58
3.1.2Item Category
Here we can see the different items with different category. Enter item name, full name parent id.
59
3.1.3 Unit Types
Here we can open multiple units. Like Meter, Nos, Kg, Pcs etc.
60
3.1.4 Item Barcode Generate
We can create different types of barcode in it.
3.2Inventory:
 Inventory Adjustment
 Inventory Transfer
 Transfer Order
 Pending Delivery Challan
 Pending Receive order list
61
3.2.1 Inventory Adjustment
This is the part of inventory modules in which we can adjust the inventory setup. The purpose
of this tab for opening stock. In the end of the month we can adjust the items increase or
decrease according the situation.
62
3.2.2 Inventory transfer
In this tab we can see how to inventory transfer from one location to another location.
3.2.3 Transfer Order
Here we can see the how order transfer from one location to another location. In which we
can create the delivery challan.
63
3.2.4 Pending Delivery Challan
We can see the how many challans are pending.
64
3.2.5 Pending Receive Order List
Orders with the status "Pending" have been received by the vendor, but the payment
processing has not yet taken place. In the majority of cases, the seller will finish the payment
shortly after receiving the order.
65
3.3 Items Reports:
 Items Ledger
 Stock Movement Report
 Inventory Profit Margin
 Items Detail Ledger
 Items Detail Closing Report
 Inventory Transfer
 Inventory Adjustment
 Transfer Order
 Items Closing As On Date Report
 Minimum Stock Report
 Re order Level Report
66
3.3.1 Items Ledger
In this tab we can see the detail of 1 item how many items are purchase and sale. And we can
also see the how production increase the stock.
67
3.3.2 Stock Movement Report
We can see the every items movement details in it. We can see the opening balance, opening
amount, receive quantity, and receive amount, issue quantity, issue amount, closing quantity,
and closing amount. In this tab we can differentiate the items sock category, location vise.
68
3.3.3 Inventory Profit Margin
In this tab we can see the profit margin how many items purchase and how many items sales
then calculate the total profit.
69
3.3.4 Items Closing As On Date Report
Here we can see the items store vise, category vise and location vise closing at on date
report.
70
4. Purchase Management System:
Purchase management is a system that is used for order placement for the timely receipt of
inventory stock. It streamlines the purchasing and inventory control process of an
organization for greater efficiency and lower costs.
Vendor Define: Purchase Reports:

 Vendor Definition  Purchase Order Detail Report
 Purchase Order Summary
Procurement:
 Import Shipment Report
 Requisition
 Request for Procurement Payable Reports:
 Purchase Quotation  Vendor Ledger
 RFQ  Vendor Closing Report
 Purchase Quotation  Daily Purchase Report
Purchase:  Vendor Forecasting Report
 Purchase Order
 Vendor Aging
 Inbound Shipment
 Pending Inbound Shipment  Vendor Details Ledger Report
 Pending Receive Order List  Pending Item Receipt For Billing
 Items Receipts  Outward Post Dated Cheque
 Vendor Return  Unbuild Payable Closing Balance
Payable:  Unbuild Payable Ledger
 Enter Bills
 Pay Bills
 Vendor Credit
71
4.1 Vendor Definition
 Vendor
4.1.1 Vendor
In this tab we can define the whole information of the vendors. Like their name, type of
Vendor. City, country, state contact number. Here we can define the bill address, ship
address, factory address. We can add financial information purchase scheme.
72
4.2 Procurement:
 Requisition
 Request for Procurement
 Purchase Quotation
 RFQ
 Purchase Quotation
4.2.1 Requisition
Here we can create the department vise demand of material. In this tab we can manage the
store demands.
73
4.2.2 RFQ
RFQ mean the request for quotation, in this tab we can create the quotation after the
requisition. Here we can see the comparison statement of vendors.
4.2.3 Purchase quotation

In this tab we can receive the purchase items by vendor then enter in purchase quotation to
make the new quotation.
74
4.3 Purchase:
 Purchase Order
 Inbound Shipment
 Pending Inbound Shipment
 Pending Receive Order List
 Items Receipts
 Vendor Return
4.3.1 Purchase Order

In this tab we can order to vendor to purchase items. When vendor complete the task to receive
the order. In this tab one button of the inbound shipment here we can direct on & off the button if
we need to inbound shipment then click the button of, and if we no need inbound shipment simply
click the button and off the button
75
4.3.2 Inbound Shipment
Here we can create the inbound shipment information in this tab. We can add the transaction
date, expected shipping date, expected delivery date, shipping number, actual shipping date,
actual delivery date. Here we can change the shipping status like to be shipped, in transit, and
received. In transaction line we can enter the whole information about the product such as
item name, quantity, amount, vendor name etc. in which we can describe the landed cost,
related transaction, system information.
76
77
78
4.3.3 Pending inbound shipment
In this tab we can create the pending inbound shipment. This tab show us how many
shipment are pending and how many are approved.
79
4.3.4 Pending Receive Order List
Orders with the status "Pending" have been received by the vendor, but the payment
processing has not yet taken place. In the majority of cases, the seller will finish the payment
shortly after receiving the order.
80
4.3.5 Items Receipts
In this tab we can see the overall items receipts.
81
4.3.6 Vendor Return
A vendor return authorization is a non-posting transaction that keeps track of a return to a

vendor. It does this by recording the items to be returned, their quantities, the approval status,
the shipment status, and the amount that the vendor will refund or credit.
4.4 Payable:
 Enter Bills
 Pay Bills
 Vendor Credit
82
4.4.1 Enter Bills
This tab is basically use for the purchase invoice. Here we can stand the vendor payables.
83
4.4.2 Pay Bills
Vendor payments, commonly referred to as accounts payable or invoice to pay, refer to the
procedure of compensating suppliers for the goods and/or services they provide to your
business.
84
4.4.3 Vendor Credit
Here we can see the supplier balance. This is interlink with purchase order. When item
returns ten the suppliers balance decrease.
4.5 Purchase Reports:

 Purchase Order Detail Report
85
 Purchase Order Summary
 Import Shipment Report
4.5.1 Purchase Order Summary

In this tab we can see the entity. Here we can create the PO quantity and then check the
receive quantity. We can also see the vendor date and vendor bill quantity.
86
4.6 Payable Reports:
 Vendor Ledger
 Vendor Closing Report
 Daily Purchase Report
 Vendor Aging Report
87
4.6.1 Vendor Ledger
The tab is only use for the vendors ledger create in it. In this tab we can see the debit side
show the payments and credit show the invoices. In this tab we can also see the vendor ledger
with postdated cheque and without postdated cheque.
88
4.6.2 Vendor Closing Report
In this tab we can see all the vendor closing balance.
89
4.6.3 Daily Purchase Report
We can check the how many purchase items in a day. Daily purchase report we can see here.
And also differentiate the sales, purchase criteria.
90
4.6.4 Vendor Aging Report
In this tab we can see the invoices record according the days. We can see here in which day
invoice is generate and in which day invoice is paid.
91
5. Sales and Order Management (POS):
Order management is becoming increasingly complex as almost every business has multiple
customer interaction points which keep orders flowing in from different sales channels.
A high level of customer service that creates satisfied customers and keeps them intact for
life requires an order management process that is perfectly planned. In order to turn your
sales order management process flow business-specific and customer centric.
Receivable Report
Setup:
 Invoice
 Customer Define  Recurring Invoice
 Customer Payment
 Credit Memo
POS: Sales Report
 Restaurant Point of Sale  Sale Order Details
 Cash Sale  Sale Order Summary
 Mart Point of Sale  Data Wise Sale Order Planning
 Item Wise Sale Order Planning
 Delivery Orders Details
Sales: Receivable Reports:

 Quotation  Sale Invoice Details
 Sales 360 Dashboard  Customer Ledger
 Sale Order  Customer Closing Report
 Pending Delivery Challan  Customer Aging
 Delivery Challan  Customer Forecasting Report
 Customer Return  Customer Details Ledger Report
 Inward Post Dated Cheque
 Sale Invoice and Recovery Report
92
5.1 Setup:
 Customer Define
5.1.1 Customer Define
In this we can define the customer. In this tab we can see the primary information about the
customers. Name, customer type, city, country, district, contact number etc.
93
5.2 POS:
 Restaurant Point of Sale
 Cash Sale
 Mart Point of Sale
5.2.1 Restaurant Point of Sale

In this tab we can select the different items and create the invoices of those items. Here we
can use different payment methods through cash, card and credit.
94
5.2.2 Cash Sale
In this tab we can Cash automatically debit and sale is credit in the system.
95
5.2.3 Mart Point of Sale
In this tab we can sale the items through scanner. Here we can add the customer phone number, name,
transaction date, transaction number, scan item, items type, and number of items.
96
5.3 Sales:
 Quotation
 Sales 360 Dashboard
 Sale Order
 Pending Delivery Challan
 Delivery Challan
 Customer Return
97
5.3.1 Quotation
In this tab we can see how to generate quotations. When client confirmed then we’ll share the
quotation in which we can see the quotation date, end date, memo, project, and department,
class etc.
98
5.3.2 Sales 360 Dashboard
In this tab we can see the item category, customers, region wise, date filter yearly, quarterly
and monthly, Classification Subsidiary, location, department, classes.
99
5.3.3 Sales Order
Here we can add the order receive by the customers.
10
0
5.3.4 Pending Delivery Challan
In this tab after sales order we can check the Pending delivery challan. In this tab we can
filter the type, entity then click on the create delivery challan. We can see the pending
delivery challan through entity wise.
10
1
5.3.5 Delivery Challan
Here we can create the delivery challan after sales the items. In this tab we can use the QR
system to scan the items challan.
5.3.6 Customer Return

In this tab we can see the item are return by customers. Here we can create the invoices.
10
2
5.4 Receivable Report
 Invoice
 Recurring Invoice
 Customer Payment
 Credit Memo
10
3
5.4.1 Invoice
Here we can create the invoices after the sales the items. Create invoice directly without
delivery challan. Create credit memo, and sales order in this tab.
10
4
5.4.2 Recurring Invoice
In this tab we can save the invoices according to the time period. In this tab we can set the
time period recurring interval monthly, yearly quarterly. Invoices generate according to
already set date of the month.
10
5
5.4.3 Customer Payment
In this tab we can pay the customers through invoices. We can select the payment type like
through bank or cash in hand. We can use the different methods of payment like monthly,
partially.
10
6
5.4.4 Credit Memo
Here we can manage the customer balance through this tab. If any items return then we can
manage the balance of the customer. We can provide any discount to the customer in this tab.
10
7
5.5 Sales Report
 Sale Order Details
 Sale Order Summary
 Data Wise Sale Order Planning
 Item Wise Sale Order Planning
 Delivery Orders Details
10
8
5.6 Receivable Reports:
 Sale Invoice Details
 Customer Ledger
 Customer Closing Report
 Customer Aging
 Customer Forecasting Report
 Customer Details Ledger Report
 Inward Post Dated Cheque
 Sale Invoice and Recovery Report
10
9
5.6.1 Customer ledger
In this tab we can see the customer ledger from date to date. Here we can add the customer
we can see the detail of the customer and show the ledger. In this we can see the transaction
number, memo, debit, credit and closing balance.
5.6.2 Customer Closing Report
11
0
6. Production Management System:
This system will manage company production record and history. Employee can record daily
Material issuance, expenses to production, you can see the per unit cost in running
production .You can analyze the production cost with previous per unit cost.
Setup:
 CRM
 Project
 Project Transaction Reports
11
1
6.1 CRM with Order Booking APP:
CRM software helps business understand their customer better, identify opportunity for
growth, and improve business satisfaction. It allows companies to segment their customer
base and target specific groups with personalized marketing campaigns, offers, and
promotions.
Setup: Reports:
 Contacts  Leads Report
 Leads  Prospect Report
 Prospect  CRM Task Report
 Customer
 Quotation
 CRM Task Status
 CRM Task Calendar
Order Booking App:
 Order Booking Form
 Salesman App Center
 Customer Payments
 Customer ledger
 Orders & Delivery Challan
 Attachments
 Customer Location Tracking
 Customer Map View
 Employee Location Routes
11
2
Setup:
 Contacts
 Leads
 Prospect
 Customer
 Quotation
 CRM Task Status
 CRM Task Calendar
11
3
6.1.1 Contact
In this tab we can see the contacts primary information. Contacts name, titles, comment,
First name, middle name, last name, full name. Their city, country, state, email address,
phone number, office phone number, supervisor phone number etc.
11
4
6.1.2 Leads
In this tab we can add the primary information of the lead. You can add the company name,
source of contact, status like open, qualified, and unqualified. Contact person their
designation. City, country, state, address, phone number. Add information through
subsidiary, department, location and classes wise. We can add tasks in this tab .
11
5
6.1.3 Prospects
In this tab we can add the information as such add in leads. Only change the status
according to the condition like Prospect in negotiation, prospect in discussion, prospect
qualified etc.
11
6
6.1.4 Customer
11
7
7. HR & Payroll System:
This system will manage company employee’s record and history. Employee daily
attendance, Employee Leave Management, Advances and Payroll auto generated salary
make less men power.
Payroll Process:
HR Setup:
 Payroll Process Run
 Employee  Payroll Process Run Results
 Employee Type  Pay Pre Payments
 Work Calendar  Costing Process Run
 Define Employee Salary  Employee Expense Claim
HR Attendance:
 Time Attendance Main Reports:
 Time Attendance Summary  Employee ledger
 Time Attendance Register  Employee Closing Balance
 Employee leave application  Employee Salary Sheet
 Accrual Plan Balance  Employee Advance Report
 Overtime Approval  Employee Loan Summary
 HR & Payroll Dashboard
Payroll Setup:
 Payroll define
 Element Types
 Payroll Formula
 Pay User Table
 Pay User Table Value
 Pay Balance Type
 Pay Balance Dimensions
11
8
7.1 HR Setup:
 Employee
 Employee Type
 Work Calendar
 Define Employee Salary
11
9
7.1.1 Employee
In this we can add the employee personal information. Enter the employee name, hired date,
gender, city, country, and address put employee image in it. We can add the job details like
their designation, employee machine number, supervisor name, define payroll, regular
monthly payroll, and basic salary. We can define the employee type, work calendar, working
status like still working, freeze, and transfer.
12
0
7.1.2 Employee Type
Here we can add the employee type such as software engineer, worker, helper etc.
12
1
7.1.3 Work Calendar
Here we can see the employee working summary. In this we can see the working shift,
working hours per day, shift time period start time to end time. Condition in minute at
minimal level. We can see break time period. IN/Out time, working days of a employee you
can see.
12
2
7.1.4 Define Employee Salary
Here we can create the employee salary details. In this we can put the employee name,
effective from date, creation date, current salary, new salary, change amount, change
percentage.
12
3
7.2 HR Attendance:
 Time Attendance Main
 Time Attendance Summary
 Time Attendance Register
 Employee leave application
 Accrual Plan Balance
 Overtime Approval
 HR & Payroll Dashboard
12
4
7.2.1 Time Attendance Main
Every employee attendance we can see here. We can see the IN/OUT time of every
employees date and time wise.
7.2.2 Time Attendance Summary
In this tab we can see the individual employee attendance status in time, out time and date.
7.2.3 Time Attendance Register
12
5
Here we can generate attendance subsidiary, location, department and payroll wise. We can
create manual and auto generate attendance.
7.2.4 Employee Leave Application
12
6
In this tab we can see the employee leave application. We can see the total number of
employee on leave. Reason of leave, start date and end date according to number of days we
can see.
7.2.5 Overtime Approval
We can see the employee overtime period day wise. And also see the number of overtime of a
single employee. In this tab we can see the shift type of the overtime of an employee.
7.2.6 HR & Payroll Dashboard
12
7
7.3Payroll Setup:
 Payroll define
12
8
 Element Types
 Payroll Formula
 Pay User Table
 Pay User Table Value
 Pay Balance Type
 Pay Balance Dimensions
7.3.1 Payroll Define
12
9
In this tab we can create the payroll on the basis of regular monthly salary, salary based,
daily
wages, weekly wages.
7.3.2 Element Types

Here we can define the element name, start date, end date, classification, and description.
13
0
7.3.3 Payroll Formula
In this tab we can create the employee payroll formula such as provide medical allowance,
insurance,
Basic salary, payment, salary loan, travelling allowance, each and every thing is define in this tab.
13
1
7.4 Payroll Process:
 Payroll Process Run
 Payroll Process Run Results
 Pay Pre Payments
 Costing Process Run
 Employee Expense Claim
13
2
7.4.1 Payroll Process Run
In this tab we can see how payroll process run. Here we can add subsidiary, location department,
payroll type. We can see the action type like costing run, pre-payment, process run results, reverse
process these all are interlink with each other. Action status, effective date and end date also see
here.
13
3
7.4.2 Payroll process Run Results
In this simply we can add the payroll type, employee name, element name, period from, period to
then we can see the process run results of the employee.
13
4
7.4.3 Pre Payment
In this tab we can create employee salary slip in easiest way.
13
5
7.4.4 Costing Process Run
In this tab we can see how costing process run and how to generate JV here.
13
6
7.4.5 Employee Expense Claim
Here we can add the employee expense claim details. Like employees travelling expense, fuel
expense.
7.5 Reports:
 Employee ledger
 Employee Closing Balance
 Employee Salary Sheet
 Employee Advance Report
 Employee Loan Summary
13
7
7.5.1 Employee ledger
Here we can see the employee ledger details from date to, to date, employee name enter then see
the opening balance, closing balance, debit, credit information.
7.5.2 Employee Closing Balance
Here we can the employee closing balance.
13
8
7.5.3 Employee Salary Slip
In this tab we can the employee salary slip details. Here we can see their working days, holidays,
leaves, basic salary, medical allowance, gross salary, other incentives, income tax, loans, salary
advance, and payable salary.
13
9
14
0
14
1
Key Business Intelligence Features
The most important business intelligence features graphical representation and detail about
them mentioned below:
1. Ranking Reports
Ranking reports let you easily view the best- and worst-performing facets of your business,
from products to marketing campaigns to salespeople. You can view rankings across multiple
dimensions and specify various criteria to focus your results.
2. What-If Analysis
If you’re curious about how a future decision will affect your business, you can run a “what-
if” analysis using past data to predict the potential impacts. Tools for what-if analyses give
you an objective view of the risks and rewards involved in each potential decision, and allow
you to plan better for the future.
3. Executive Dashboards
Executive dashboards give your organization’s leaders a real-time overview of your business
in the form of graphs, charts, summaries and other information reports. They allow your
company’s executives to make smarter, faster and better decisions.
14
2
4. Interactive Reports
Interactive reports allow users to condense the massive amounts of collected data into a
wide variety of possible views. Users can take advantages of features like statistical analysis
and regression to identify trends, anomalies and outliers in the data.
5. Geospatial Mapping
Applications using location intelligence can take your information and transform it into
graphical and cartographic representations, simplifying your geographical data. At a glance,
judging which regions are performing better than others — and which ones need particular
attention — becomes much easier.
6. Operational Reports
At the end of each day, business intelligence features like these can provide your
organization’s executives with a detailed summary of the daily events, giving them the
information they need to make critical decisions.
7. Pivot Tables
Pivot tables can automatically extract significant features from a large, messy set of data.
They can perform calculations such as sorting, counting or averaging the data stored in one
table, and show the summarized results in another table. Pivot tables are essential tools for
analyzing information and uncovering hidden trends.
8. User-Specific Security
If you need to restrict certain users’ access to particular data sets, your BI tool should allow
you to personalize your BI features and applications to individuals or groups of users. Some
solutions provide user-specific data sources, where a single application pulls from different
sources of data depending on who’s using the application.
14
3
14
4

Oracle Apex ERP GUIDE Document

Uploaded by

Copyright:

Oracle Apex ERP GUIDE Document

Uploaded by

Document Information

Copyright

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Oracle Apex ERP GUIDE Document

Uploaded by

Copyright:

ERP GUIDE

Phone No. 0323-6683663 M Waqas ERP

Inventory Management System: ....................................................................................................... 57

Key System Strengths

Better customer service:

Improved Inventory Costs:

Boosted Cash Flow:

A brief description of the Features of the System is as follows:

Company Setup: Manage User:

In this tab we can define the data upload by excel formats.

1.3.1 System User Management:

An individual or (system) process working on behalf of an individual who has permission to

1.3.7 View Attachments

We can combine different groups of taxes apply on the time of transaction.

How to add Customer Receivable Opening

2.2.4 Employee Loans

2.2.6 Funds Receiving

2.3 Accounting Setup

 In Assert we can add other current asserts, fixed asserts.

2.3.4 Payment Terms

2.3.5 Accounting Period

In this tab we can define the department according to roles.

2.5.1 Accounts ledgers

Items Setup: Items Reports:

3.1 Item Setup:

We can create different types of barcode in it.

3.2.3 Transfer Order

We can see the how many challans are pending.

Vendor Define: Purchase Reports:

4.2.3 Purchase quotation

4.3.1 Purchase Order

A vendor return authorization is a non-posting transaction that keeps track of a return to a

4.5 Purchase Reports:

4.5.1 Purchase Order Summary

Sales: Receivable Reports:

5.2.1 Restaurant Point of Sale

Here we can add the order receive by the customers.

5.3.6 Customer Return

5.6.2 Customer Closing Report

7.2.2 Time Attendance Summary

7.2.3 Time Attendance Register

7.2.4 Employee Leave Application

7.2.5 Overtime Approval

7.2.6 HR & Payroll Dashboard

7.3.1 Payroll Define

7.3.2 Element Types

7.5.2 Employee Closing Balance

Here we can the employee closing balance.

You might also like