? 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) ? More About BattleshipCobra http://battleshipcobra.com/ ? Support These Videos http://donate.battleshipcobra.com/ ... https://www.youtube.com/watch?v=9a_etz9wPgQ

? Video Description I have a full course on working from home tips. This video is a reflection on that course and adds more tips and tricks I've learned. ? Chapters 00:00 - Introduction 00:26 - SQL Backups 04:27 - Test Database Restore 09:26 - Setup for Test Databases 12:11 - Bonus Performance Tips 14:53 - 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) ? More About BattleshipCobra http://battleshipcobra.com/ ? Support These Videos http://donate.battleshipcobra.com/ ... https://www.youtube.com/watch?v=_gPHgJXXoRA

? Subscribe to the Podcast Available on all platforms: http://podcast.battleshipcobra.com/ ? Quotes "I believe a man is a professional when he can do what needs to be done no matter how he feels within. An amateur is an amateur in his attitude emotionally. A professional is a professional in the way he thinks and feels and in his ability to execute under the most trying conditions." ~ Cus D'Amato ? Topics: - Why I was away from YouTube - It's time for... The Rant of the Day Troubleshooting printers - Boutique vs. Volume - Systemize and monetize - Process Design = Compliance "The right amount of complexity is whatever creates optimal simplicity." ~ David Allen ? 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) ? More About BattleshipCobra http://battleshipcobra.com/ ? Support These Videos http://donate.battleshipcobra.com/ ... https://www.youtube.com/watch?v=QYKLanbp3ok

A quick video on how to get out and find your passion in life. Spoiler alert, you actually have to get out and do stuff. The more stuff you do the more of a roadmap you will have. Enjoy! Check out my Onnit Affiiliate link (10% OFF!): https://www.onnit.com/?a_aid=SCORPIO Referral Code: SCORPIO ... https://www.youtube.com/watch?v=Y8kMLJlGcuQ