Posts

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 num...

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