Posts

Choosing Workshop Equipment by Starting with Operational Needs

A workshop equipment enquiry should begin with the work the equipment needs to support. Comparing products before understanding that requirement can leave a business with an attractive specification but an unsuitable solution. My background in procurement and application development has taught me to ask how a proposed purchase will be used in practice. Define the job before the product For equipment such as a tyre changer, wheel balancer or vehicle lift, the enquiry should describe the intended tasks and the vehicles or products involved. The supplier should confirm suitability against the exact model specifications. General product descriptions are useful for discovery, but they are not enough for a final decision. Consider the working environment Space, installation requirements, power arrangements, operator training and service support can affect whether equipment works well in the intended setting. These points should be reviewed with the responsible technical professionals. Procur...

Read more →

0

Working with Overseas Suppliers: Clear Communication from Enquiry to Delivery

International purchasing depends on conversations as much as documents. A brief enquiry can leave important assumptions unanswered, while a clear follow-up can prevent confusion later. Through my procurement experience in Qatar, I have learned to make supplier communication specific, traceable and useful to the people who must act on it. Ask questions that lead to clear answers An enquiry should identify the required product and specification, quantity and the information needed for evaluation. Ask suppliers to state their assumptions and clarify anything ambiguous. When comparing quotations, keep the basis consistent so that differences in scope are not mistaken for differences in value. Record what has actually been agreed A discussion is not complete until the relevant agreement is captured in a usable record. Confirm changes to quantities, specifications or readiness dates and connect them to the correct order. Teams should be able to tell the difference between a requested change, a …

Read more →
0

Planning Automotive Stock Across Multiple Branches in Qatar

A business with several branches needs more than a total stock figure. The important questions are where products are held, where demand is appearing and what can be transferred or replenished. Working with procurement and business systems has helped me understand why branch visibility matters to stock planning. Look beyond the company total An item can be available somewhere in the business while unavailable at the location serving a customer. Reports should therefore help users distinguish branch stock, warehouse stock and expected receipts. Available, reserved and in-transit quantities should have clear meanings, so that the same figure is not interpreted differently by different teams. Bring demand and lead time together Purchasing decisions benefit from both demand information and realistic supplier follow-up. Historical sales can provide context, but they do not guarantee future demand. Planned orders, unusual requirements and supply changes should be considered alongside the number…

Read more →
0

Why Accurate Tyre Specifications Matter in ERP

Two tyres may look similar in a catalogue while representing different stock items. In an ERP system, those differences need to be clear enough for purchasing, warehouse, sales and finance teams to use consistently. My work across procurement and ERP has reinforced a practical lesson: reliable processes begin with reliable product records. Build an item record people can recognise An item description should communicate the details needed to distinguish the product. For tyres, these can include brand, pattern, size, load index, speed rating and relevant vehicle-manufacturer markings. Product suitability should be confirmed against manufacturer information; an ERP description is a record, not a substitute for technical assessment. Avoid duplicates and unclear abbreviations Different spellings and inconsistent naming can make one product appear to be several items. A shared naming convention helps users search and compare records. Before creating an item, check whether an equivalent record e…

Read more →
0

From Purchase Order to Warehouse: Importing Automotive Products into Qatar

An imported product begins its journey long before it reaches a warehouse. The quality of the purchase requirement, supplier communication and shipment information can shape what happens at every later stage. Through procurement work in Qatar, I have learned to view purchasing as a connected process rather than a single transaction. Start with a clear requirement A useful purchase requirement identifies the product, specification, quantity and business need. For automotive products, similar descriptions can hide important differences. Confirming the exact item early helps procurement, sales and warehouse teams work with the same understanding. A quotation should be reviewed against that requirement rather than compared on price alone. Keep the order and shipment connected Once an order is agreed, supplier follow-up should track readiness, quantities and the information needed for shipment coordination. Changes should be recorded and shared with the teams affected. A delayed item, partial …

Read more →
0

Pirelli Tyres in Qatar: Connecting Global Expertise with Local Service

A tyre purchase brings together several decisions: the right specification for the vehicle, reliable product availability, professional fitting and ongoing maintenance. Behind those decisions sits another important process—connecting international tyre manufacturers with customers in the local market. Through my work in procurement and IT in Qatar, I see how product knowledge, supplier coordination and business systems contribute to this process. Pirelli and Altayeb Group in Qatar Pirelli provides tyre products for different vehicles and driving requirements. In Qatar, Tyres and Equipment Centre (TEC), part of Altayeb Group, is an authorised dealer of Pirelli tyres , as stated on Altayeb Group’s official website . This relationship connects an international tyre brand with local distribution and automotive services. Altayeb’s service centres offer tyre fitting, wheel alignment, balancing and puncture repairs. For customers, selecting a tyre is only one part of the experience. Access to suita…

Read more →
0

Connecting Procurement and ERP: Lessons from My Work in Qatar

Procurement involves much more than issuing a purchase order. It connects suppliers, stock planning, shipping, warehouse operations, finance and sales. When these teams work with clear processes and reliable information, purchasing decisions become easier to manage. In my role as Procurement & IT Manager at Tyres and Equipment Centre, part of Altayeb Group in Qatar, I work across both procurement operations and business systems. This combination helps me understand the operational problem before deciding how an ERP system should support it. Start with the business process Before configuring a system, I believe it is important to understand how people actually work. For a purchasing process, that means asking practical questions: What triggers a purchase requirement? How are stock availability and expected shipments checked? Who compares quotations and approves purchases? What information do warehouse and finance teams need? How are delayed shipments, partial deliveries and supplier issues …

Read more →
0

Tyres Purchase / Procurement Process in Qatar

These information are based on my experience working with Pirelli Tyres and Equipment Centre Qatar. Here we are importing different kind of brand like for tyres Pirelli , Federal , Deestone , Diamondback, Boto, Gripmax, Odyking, Tracmax, Doubleking, Nison, Hilo, Saferich, Onyx, Green Dragon, Wellplus, Doupro, Gold Dove, Gold Sheild etc for Tubes like Dongah Tubes, for Batteries like Koreana Batteries, For Lubricant like Mannol Oils, Total Oils, for the Automotive equipment like Corghi, Velyin, Borlan, Airmac. I'm trying to explain the full procurement process of tyres from overseas (USA, UK, Germany, Russia, Romania, Mexico, Brazil, Italy, Turkey, Thailand, Taiwan, and , China ) to Qatar.  1. Purchase Order 2. Open Letter of Credit (LC) with Qatar Bank 3. Book Shipments if Purchase order is FOB . When booking a shipment always ask your agent to give minimum 14 days of free line demmurage charges so you can avoid any extra charges in case of your goods stuck at port for some time du…

Read more →
0

Search entire SQL Server database and all tables for a specified string

-- ============================================= -- Author:        <Jainul Khan> -- Create date: <11-12-2014> -- Description: < Search entire SQL Server database and all tables for a specified string > -- ============================================= -- [dbo].[sp_SearchFromAllTables] 'Entered' CREATE PROCEDURE sp_SearchFromAllTables ( @SearchStr nvarchar ( 100 ) ) AS BEGIN DECLARE @Results TABLE ( ColumnName nvarchar ( 370 ), ColumnValue nvarchar ( 3630 )) SET NOCOUNT ON DECLARE @TableName nvarchar ( 256 ), @ColumnName nvarchar ( 128 ), @SearchStr2 nvarchar ( 110 ) SET   @TableName = '' SET @SearchStr2 = QUOTENAME ( '%' + @SearchStr + '%' , '''' ) WHILE @TableName IS NOT NULL BEGIN SET @ColumnName = '' SET @TableName = ( SELECT MIN ( QUOTENAME ( TABLE_SCHEMA ) + '.' + QUOTENAME ( TABLE_NAME )) FROM INFORMATION_SCHEMA . TABLES WHERE        TABLE_TYPE = 'BASE TABLE' AND QUOTENAME ( TABLE_SCHEMA ) + '.' + QUOTENAME ( TABLE_NAME ) > @TableName AND OBJECTPROPERTY ( OBJECT_ID (

Read more →
0

Extended Date Formats in SQL Server

Here are some more date formats that does not come standard in SQL Server as part of the  CONVERT  function. Extended Date Formats Date Format SQL Statement Sample Output YY-MM-DD SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 8) AS [YY-MM-DD] SELECT REPLACE(CONVERT(VARCHAR(8), GETDATE(), 11), '/', '-') AS [YY-MM-DD] 99-01-24 YYYY-MM-DD SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD] SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD] 1999-01-24 MM/YY SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY] SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY] 08/99 MM/YYYY SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY] 12/2005 YY/MM SELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM] 99/08 YYYY/MM SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]

Read more →
0