A new year is approaching and among other things you wish for 2018, you can ask yourself what numbers you want out of your SAP Business One system for this new fiscal year. 

In this article, we want to draw your attention to an incredibly simple solution that is offered within the standard package that will take less than 5 minutes to understand, yet offers a multitude of new angles on the data available to you. 

This functionality has already been presented in an article by our Solution Manager Ari Schapira, however, we would like to put the spotlight on this feature again as we are approaching the New Year. 

With the Reference Field Links, you will exponentially increase the possibilities for your standard reports by tagging Journal Entries with predefined values. User Defined Fields are also available for selection. 

Support Spotlight A Numbers Person but not an SQL Wizard1

Once set up these values are continuously maintained in the Reference Fields of the Journal Entries created by each document type.

Later, when running standard Financial or Accounting Reports such as Balance Sheet, Profit and Loss and General Ledger, by opening the Expanded options you can use the tags to view exactly the sections of data that you want. Combine the functionality with the Projects and Distribution Rules to really pin point areas of your business to put the magnifying glass on. 

Support Spotlight A Numbers Person but not an SQL Wizard2

We hope the five minutes invested will give you a good return in the upcoming fiscal year.

The SAP Business One support team wishes you a Happy New Year!

 

Source:https://www.linkedin.com/pulse/support-spotlight-numbers-person-sql-wizard-jesper-magnusson

by MTC Systems on Dec 6, 2017 9:32:00 PM

Leave a comment