Skip to content
  • HOME
  • YOUTUBE
  • UDEMY
    • Crystal Reports for SAP Business One Mastery Training Course
    • SQL Query Building for SAP Business One Users
    • Working Remotely: Efficiently and Effectively
  • TWITCH
  • SOCIALS
    • LINKEDIN
    • INSTAGRAM
    • TWITTER
    • PODCAST
  • SUPPORT // CONTACT ME
    • PSS – New Player FAQ
    • SAP ARCHIVES
BATTLESHIPCOBRA

BATTLESHIPCOBRA

Mike Taylor

SAP CONSULTANT
YOUTUBER
UDEMY INSTRUCTOR
YouTube Channel Udemy Courses

Category: Tips & Tricks

SAP Business One B1i SSL Integration Installation (Details)

Posted on 02/18/201502/21/2018 by Mike

See my video on the B1i installation process including my AutoSSL tool by clicking here. Main SAP Note 2019275 (click for link) NOTE: This article has been adapted from the main SAP note and expanded upon based on several installations. Prerequisites You need to have B1i installed You need the […]

Posted in SAP, Tips & TricksTagged B1i, SAP, SAP Business One, SSL23 Comments

How to Pull UDF Dropdown Descriptions into Queries / Crystal Reports SAP Business One

Posted on 12/09/201402/21/2018 by Mike

When you make a dropdown list in SAP the data is stored as a code in the system. When trying to do an SQL query or Crystal Report you will find that only the code is output so the user reading the query / report doesn’t see the description.

Posted in SAP, Tips & TricksLeave a comment

Make a Pareto Chart in Crystal Reports

Posted on 09/16/201402/21/2018 by Mike

I had recently needed to make a Pareto analysis chart in Crystal Reports and couldn’t figure out how to do it through the chart expert. The trick is to Record Sort the data into the order you want and it will sort the bar chart the same way. I did […]

Posted in SAP, Tips & TricksLeave a comment

Tips & Tricks: Inventory Audit Report Doesn’t Match GL Balance

Posted on 12/10/201302/21/2018 by Mike

At some point in your SAP Business One consulting career you will get the question as to WHY the Inventory Audit Report (Inventory >> Inventory Reports >> Inventory Audit Report) doesn’t match the GL balances or balance sheet totals. Generally this question is during the year end closing process where […]

Posted in SAP, Tips & TricksTagged Inventory Audit Report, SAP, SQL Query1 Comment

Tips & Tricks: Last Price Report in Sales Documents

Posted on 11/17/201302/21/2018 by Mike

I have had the request from several SAP Business One customers to view the last price given to a specific customer for a specific item. Well the only real solution I could come up with would be to make an FMS on the price with a query. This is an […]

Posted in SAP, Tips & TricksTagged SAP Business One1 Comment

Twitch Channel

FOLLOW ME

YouTube

Twitter

Follow @battleshipcobra

NEWSLETTER



TOP POSTS

  • SAP Business One B1i SSL Integration Installation (Details)
  • How to Pull UDF Dropdown Descriptions into Queries / Crystal Reports SAP Business One
  • Crystal Reports Conditional Grouping Method
© BattleshipCobra. All right reserved
Proudly powered by WordPress | Biography by Yam Chhetri.
LIVE NOW! CLICK TO VIEW.
CURRENTLY OFFLINE