Are you getting the best support for your SAP Business One system? SAP B1 customers generally ask this question whether it is due to certain issues taking some time to be solved, a business requirement that hasn’t quite been provided within the software or occasionally due to a breakdown in the relationship between the customer and the SAP Partner that provides them with support. Can you have a field that does this? Would it be possible to do that? My VAT report doesn’t include a Tax Code that I want it to. Is it possible to see which Customer pays the fastest? We hear all of the questions and we provide the answers. 1 Dash 1 offers support…
Author: 1dash1
Using variables in SQL queries for SAP Business One is straight forward for simple select statements but what about the more complex variables or if you want to declare a variable for your SQL? Answer: You have to get a bit more creative! See the example below. To select a from and to date as a variable in a declare statement you have to add a nifty bit of extra code. /* /SELECT FROM [dbo].[VPM1] T0/ declare @fromdate as datetime /* WHERE */ set @fromdate = /* T0.DueDate */ ‘[%0]’ /SELECT FROM [dbo].[VPM1] T1/ declare @tilldate as datetime /* WHERE */ set @tilldate = /* T0.DueDate */ ‘[%1]’ select OVPM.docnum, VPM1.dueDate,VPM1.CheckNum, VPM1.Branch, VPM1.BankCode, VPM1.CheckSum, OVPM.CardName,…
If you are interested in writing your own SQL queries for SAP Business One the following will assist you. Basics of SQL Writing for SAP Business One SQL query and related terms Before going into the details of SQL query, I would like to briefly introduce some basic database concepts because SQL is a database language for managing data in Relational Database Management Systems(RDBMS). RDBMS RDBMS is a Database Management System that is based on the relation model. Relational here is a key word for RDBMS. You will find that data is stored in the form of Tables and the relationship among the data is also stored in the form of tables for RDBMS. Table Table is a key component within a database.…
We are currently taking bookings for training courses throughout August 2013. Our training courses can either be on your site for a maximum of 8 people or at an external location suitable for attendees from various companies. On site training is excellent for your employees as it will be specific to your system as it will be based on your Test system. External multi-company training is more suited for non specific training requirements and usually proves extremely useful for those candidates wishing to network with peers from other industries. Our SAP Business One training courses can be specifically tailored to your system and, dependent on time, our time can be used for consultancy questions. We will listen and…
Down Payment Interim Account & Down Payment Clearing Account An explanation / definition of what the Down Payment Interim and Clearing Accounts are for and how they are used. When a company receives or makes a down payment, the payment amount is recorded in an interim account before it’s deducted from the final transaction. For period end auditing purposes, the transactions that make up the value of the interim accounts must be easily auditable. In SAP Business One, postings are made to the following two interim accounts in the down payment process: Down payment clearing account Down payment interim account The postings to these two accounts are automatically reconciled as follows: Down Payment Request ProcessWhen you create a…
Here are a few basic SQL queries to be used in SAP Business One. You can copy and paste the queries into the Query window of Business One. Simply copy between from “–begin…” to “…–end” and paste into your Query window. SQL for Open Sales Orders –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from ordr t0 where t0.docstatus = ‘O’ –end By Date –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from ordr t0 where t0,docstatus = ‘O’ and t0.docdate between [%0] and [%1] order by t0.docdate –end SQL for Open Deliveries –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from odln t0 where t0.docstatus = ‘O’ –end SQL for Open Invoices –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from oinv t0 where t0.docstatus…