From the Microsoft Dynamics 365 Business Central blogs: Finding data; Process AP checks; Amount field; Streamline reporting

In this week’s Dynamics 365 Business Central blog roundup:

• Finding Data in Business Central
• How to process AP checks in Dynamics 365 Business Central
• How many digits can a Business Central amount field actually support?
• How to streamline your reporting process with Business Central extensions and apps

Finding Data in Business Central

Writing on the Bond Consulting Services blog, John Ellis stated that capturing and extracting data is one of the main functions of Microsoft Dynamics 365 Business Central.

He wrote that being able to find your most important business data helps employees work more efficiently and enables leaders to make better business decisions. Ellis noted that D365BC offers export options that let you extract data for analysis in specialized tools. 

In his blog post, Ellis explained a few of the best ways to find specific data in D365BC. The simplest and most versatile method of extracting data is using edit in Excel in list windows, such as customer ledger entries.

He pointed out that D365BC enables data mining by exporting its reports to Excel; however, the results are static and can't be refreshed. In addition, Ellis noted that even though you can't refresh its exported Excel workbook, you can also use a configuration package to create a meaningful report for various modules, such as fixed assets.

Ellis offered a few more ways for you to find data in D365BC.

How to process AP checks in Dynamics 365 Business Central

On the Encore Business Solutions blog, Abhishek Jain wrote about how to process AP checks in D365BC.

He noted that you first have to select the bank payment type and explained how to do that. Then he explained what you have to do to print the check. In his blog post, Jain also provided information on how to void an AP check after you print it –before or after you post the payment transaction.

Jain also explained the setup for AP checks, noting that before you enter a vendor payment transaction in the payment journal window, you must ensure that you've selected the correct check layout.

Finally, Jain stated that once you’ve selected your check format, you must assign a number series to the printed checks, and he explained how to do that.

How many digits can a Business Central amount field actually support?

Writing on his blog, Steve Endow noted that recently he was testing something obscure in D365BC Online – how many digits are supported in a "currency" field, a.k.a. an amount field.