|
  Using Oracle Apex Cloud Computing Technology 
Kaytek Business / IT Services
|
Consulting
Accounting
Suppliers
|
Using Oracle Apex Cloud Computing Technology
Kaytek Business / IT Services
|
|
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. |
|
|
|
|
|
|
|
|