![Down Arrow](../../images/downarow.gif)
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
![Gray Arrow](../../images/grayarow.gif)
Supplier Information
![Gray Arrow](../../images/grayarow.gif)
Currency Information
![Gray Arrow](../../images/grayarow.gif)
Part Information
Transactions
![Gray Arrow](../../images/grayarow.gif)
Supplier Purchase Orders
![Gray Arrow](../../images/grayarow.gif)
Supplier Purchase Invoices
![Gray Arrow](../../images/grayarow.gif)
Purchase Orders & Invoices Matching
Queries
![Gray Arrow](../../images/grayarow.gif)
Supplier Order Status - Parts Wise - All
![Gray Arrow](../../images/grayarow.gif)
Supplier Order Status - Parts Wise - Not / Partly / Fully Closed
![Gray Arrow](../../images/grayarow.gif)
Supplier Order Status - Supplier Wise - All
![Gray Arrow](../../images/grayarow.gif)
Supplier Order Status - Supplier Wise - Not / Partly / Fully Closed
Queries - Orders & Invoices
![Gray Arrow](../../images/grayarow.gif)
Supplier Orders Matched Against Invoices
Software Features
![Gray Arrow](../../images/grayarow.gif)
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.
![Gray Arrow](../../images/grayarow.gif)
Simple Logical Solution to easily move to the next stage beyond spreadsheet based Ordering & Invoicing for multiple users in multiple locations.
![Gray Arrow](../../images/grayarow.gif)
Both Intranet (Internally Hosted) and Internet (Externally Hosted) Options are possible.
![Gray Arrow](../../images/grayarow.gif)
Multiple Supplier Purchase Orders can be linked to Multiple Supplier Invoices.
![Gray Arrow](../../images/grayarow.gif)
Flexible Hosting & Deployment Cost Options available.
![Gray Arrow](../../images/grayarow.gif)
Scalable Solution for Long Term Global Requirements.
![Gray Arrow](../../images/grayarow.gif)
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
![Gray Arrow](../../images/grayarow.gif)
Supplier Information - Create Supplier Code & Name
![Gray Arrow](../../images/grayarow.gif)
Currency Information - Create Currency Code & Name
![Gray Arrow](../../images/grayarow.gif)
Part Information - Create Part Code, Part Name & Part Specifications
Transactions - Purchase Orders
![Gray Arrow](../../images/grayarow.gif)
Create Supplier Purchase Order for A Supplier for Some Parts
![Gray Arrow](../../images/grayarow.gif)
View 'Not Closed' Part Status & 'Not Closed' Order Status
![Gray Arrow](../../images/grayarow.gif)
View Parts - Part Value & Pending Value
![Gray Arrow](../../images/grayarow.gif)
View Purchase Orders - Total Value & Pending Value
![Gray Arrow](../../images/grayarow.gif)
View Queries pertaining to above Purchase Order
Transactions - Purchase Invoices
![Gray Arrow](../../images/grayarow.gif)
Create Supplier Purchase Invoice for the Same Supplier & Same Parts (Some or All Parts)
![Gray Arrow](../../images/grayarow.gif)
View 'Not Matched' Part Status & 'Not Matched' Order Status
![Gray Arrow](../../images/grayarow.gif)
View Parts - Part Value & Unmatched Value.
![Gray Arrow](../../images/grayarow.gif)
View Purchase Invoices - Total Value & Unmatched Value.
![Gray Arrow](../../images/grayarow.gif)
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.
![Gray Arrow](../../images/grayarow.gif)
Query - Supplier Orders Matched Against Invoices
![Gray Arrow](../../images/grayarow.gif)
For more information on the above, kindly
contact us appropriately.