Simple Price List Updates (No DTW) - SAP Business One: Tips & Tricks скачать в хорошем качестве

Simple Price List Updates (No DTW) - SAP Business One: Tips & Tricks

🎦 Video Description Do you want to update your price lists quickly without the use of the DTW? This video shows you how to export your price list information to Excel and then format it and upload it through the SAP Business One client directly from your workstation even without server access. 💾 Price List Queries -- SQL SELECT T0.[PriceList] AS 'Price List No.' ,T0.[ItemCode] AS 'Item No.' ,T1.[BASE_NUM] AS 'Item No, Base Price List No.' ,T1.[Factor] AS 'Item No, Factor' ,CASE T0.[Price] WHEN 0 THEN '' ELSE CAST(T0.[Price] AS VARCHAR) END AS 'Item No, List Price' ,T0.[Currency] AS 'Item No, Currency for List Price' ,CASE T0.[AddPrice1] WHEN 0 THEN '' ELSE CAST(T0.[AddPrice1] AS VARCHAR) END AS 'Item No, Additional Price (1)' ,T0.[Currency1] AS 'Item No, Currency for Add. Price 1' ,CASE T0.[AddPrice2] WHEN 0 THEN '' ELSE CAST(T0.[AddPrice2] AS VARCHAR) END AS 'Item No, Additional Price (2)' ,T0.[Currency2] AS 'Item No, Currency for Add. Price 2' FROM ITM1 T0 INNER JOIN OPLN T1 ON T0.[PriceList] = T1.[ListNum] WHERE T1.[ListName] = '[%0]' ORDER BY T1.[ListName], T0.[ItemCode] -- HANA SELECT T0."PriceList" AS "Price List No." ,T0."ItemCode" AS "Item No." ,T1."BASE_NUM" AS "Item No, Base Price List No." ,T1."Factor" AS "Item No, Factor" ,CASE T0."Price" WHEN 0 THEN '' ELSE CAST(T0."Price" AS VARCHAR) END AS "Item No, List Price" ,T0."Currency" AS "Item No, Currency for List Price" ,CASE T0."AddPrice1" WHEN 0 THEN '' ELSE CAST(T0."AddPrice1" AS VARCHAR) END AS "Item No, Additional Price (1)" ,T0."Currency1" AS "Item No, Currency for Add. Price 1" ,CASE T0."AddPrice2" WHEN 0 THEN '' ELSE CAST(T0."AddPrice2" AS VARCHAR) END AS "Item No, Additional Price (2)" ,T0."Currency2" AS "Item No, Currency for Add. Price 2" FROM ITM1 T0 INNER JOIN OPLN T1 ON T0."PriceList" = T1."ListNum" WHERE T1."ListName" = '[%0]' ORDER BY T1."ListName", T0."ItemCode" 📚 Chapters 00:00 - Pilot Introduction 00:45 - Scenario Description 02:00 - Price List Import Overview 03:55 - Extract to Excel 04:29 - Editing Prices 07:50 - Creating Import File 08:49 - Import from File 10:20 - Pilot Outro 💼 Working Remotely: Efficiently and Effectively Free Course ☕ http://remote.battleshipcobra.com (Free) 🧮 SQL FOR SAP BUSINESS ONE COURSE NOW AVAILABLE 📈 http://sql.battleshipcobra.com (50% off) 📊 CRYSTAL REPORTS FOR SAP BUSINESS ONE COURSE 💎 http://crystal.battleshipcobra.com (50% off) 🎉ADVERTISE IN MY VIDEOS 🎊 http://advertise.battleshipcobra.com 😎 More About BattleshipCobra http://battleshipcobra.com/ 💸 Support These Videos http://donate.battleshipcobra.com/