? Video Description These are my best practice tips and tricks for writing the best macros possible for SAP Business One and B1 Usability Package Universal Functions. Features a Penny Oleksiak puppet that I cut out from a Cherrios box to entertain my kids. ? List of Best Practices 1. Titles - I name my B1 Validation and Universal Functions like: ORDR: Name of Function (Sales Orders), OXXX: Name of Function (any document), MENU: Name of Function (menu item), etc. Give your functions meaningful names, makes it quick to identify where the function is being used. (You can also use the Universal Function \\ Right-Click \\ Where is this UF used?) 2. Comment / Document Your Code - Especially if you do lots of macros you won't remember the item IDs or the specific functions of all your lines of code. It's a really important best practice to write comments above or after your lines of code. 3. Use Categories - Once you categorize your B1 Validations, Universal Functions, Function Buttons, Item Placements, etc. it makes it easier to keep them together, export them and manage your various systems. Go to a category and push "Overview" to see all things related to your functions. 4. Use Effective Dynamic Syntax - See my previous video (https://youtu.be/JDir4Ogqfvg) on Dynamic Syntax (shortcuts and C# snippets). I don't want to see stores pulling OCRD columns from documents for example, use row references .FOCUSED, etc. Name your IPT fields so they are the same across documents. Just type over the auto-generated code in the IPT. 5. Combine Functions Per Trigger - You can supposedly layer over multiple B1 Validations and then use the "Sort" number to indicate which one is supposed to be run first. But it's easier to just load a single macro and do your evaluations all at once. I don't want to see four B1 Validations running on the same field! 6. One Function for All Form Types - Don't make a B1 Validation per document, just run the same validation on all documents and filter in the macro to run the right code. Especially if the code is 90% the same. View my Dynamic Syntax tips & tricks video for more details on how to filter for the form type. Add a ";" semicolon to use multiple form types on one validation. 7. Freeze(); / UnFreeze(); - This is so essential. You need to freeze the screen so you don't see each movement of the mouse. Each time you activate a new form you need to use Freeze(); and then UnFreeze(); at the end. 8. Watch Form Modes - Make sure you match your functions and item placements to the right form modes. If there is no reason to run your functions in "Add" mode then don't have them set to run. It your item placements shouldn't be active in certain modes disable them. Don't use "All" for all your B1 Validation setup ... https://www.youtube.com/watch?v=K113_C2qpZE

? Video Description Learn what you can and can't UPDATE directly using SQL / HANA SQL for SAP Business One. These are my guidelines from my experience as to what's safe to UPDATE / INSERT / DELETE, what should be avoided and other methods of updating system fields. ? Chapters 00:00 - Fountain of Youth 00:49 - Introduction 02:41 - Limited System Field Updates 05:29 - User-Defined Objects 07:43 - SQL Example DELETE / INSERT 09:03 - UDFs for Updating 09:40 - PostTransactionNotification 11:43 - Alternative Ways to Update System Fields 13:15 - 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=TDFrBq56Jpg

? Video Description This is my solution to the Address Line 1, Address Line 2 issue in SAP Business One. Fix your address layout with the "Address Format" and "Crystal Reports" formula side fix in your layouts. ? Video Examples // Bill To Code REPLACE({ORDR.Address}, ChrW(13)+ChrW(13), ChrW(13)) // Ship To Code IF {ORDR.Address} = {ORDR.Address2} THEN "Same as Billing Address" ELSE REPLACE({ORDR.Address2}, ChrW(13)+ChrW(13), ChrW(13)) ? Chapters 00:00 - Introduction 01:17 - Address Setup 05:24 - Crystal Reports Setup 09:12 - 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=1Mw8d_6bGsk

? Video Description Have you ever been making a Crystal Report for SAP Business One and you added a table and it duplicated your invoice rows? This video shows you why you get duplicate rows and two fixes for making a single row per invoice. ? Chapters 00:00 - Introduction 00:16 - Describing the Scenario 08:23 - Solution #1: Crystal Reports Grouping 16:12 - Solution #2: SQL Grouping in Command 23:22 - 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/ ... https://www.youtube.com/watch?v=44o9Hbvcqnw