Using Oracle Apex Cloud Computing Technology
Supplier Purchase Systems Help In
.....Cutting Costs &
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.
The current software demonstration version has the following modules :
Supplier Purchase Orders
Supplier Purchase Invoices
Purchase Orders & Invoices Matching
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
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 :
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.