
Web Based Purchase Ordering Software Using Oracle Cloud Application Express (Apex) Platform
You can click on the image to enlarge the same.
Supplier Purchase Systems Help In
.....
Cutting Costs &
Satisfying Stakeholders.
Internet Web Based Purchase Ordering & Invoicing System
For one of our Global Japanese Multinational Trading Customers, Kaytek created an Internet Web Based Based Supplier Purchase Ordering & Invoicing System on the
ORACLE APEX - Application Express - PAAS (Platform As a Service) - Cloud Computing platform.
This organization is currently maintaining their Ordering & Invoicing Information using spreadsheets and were finding it difficult to match multiple orders to multiple invoices.
Their requirement was for a simple software solution preferably accessible via the Internet that could help them replace their current spreadsheets.
Software Modules
The current software demonstration version has the following modules :
Masters

Supplier Information

Currency Information

Part Information
Transactions

Supplier Purchase Orders

Supplier Purchase Invoices

Purchase Orders & Invoices Matching
Queries

Supplier Order Status - Parts Wise - All

Supplier Order Status - Parts Wise - Not / Partly / Fully Closed

Supplier Order Status - Supplier Wise - All

Supplier Order Status - Supplier Wise - Not / Partly / Fully Closed
Queries - Orders & Invoices

Supplier Orders Matched Against Invoices
Software Features

Developed using
ORACLE APPLICATION EXPRESS (APEX) Web Development Tool with a rich Browser based Graphical User Interface (GUI) and a strong secure data storage foundation of
ORACLE RDBMS Software. Oracle APEX is an example of Platform As A Service - PAAS Model of Cloud Computing.

Simple Logical Solution to easily move to the next stage beyond spreadsheet based Ordering & Invoicing for multiple users in multiple locations.

Both Intranet (Internally Hosted) and Internet (Externally Hosted) Options are possible.

Multiple Supplier Purchase Orders can be linked to Multiple Supplier Invoices.

Flexible Hosting & Deployment Cost Options available.

Scalable Solution for Long Term Global Requirements.

Customized Business & Technical Support Options Available.
Proposed Transaction / Workflow
The Proposed Transaction Flow that is visualized in the usage of the above software is as follows :
Masters

Supplier Information - Create Supplier Code & Name

Currency Information - Create Currency Code & Name

Part Information - Create Part Code, Part Name & Part Specifications
Transactions - Purchase Orders

Create Supplier Purchase Order for A Supplier for Some Parts

View 'Not Closed' Part Status & 'Not Closed' Order Status

View Parts - Part Value & Pending Value

View Purchase Orders - Total Value & Pending Value

View Queries pertaining to above Purchase Order
Transactions - Purchase Invoices

Create Supplier Purchase Invoice for the Same Supplier & Same Parts (Some or All Parts)

View 'Not Matched' Part Status & 'Not Matched' Order Status

View Parts - Part Value & Unmatched Value.

View Purchase Invoices - Total Value & Unmatched Value.

Match the invoiced parts & corresponding quantities entered in the
above Purchase Invoices to the Created Purchase for some parts and quantities.
At any /
every stage of matching, to check the Purchase Order Status & Purchase Invoice Status as shown above.

Query - Supplier Orders Matched Against Invoices

For more information on the above, kindly
contact us appropriately.