SAP Business One 9.0 Business Accounting System SAP Business One 9.0 Advanced GL Account Determination SAP Business One 9.0 provides a flexible and centralised system to manage inventory G/L account determination. With the advanced G/L determination rules, you can assign inventory G/L accounts by item groups, items, warehouses, business partner groups, ship-to countries, and various combinations of all the above criteria. SAP Business One 9.0 Financials Deferred Tax Enablement in Manual JE SAP Business One 9.0 enables you to manage deferred tax in manual journal entries, journal vouchers, posting templates, and recurring postings SAP Business One 9.0 Fixed Assets SAP Business One 9.0 allows you to manage fixed assets using a fully integrated solution. In addition…
Tag: SAP Business One Consultants
SAP Business One Missing Months / Periods in Reports Have you run a Balance Sheet, Profit and Loss or Trial Balance in B1 V8.1, 8.2 or a recently upgraded V9 and discovered that you are missing periods or months from the report? Weird, eh? It is as much use as an Octopus tentacle snooker cue, but don’t worry, it can be fixed! The issue appeared in V8.x and is fixed in V9. The problem is, you upgrade V9 and the problem still exists. The problem has been fixed and will not occur again but you need to fix the cause of the issue to see the months again. All this requires is a quick fix to a users…
Senior Implementation Consultant – SAP Business One (SAP B1 ) Home Based in Bedfordshire, Buckinghamshire, Cambridgeshire, Hertfordshire, Surrey, Oxfordshire, Northamptonshire £35k – £50k + Bens SAP Business One (SAP B1) Implementation Consultant SAP Business One Certified ERP Project Definition & Costing Project Life Cycle Pre-Sales Data Migration Installation Configuration Product Training Accounting background (ideally AAT) SQL CRM SQL Server Crystal Reports DTW Senior Implementation Consultant – SAP Business One, SAP B1 A Senior SAP Business One (SAP B1) implementation consultant is required by 1 dash 1. We want an experienced and enthusiastic SAP B1 Senior Consultant with an ERP/ SAP Business One implementation background to join our team. An Accounting background would be an advantage. ERP Consultant? Do you…
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…