Inventory Management
Purchasing Module:
- Ability to maintain different locations (Stores, Outlets, Damage Store etc).
- User defined stock re-order levels and quantities:
When re-order level is received, the system prompts for automatic raising of purchase listing.
- Stock item image viewing facility from master file:
All stock items can be scanned and saved and the image can be viewed from the stock master file.
- Purchase Order and supplier monitoring:
When GRNs are raised, if the PO number is given, the items and quantities of the POs are automatically displayed. The quantities can be changed according to the user’s needs.
- Previous pricing information can be viewed for a supplier when entering a PO.
- GRN Returns are interrelated with the GRN. Stocks are reversed accordingly from the location and given provisions to receive stock from POs.
- Automatic calculation of user defined taxes.
- View a particular item's status at any given time:
e.g. Items on hand by location and total quantity.
- Creation of master data within transaction levels.
- Tracks transaction history.
- Facility of searching items by code, description and price.
- Matches PO with related source documents such as Purchase Invoice, Goods Receipt Note and Purchase Returns.
- Validates items and quantities from POs:
All item quantities and item codes are validated from the POs, when GRNs are raised.
- Weighted average costing of stocks:
The GRN automatically calculates & updates the stock master file with the correct weighted average.
- Real time updating of stock quantities:
Stock quantities are updated according to the transaction types from their correct location.
- Quotation for stocks:
Quotations can be raised before actual invoicing takes place.
- Facilitates multiple modes of payment:
Invoice settlements can be done by cash, cheque or credit card.
- Temporary enhancement of credit levels with password approval.
- When invoicing, the system gives warning of negative stock balances.
- Back orders:
If sufficient stocks are not available, system keeps the balance required stock in a back order, facilitating the generation of an invoice when stocks are available.
- Item transfers between locations.
- Van Sales for tours:
This section has a series of transactions like loading, van sales, van sales returns and unloading; to complete a journey cycle done by a sales rep.
- Physical stock reconciliation:
Stock on hand is derived by summing up the transactions for a particular item.
- Damage stock maintenance and tracking:
Damage stock movements and balances can be monitored by storing them in separate locations.
- Identifies sales of individual locations and of the whole company.
- Tracks sales by salesperson:
A report is given to indicate all sales made for a user defined period, including returns for a particular sales person.
- Generates POs with comprehensive information such as date, item, quantity, date of delivery and store
- PO amendments.
- POs with Manual or Auto Numbering Systems.
- Ability to handle partial GRNs in respective POs.
- Multiple Price Levels:
The item master file has several levels of selling prices and each customer is tied-up to a selling pricing level. When invoicing, the selling price is picked up from this level.
- Prevents alteration of cost and selling prices.
- Generates invoices with comprehensive information such as date, item, party, sales rep, quantity, due date for delivery, store etc.
- Invoices are generated along with Automatic or Manual Numbering Systems.
- Ability store customer information for special promotions.
- Ability to generate different sequence no’s for different types of invoices (e.g. . Cash, Credit sales).
- Assigning sales targets for different levels (e.g. Sales rep, Location etc.). Obtaining reports based on target achievements and variance.
- Discount facility (percentage or value):
each item can be assigned a discount, either a percentage of the total or a stipulated value.
- Sales returns controlled with invoice amounts:
when a sales return is raised the items & the quantities are validated against the invoice. All items in the sales return should comply with the items in the relevant invoice. There can be multiple sales returns for an invoice.
- The following transactions are in the system:
* Purchase Order
* GRN
* GRN Returns
* Transfers
* Adjustments
* Free Issues
* Sample Issues
* Stock Opening Balance Entry
* Physical Stock Entry
* Damage Stock Transfer
* Quotation
* Invoice
* Invoice Return
REPORTS
Stock reports
- . Purchase Orders Register with outstanding purchase orders
- . Goods Receipt Note Register with relevant master information
- . Goods Receipt Note Register
- . Reorder Level List
- . Stock Transfer Note Register
- . Store Register (stores information- summary and detail)
- . Type / Category Register (item- summary and detail)
- . Stock Age Analysis
- . Stock Ledger
- . Item Register (item summary and in detail)
- . Bin Card Statement.
Sales Reports
· Sales Invoice Register
· Sales Returns Register
· Daily Sales - Item Wise
· Daily Sales - Invoice Wise
· Cash sales
· Credit sales
· Contribution Report - item wise
· Contribution – product group wise
· Contribution - customer wise
· Contribution - location wise
· Sales analysis report – yearly
· Price change effective report
· Sales target achievement report
· Daily collection summary report
· Price List
· Sales Tax Reports (VAT)