Procurement Purchasing
Main Features
- Monitoring of Spares, Provisions and Stores from within the same application.
- Monitoring of all stages involved in the Purchasing Cycle, Requisition, Quotations, Orders, Deliveries, Invoices, Budget.
- Historical view of item prices. During the entry of a new Order the user has the ability to view the purchasing history of a specific item. More specifically, the user can view how many times in the past this item was purchased by a specific vessel, who were the suppliers and at what price this item was purchased for.
- Option to use existing spares libraries and the ISSA 91 (25,000 items) or ISSA 94 (33,000 items) catalogues or IMPA catalogue.
- Customized Preview and Report form.
- Requisition Version software on board.
- Automatic entry of Requisition to Purchasing software from vessel via Excel file.
- Archiving of Correspondence (Integration with Microsoft Outlook). This applies to cases where the user of the Purchasing application also uses Microsoft Outlook for their e-mail correspondence with the suppliers. In such cases the entire e-mail correspondence (both incoming and outgoing) regarding a Requisition is archived by the application so that is readily accessible by the user when the need arises.
- Advanced Search Mechanism for Requisitions, Quotations and Orders based on user, vessel, items category or a combination o these criteria.
- Track Vessel Inventory and spare or supply items.
- Pending Items View. The application provides a view of items that have not yet been delivered to the vessel (s). These items remain “pending” until the user adds them to a new Requisition.
- Budget Monitoring by vessel and account. The application allows for the definition of a budget amount for every vessel and expenses category. The user can monitor, at any given moment, the running balance and the level of expenditure for every expenses category.
Control Budget per vessel supplier and account. - Lower Priced Item. Through the “Quotation Comparison” procedure the user can identify lower priced items and lower priced overall supplier quotations.
- Items Search Mechanism. Ability to search for specific items by item code or description.
- Split Order. Ability to choose up to six (6) suppliers for a single order.
- Supplement files like suppliers, shipchandlers, agents etc.
- Automatic send of Requisition, Order using Symantec WinFax, Microsoft Outlook, Strategic Message Manager, Leagore TELIX software.
- Security of the system having username and password in different levels. Recording of actions performed by users in log files.
- Currency Maintenance. Online update via the internet of selected currencies exchange rates.
- Quick Inventory of past items.
- Tens of different reports that can cover any need.
- Specifically designed to minimize user’s entry time.
- Planned future integration with a “Planned Maintenance System” module.
- Planned future function for the automatic update of a vessels inventory via e-mail sent by the vessel during the stage of delivery.
Security
Ability to define different levels of Access Rights for different users (use of usernames and passwords). The level of Access Rights determine the parts of the application a user can use or view. In addition to this all user activities are recorded in specifically assigned log files.
On board the Vessel
“Vessel Requisition” is an extension of the Purchasing application and is installed aboard the vessel. The user creates Requisitions and forwards them (as e-mail attachments) to the central offices. This is all done with a few clicks of the mouse button. Upon reaching its destination via e-mail, the attached Vessel Requisition can be automatically imported to the main Purchasing application where it can be further processed.
Suppliers Quotation Automation
Ability to send a Requisition in Excel format to suppliers who in turn can send it back having filled in their prices. This Excel file can be automatically imported in the application gaining time and effort.
Reporting
- Requisition Form for dispatch to supplier.
- Quotation Comparison Report for price control and comparison of up to 6 suppliers.
- Quotation Comparison Budget Report.
- View of Supplier Quotations together with the budget amount allocated to each expense category, its current balance and remaining amount available for consumption.
- Order Form for the dispatch of order items to approved supplier(s)
- Forwarding Instructions Form.
- Supplies Pending Items Report per Vessel.
- Spares Pending Items Report per Vessel.
- Invoices Reports by Vessel, Date, Supplier.
- Invoices Expenses Reports for the monitoring of expenses for different invoice categories such as Insurance, Freight, etc.
- Pivot Report Table. Two-way expenses presentation of vessels, specific time periods and expenses categories. Pivot Report Chart. Two-way expenses presentation of vessels, specific time periods and expenses category.
- Pivot Budget Report Chart. Chart View of allocated budgets and their running balance for each expenses category.
- Supplies – Spares Report. View of all orders per vessel and items category based on date and including details such as local currencies or ports
video preview
CONTACT US
Application Highlights: Reduce Vessel Expenses by at least 30%
On board the vessel
We built a special app on top of Excel. No need for servers on board. No need for extensive crew training. Everyone knows how to operate an Excel. It can be used for both Spares and Provisions/Stores. It also includes IMPA Ver.6. The setup is so small, it can be send via email to the vessels. The excel is imported to the Purchasing application saving typing time
In the office | Requisition (step 1 of 4)
Simple to use forms, with multiple automations to make users daily tasks easy.
In the office | Requisition Items (step 1 of 4)
Every single item is linked with a category/dept./cost center which is your Accnt. Dept. Chart of Account Code.
In the office | Quotation (step 2 of 4)
Up to eight (8) Suppliers’ quotations per item. Follow up status on every step of the process.
In the office | Quotation Items – Supplier View (step 2 of 4)
Each supplier is displayed on his own Tab with detailed information like local currency/USD, even separate item discounts. Separate Quantities: what was requested, what was approved. Each item has also its own free text remarks box.
In the office | Quotation Items – Comparison View (step 2 of 4)
Quick comparison of Suppliers offers per item. You can manually or automatically create a “split order” from this form.
In the office | Quotation Items – Automating data entry (step 2 of 4)
A simple Excel is sent to the Supplier that can be later imported into the quotation, saving user’s time manually entering the information. The Excel is locked and allows only editing on the blue cells.
In the office | Quotation Comparison report + last ordered item (step 2 of 4)
Compare multiple suppliers on a single Excel.
As long as an item has part no/code then the software will automatically show the last ordered time on the same report.
In the office | Order i (step 3 of 4)
Quick Order your items using this form. Being able to edit items descriptions, quantities, remarks etc.
This is the form where you can also automatically create an invoice for an order.
In the office | Order ii (step 3 of 4)
Even if you don’t use Outlook for your email system, we suggest using it locally just for automating the process of sending an email to the supplier. Saving time for your users. The outgoing email is not lost, its auto Bcc to the company’s email address as well.
In the office | Delivery (step 4 of 4)
Manage Ordered vs Delivered items.
Quick View i
Search from thousands of cases using multiple criteria: Category: Lubricants, Port: Singapore, for a specific Vessel
Quick View ii
View all cases per vessel from within a single form
Invoices
Full cycle of controlling Invoices
Reports
Tens of Reports to control your Expenses
Create Consolidated Excel Reports
Quick Inventory
Quick search for Ordered Pistons in Singapore for a specific vessel
Exchange Rates
Automatic update from Internet, manually by the user or automatic from your server
Link with your Accounting System
Chart of Accounts
Budgeting
Set budget amounts for your expense categories and monitor them before approvals
Management of Suppliers, Agents and other lists
Automatic Weekly email to office with current status of cases
Have the whole office informed by emails. Separate emails for Spares and Stores.
(Works with any email management system)
Hit the Road – Work Offline
Press a button to copy/load all Purchasing data to a laptop.
A designated person can visit the vessel and perform inventory audits.
CONTACT US
OTHER PRODUCTS
The problem
You have an Excel that you want to import to your database and the data in your Excel form are not normalized. The Excel sheet may contain names of cities, countries, products etc. which are repeated. To import the data into your database you have to manually restructure the data to a relational database in order to reduce data redundancy and improve data integrity.
The solution
We created an application called ‘Transform Excel to SQL’. Transform Excel to SQL takes the data from the columns of the Excel sheet, normalizes them and creates SQL Server tables out of them. The end result is a structured and normalized SQL Database. You save time using this software instead of writing custom code.
Who needs this application
Data workers bridging data between departments and different modules of an existing software.
Managers can use this app to transform raw data to meaningful reports using reports designers like SQL Server or MsAccess or Sharepoint.
Marketing department can grab data from a web page, paste to an Excel sheet and load to a database for further process.
Developers can use this Add-In to migrate data from any legacy software.
