SELECTROW_NUMBER() OVER (PARTITION BY O.orders_id ORDER BY O.orders_id, OP.tktSPAmount DESC) [Rank], OP.orders_products_id ID,O.date_purchased [DocDate], O.usps_track_num2 [Formula Drive By], REPLACE(REPLACE(O.remarks, CHAR(13), ”), CHAR(10), ”) [Remarks], REPLACE(REPLACE(O.terms, CHAR(13), ”), CHAR(10), ”) [Sample Text], REPLACE(REPLACE(O.[days], CHAR(13), ”), CHAR(10), ”) [Boxcode], O.documentTextId DocumentId,OP.products_id ItemID, OP.tktSPAmount RequiredQuantity, hotelArrivalBy FilledQuantity, hotelDateTimeTo FilledOnFROM orders OLEFT JOIN orders_products OP ON O.orders_id = OP.orders_idWHERE […]
All posts by Irfan Anis
Why you haven’t been promoted
Posted by Glassdoor Team |5 min read Last Updated October 24, 2022 |5 min read You’ve been at your company for a few years. You get in early and stay late. You consistently get great feedback and have taken on more responsibility but still don’t have the promotion you want. At this point, progress may feel just out of […]
Branded SMS Packages
Branded SMS Setup Charges: Rs 8000 One Time BASIC BRANDED SMS @Rs 10000 / month includes 6000 SMSadditional SMS will be charged @ Rs 1.5 / smsPTA Approval may take 5 to 20 Days STARTUP BRANDED SMS @Rs 20000 / month includes 15000 SMSadditional SMS will be charged @ Rs 1.4 / smsPTA Approval time […]
World’s First E-Commerce Back Office Features
World’s First E-Commerce Back Office Solution -Used by Top E-Commerce Stores such as Scents N Secrets, Scent N Success, etc Most Loved Features: -Save tedious time amount of time and man power which results in BIG SAVING and efficiencies… -Integration with E-Commerce platforms such as Shopify, WordPress, WooCommerce etc. -Integration with Logistics Companies Such As […]
Shafi Printers: ERP Implementation Project Plan
InCharge: Latif ur Rahman Contact Person: anber bhai – 0300 3504212 Step Start Dt Days Est Dt Actual Dt Remarks Customers Step 1 payment 17-05-2022 1 18-05-2022 18-05-2022 done Step 2 KYC 20-05-2022 3 20-05-2022 20-05-2022 good Step 3 Basic Setup 20-05-2022 3 20-05-2022 23-05-2022 good Step 4 Your Data 20-05-2022 3 20-05-2022 26-05-2022 2 […]
Mubarak Traders : ERP Implementation Project Plan
008 InCharge: Latif ur Rahman Contact Person: Usama –> 0304- 2357844 Step Start Dt Days Est Dt Actual Dt Remarks Customers Step 1 payment 12-09-2022 1 13-09-2022 12-09-2022 good Step 2 KYC 12-09-2022 3 15-09-2022 13-09-2022 good Step 3 Basic Setup 12-09-2022 3 15-09-2022 12-09-2022 good Step 4 Your Data 14-09-2022 3 17-09-2022 15-09-2022 excellent […]
Zero tier for windows 7 or windows server 2012
windows 7 or windows server 2012 per 1.6.6 kay baad ka version supported nahi hay https://download.zerotier.com/RELEASES/1.6.6/dist/ZeroTier%20One.msi Irfan Anis
1st Read ME – Your ERP Implementation Project Plan
Step 1: Please made a payment as per agreement for One Time Software Cost and Monthly Support Agreement Payment Step 2 KYC: we need following details from customer – Expected Customer Response Time: 1 week Compulsory Items Company Name: Company Address: Contact Person / Point of Contact for Software: Cell: Email: Product List (Finish Goods, […]
WhatsApp Gateway Pricing
WhatsApp Packages: Breakthrough offer – now offering gateway api for WhatsApp messaging Basic Rs 1.2 / Message Basic Plus Rs 1 / Message Business Rs 0.8 / Message Business Plus Rs 2 / Message Enterprises Rs 1.4 / Message It rarely happens but if your WhatsApp number get blocked then there will be a onetime […]
SearchReview QTY CALCULATION
SearchReview 1) SearchReview FidAmount is calculated by its own method 2) Then we sum FidAmount molecule-wise for Molecule Total_FAmount 1) For Suggested quantity, difference is calculated with following formula total_diff = (1-([LabQty]/Total_FAmount))*100 2) [Sug_Total_Avg] = Total_FAmount * (1 – (AvgTotalDiff / 100)) AvgTotalDiff is average of difference of all difference percentages ranges between +-100 Irfan […]