SAP Business One Consultants | IT Support | 0843 886 1449

All posts tagged SAP Business One Consultancy

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 settings.

  1. Find the formid, itemid of the problematic grid
    a) Open SBO, find the problematic grid in a form
    b) Enable the System/Debug information(Go to Menu->View, check System/Debug information)
    c) Put the mouse on any field of the problematic grid, find the formid (The number after ‘Form=’) and the itemid(The number after ‘Item=’) on the status bar at the left bottom of SBO
    d) Record this formid and itemid
  2. Close SBO. Make sure no SBO clients are connected to the server. (This step is very important! If SBO is not closed, this solution will not work!)
  3. Open SQL Analyzer, run the update query below


Open SQL Analyzer, run the update query below.
Before running the query, do please replace:
/!Formid found in Step 1!/ to the formid found in step 1.
/!Itemid found in Step 1!/ to the itemid found in step 1.
/!Problematic User Code!/ to the user code of problematic user.
–begin
–delete all the user settings
delete cprf where formid=’/!Formid found in Step 1!/’ — for this form
and itemid=’/!Itemid found in Step 1!/’ — and this document
and usersign =
(
select internal_k from ousr where
user_code = ‘/!Problematic User Code!/’
)
–endMissing months financial report fix

 

SAP Business One Year End Closing Instructions

SAP kindly provide a 50 page document which provides in depth instructions on the Year End process but most people only need to know how to run the actual Year End process in SAP B1.  Because it is a once yearly procedure, it is forgotten year to year. Here are the instructions for running the Year End process in Business One.

Year End Process in SAP B1

To carry forward the balances of the P&L accounts to the corresponding account in the balance sheet
(or several different balance sheets), you can use the period-end closing function. You can store the
results initially as a report and then post them at a later stage.
If you make postings after entering the balances carried forward, you need to restart the period-end
closing routine to include these subsequent postings.

EXAMPLE
Administration / Utilities / Period-End Closing

When you execute the report, the Period-End Closing window opens:

In the Period-End Closing – Selection Criteria window, you can specify the same account
in the Retained Earnings Account and the Period-End Closing Account fields.

Once you have executed the period-end closing for the selected expenses and revenue accounts, 2
transactions are created for each account and 2 journal entries are automatically created to reflect
those transactions.
The balances of those P&L accounts are posted to the period-end closing account on the same day
(the last day of the period) and the balances are reduced to zero. The first journal entry reflects this.
On the first day of the subsequent period, the period-end closing account is posted to the
corresponding balance carried forward to the retained earnings account in the balance sheet. The
second journal transaction reflects this.

The balance of the period-end closing account is zero.

This is how to run the SAP Business One Year End Process.

 

Contact Stuart Folley @ 1Dash1 if you have any questions or suggestions.

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message

 

 

We like to make things really simple to avoid confusion. Have a look at this quick vid and see it helps a bit. Although we install SAP Business One I guess our real talent is helping businesses improve their processes along the way.

Any questions please contact us by from our contact page, at contact@1dash1.co.uk, phone (at the top of the page) or carrier pigeon :)

 

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.

SAP Business One Training Courses

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 work with you to ensure that your users receive the training that will positively impact your business.

1 Dash 1 also provide Super User 1 week long training courses to enable one of your users to become the main point of contact for any SAP Business One related questions that arise within the business. The week long course will empower your user to answer questions and create SQL Queries for entry and intermediate reporting. The week long course is structured and priced differently to our offer training course offerings so please specify if the course is of interest and we will contact you with the relevant information.

Simply enter your details below with your training requirements and we will contact you to arrange dates and discover what training style is most suitable for you and your users.

Your Name (required)

Your Email (required)

Your Phone

Subject

Training Course Topic

Your Message

SAP’s announces that HANA powered versions of its ERP Business Suite range has gone on general sale.

The new version (Version 9) of Business One, which runs on Microsoft SQL and was announced yesterday at the Sapphire NOW conference in Florida, can be deployed on premise or in the cloud and is accessible from mobile devices.

The latest version of Business One also includes new capabilities for business partner and warehouse management, infrastructure and inventory management.

SAP Business One Powered by HANA

  • Run your entire business with a single solution that will scale as you grow
  • Drive measurable performance gains in all of your key business processes
  • Use analytics to get up-to-the second information on purchasing habits and more
  • Generate insightful, interactive reports in seconds – no delays, no waiting
  • Enjoy the power of the SAP HANA platform, priced specifically for small business
  • Access real-time business insights – for faster, smarter decision making
  • Empower employees to create standard and ad hoc reports with ease
  • Generate interactive reports in seconds – no delays, no waiting
  • Enjoy the power of the SAP HANA platform, priced for small business
  • Reduce your reliance on consultants and IT for reporting needs

The HANA in-memory database is currently SAP’s biggest technology initiative, and SAP co-CEO Jim McDermott, in a keynote Tuesday, said HANA would be the platform for all SAP product development going forward.

Version 9 SAP Business 1 powered by HANA

In a keynote Wednesday, SAP co-CEO Jim Hagemann-Snabe re-emphasized that point when he announced the general availability of Business Suite on HANA.

“I would claim that HANA is the biggest innovation in 20 years in business software,” Hagemann-Snabe said. Along with the technology’s ability process huge volumes of data, it also greatly speeds up the performance of Business Suite, SAP’s ERP and industry application set for bigger companies, he said. “This idea of putting data in main memory is a quantum leap.”

 

Find out more about the cost of SAP Business One.

Contact 1 Dash 1 to find out more about SAP Business One powered by HANA.

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message

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 payment for an A/R or A/P down payment request, the down payment interim account is debited or credited with the payment amount, and the down payment clearing account is credited or debited with the payment amount excluding tax.

    When you fully or partially draw the down payment to the final A/R or A/P invoice, the down payment interim account is credited or debited with the drawn amount, and the down payment clearing account is debited or credited with the drawn amount excluding tax.

    As a result, the postings to the down payment interim account and the down payment clearing account are fully or partially reconciled accordingly.

  • Down Payment Invoice ProcessWhen you create a full or partial payment for an A/R or A/P down payment invoice, the down payment clearing account is credited or debited with the invoice amount excluding tax.

    When you fully or partially draw the down payment to the final A/R or A/P invoice, the down payment clearing account is debited or credited with the drawn amount excluding tax.

    As a result, the postings to the down payment clearing account are fully or partially reconciled accordingly.

In the above two processes, if the final A/R or A/P invoice is then fully or partially drawn to a credit memo, the postings to the two accounts generated by the A/R or A/P invoice are proportionately reversed and reconciled.

However, if either of the two accounts has been fully, manually reconciled before the automatic system reconciliation takes place, SAP Business One does not perform the system reconciliation.

If you would like further help and support with SAP Business One contact 1 Dash 1 and a qualified SAP Business One consultant will contact you to discuss your requirements.

 

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message