software in a hosting system completely fulfills the needs that most pharmaceutical wholesale companies have as users. As an added benefit of this construction, the user can make use of PharmaLog as a service, and they need not invest in their own IT infrastructure, meaning that they only have to procure the client terminals operating in their own warehouse or office (computers, Windows operating system, printers, scanner). The remaining IT infrastructure will be ensured by us: server-side hardware and software, security tools as well as a system administrator along with continuous services. PharmaLog runs in the Magic environment, under the HP Unix operating system and on Windows clients. Terminal emulation technology makes quick response times possible while not requiring high bandwidth because of low network traffic. PharmaLog
Order taking – customer system connections
Order taking via telephone – computer-aided queuing and calls. Assisting the work of the dispatcher by offering product substitutions in case of product shortages.
The system – in case the dispatcher is busy – supports the introduction of calls received by the operator into the system.
When taking customer orders, the system displays the value of the order as well as a warning if the customer orders fewer discounted items than the quantity needed for the discount. It is possible to use discount forms to speed up order taking.
Order processing – picking
Picking note preparation, printing and verification can be done separately for each warehouse and processed as a batch as well.
Picking note preparation and printing can be separated even within a given warehouse (support for box picking).
Verification of picking notes by picking unit is supported.
The picking note includes the date, the pick-up time, the round trip schedule and the departure time.
Delivery managed at an item and/or package level
Preparing a bill of delivery
Sending a test certificate to customers who require it, on paper or as an email
Preparing an invoice, invoicing on a trip-by-trip basis
Reverse invoice and corrected invoice preparation
Keeping a record of packages for each customer and a cumulative record for packages
Warehouse – stock records
Support for various warehouse technologies, with fixed and free storage space allocation
Management – procurement
The main screen of the module shows the format of the storage sheet. Some fields can be “looked behind” – the following data is available for each product retrospectively for 5 years:
Supplier orders and other related data: monthly depletion, safety stock multiplier, stock, quarantine
Supplier confirmation data
Supplier behavior analysis – statistics
Received goods data: from whom, when, how much and at what price
Data on goods delivered, returns and reverse invoices: when, what sales direction, to whom, how much, at what price.
There are various statistics that connect to this module:
Customer analysis: it shows the number, pattern, composition and value of orders and returns by each customer and customer type
Product analytics: the time and quantity of all movements of the product are shown according to nature of product, product group and individual products
Storage unit statistics: movements are shown according to storage unit, product, customer, time (to the minute) and quantity
Product shortage statistics
In order to speed up product reception, packages divided (according to batch number and expiration date) can be entered into stock, or, in case of a quality or price error, it is put in to the “QUARANTINE” file, where it can be moved to stock using the “Release” program
The items entered can be directed either to the order-picking area, the pre-packaging area or the background warehouse, according to their governing parameters
The order of reception for the products can be freely chosen – so an “important” product (it is either in short supply or expected) can precede others in being entered into stock
Financial invoicing – discounts
The user can compile several orders onto one invoice, or can invoice an order by warehouse Direct invoicing is also possible
It is possible to make out an invoice using several types of prices (producer, purchaser, wholesaler)
Discounts can be given for:
Types of orders
Customer / product groups
Types of customers, select customers, payment methods by item or groups of items
When invoicing, for each row
Forint, lei rebate, Discounts can be extended for:
Aside from registering and pairing supplier invoices and distributing costs, we also get a clear picture about the state and content of each certificate. The module also contains supplier VAT reports and margin calculations
At the end of the day, the logistics system transfers the costumer and supplier invoices and other certificates to the given financial-accounting system
Customized interfaces for different financial systems.
An overview of the complete inventory process is available via a controller screen; the state and content of each inventory sheet can be viewed. Inventory lists can be viewed and printed with the same program
The system supports inventory by warehouse as well as by section
A so-called continuous inventory is possible, which means a daily check of certain – randomly selected – products and the accounting and quantitative management of the differences
Manager information – statistics
Purchases by customer
Supplier – customer price margin report
Warehouse turnover report
Product group balance sheet
General ledger registration
Product group report by movement type
Monthly product group sale
Monthly cumulative invoice
Delivery by customer type
Stock changes by manufacturer and supplier
Shortage product analysis
Ministry statistics, reports by manufacturer and supplier
Other reports and lists pertaining to wholesale
Master list maintenance – price change management
Master files (customer master file, bank master file, code dictionary etc.) maintenance is centralized
With the programs of the system module connected to managing price changes, price adjustments to items can be recorded (maintained) before they come into effect. Data can be entered by classic recording and by monitoring the degressive margin.
The system stores all prices both prospectively and retrospectively, and in each case where the date of the order fulfillment is not “today” (preliminary invoice, reverse invoice, returns, etc.), the program recalculates the stock value of the items and registers it with the general ledger
Daily closing, monthly closing
This system module accumulates data pertaining to turnover, individual customers, purchase records and statistics, it processes in full the data recorded during the day/month, and it prepares the daily/monthly files for the following day/month. Daily statistics, product shortage analysis, item turnover reports and data transfer to the financial system are done during the daily closing. Lists and .csv files are created about turnover data and stock as well as for each customer and item during the monthly closing