In Microsoft Dynamics 365 Business Central (Sales), how do I… Manage Relationships Between Customers

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Sales), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Managing relationships between customers is a fairly usual requirement. Common scenarios are when you are dealing with multiple branches of the same company or perhaps a subsidiary. I’ve worked with systems, such as the soon to be end-of-life Microsoft Dynamics GP, which had functionality which could be used to manage these types of relationships.

The question came up from a client recently with whom I am working to implement Microsoft Dynamics 365 Business Central and they sell to multiple branches of the same company and need to manage these relationships separately, in terms of the orders they raise and from whom payment is received.

Depending on how you need to track orders and who will be paying, there are a few options for how to manage the customers in Business Central, but the functionality itself is actually very limited (there are third parties available who have enhanced the parent/child relationship functionality.

In the scenario with which I was dealing, each branch would order and receive goods, but the parent company itself would want to receive the invoices and remit payment; the client also wanted to have a single credit limit for the company, which is shared between the branches, rather than each branch having it’s own credit limit.

Fortunately, this requirement falls squarely within the functionality available in Business Central without needing to make any changes.

On the Customer Card (21) page, on the Invoicing fasttab, you can set the Bill-to Customer to another customer account; this other customer will became the default Bill-to customer on sales transactions as they are entered:

Customer Card page showing Bill-to Customer being changed

Continue reading “In Microsoft Dynamics 365 Business Central (Sales), how do I… Manage Relationships Between Customers”

In Microsoft Dynamics 365 Business Central (Administration), how do I… Edit Data in Excel

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Business Central allows users to export data to Excel from list and worksheet pages by either using the open or edit option. If you choose the open option, then the data is simply exported into a static Excel workbook, which you can then manipulate or share with someone else.

If, however, you take the edit option, you can edit the exported action and import back into Business Central.

To edit data in Excel, open a list page and apply whatever filters you need; the export will only be data loaded on the page, so you can pre-filter before exporting to Excel, such as limiting the page to only current period data.

Click the share button in the top right and select Edit in Excel:

Chart of Accounts list page with share menu open

Continue reading “In Microsoft Dynamics 365 Business Central (Administration), how do I… Edit Data in Excel”

Source Codes in Microsoft Dynamics 365 Business Central: Use a Different Source Code for Journals

Microsoft Dynamics 365 Business CentralThis article is part of the Source Codes in Microsoft Dynamics 365 Business Central and of the larger ongoing In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Different source codes can be assigned on the General Journal Templates (101) page, but, unfortunately, not per batch or journal, so you will need to use journal templates if you want to use different source codes.

To set a journal template with a source code, simply open the template page and on the required row, select a Source Code from the list:

General Journal Template page

All journals created in batches created for the template will use the assigned source code.

Source Codes in Microsoft Dynamics 365 Business Central
Understand Source Codes
Maintain Source Codes
Control Which Source Codes Are Used
Why You Might Want to Use a Different Source Code for Journals
Use a Different Source Code for Journals

In Microsoft Dynamics 365 Business Central, how do I…

In Microsoft Dynamics 365 Business Central (Administration), how do I…

Source Codes in Microsoft Dynamics 365 Business Central: Why You Might Want to Use a Different Source Code for Journals

Microsoft Dynamics 365 Business CentralThis article is part of the Source Codes in Microsoft Dynamics 365 Business Central and of the larger ongoing In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

So far in this little series, I have explained how to create new source codes and change the assigned defaults for source codes, but why would you want to create additional source codes?

In most cases, I would not alter or delete any of the source codes included on the Source Codes (257) or the assignment of them in the Source Code Setup (279) page.

However, you can also override the source code on journal template, which means you can use custom source codes for different types of journal. I have worked with clients who did this, using unique source codes for payroll journals, month- and year-end adjustments and for journals integrated to the system from other line of business systems; I had a few clients in social housing who integrated journals from the rents system with a source code of “RLI” (Rent Ledger Interface).

Using different source codes for each general journal template (with similar functionality available for item and fixed asset journal templates) you can improve traceability of batches as the source code is easily available to reporting tools like Jet Reports.

Source Codes in Microsoft Dynamics 365 Business Central
Understand Source Codes
Maintain Source Codes
Control Which Source Codes Are Used
Why You Might Want to Use a Different Source Code for Journals
Use a Different Source Code for Journals

In Microsoft Dynamics 365 Business Central, how do I…

In Microsoft Dynamics 365 Business Central (Administration), how do I…

Source Codes in Microsoft Dynamics 365 Business Central: Control Which Source Codes Are Used

Microsoft Dynamics 365 Business CentralThis article is part of the Source Codes in Microsoft Dynamics 365 Business Central and of the larger ongoing In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

The Source Code Setup (279) page is used to define the default source codes used for different types of transactions or other entities in Business Central. As with the source codes themselves, this page is populated by default even if a blank company is created, as source codes are fundamental to how Business Central works.

You can change the assigned source code of a document or entity, simply changing the source code assigned to an entity; the page is broken down into fasttabs for each area of the system:

Source Code Setup
Source Codes in Microsoft Dynamics 365 Business Central
Understand Source Codes
Maintain Source Codes
Control Which Source Codes Are Used
Why You Might Want to Use a Different Source Code for Journals
Use a Different Source Code for Journals

In Microsoft Dynamics 365 Business Central, how do I…

In Microsoft Dynamics 365 Business Central (Administration), how do I…

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Run Page Scripts In Pipelines For Automated Testing

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 2.

The 14th of the new functionality in the section is run page scripts in pipelines for automated testing.

In 2024 release wave 1 Microsoft launched the page scripting tool as a preview. One of the most common feedback requests from partners since then has been to enable support for replaying captured page scripts in CI/CD (continuous integration and continuous deployment) pipelines for automated testing. In 2024 release wave 2, Microsoft are enabling exactly this capability by providing a stand-alone page script replayer for use in CI/CD pipelines.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  Oct 1, 2024
General Availability:  Oct 1, 2024

Feature Details

To run page scripts in your own pipelines, you can now use the stand-alone bc-replay script player. This script player is distributed as an npm (Node Package Manager) package. You can install the latest version of the package from the npm feed. No setup is required. Just run this command: npm install @microsoft/bc-replay --save

You can find more details on requirements, setup, and parameters at bc-replay npm package page.

Microsoft plan to provide support as part of AL-Go for GitHub at a later point, so that if you are using AL-Go for GitHub, you can get started faster setting up a pipeline. However, if you are using a different CI/CD agent and environment, you can create your own pipeline setups.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

Source Codes in Microsoft Dynamics 365 Business Central: Maintain Source Codes

Microsoft Dynamics 365 Business CentralThis article is part of the Source Codes in Microsoft Dynamics 365 Business Central and of the larger ongoing In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

The Source Codes (257) page allows the source codes to be maintained; it is best to add codes rather than changing or deleting existing ones. If you amend an existing code then Business Central will update every single transaction with that source code to the new code, a process which could take a substantiual amount of time and cause locks in the system which could disrupt people or processes.

Business Central ships with a complete set of source codes included, even when no setup data is loaded on creating a blank company; this is one of those areas which is included regardless as it is fundamental to how Business Central works.

To add a new code, click the New button and simply type a new {b]Code[/b] and Description:

Source Code page

There is no sequence column on this table so there is no risk of running into problems with the internal line number sequence.

Source Codes in Microsoft Dynamics 365 Business Central
Understand Source Codes
Maintain Source Codes
Control Which Source Codes Are Used
Why You Might Want to Use a Different Source Code for Journals
Use a Different Source Code for Journals

In Microsoft Dynamics 365 Business Central, how do I…

In Microsoft Dynamics 365 Business Central (Administration), how do I…

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: E-File IRS 1099 Forms Without Integration

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 2.

The 17th of the new functionality in the section is e-file IRS 1099 forms without integration.

If you prefer not to, or can’t, integrate directly with the IRIS portal, you can still file IRS 1099 forms electronically without integration.

Enabled for: Users, automatically
Public Preview: Jan 2025
General Availability: Feb 2025

Feature Details

Business Central online users can file IRS 1099 forms electronically via the IRIS API. Business Central only supports electronic filing. If you prefer not to use this integration, or if you have an on-premises version, you can create Magnetic Media as a way to electronically file returns. It lets you upload forms manually to the IRS. This feature will be available only for companies that use the IRS1099 module, which became available in 2024 release wave 1.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use Updated Saf-T 1.3 In Norway

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 2.

The 16th of the new functionality in the section is use updated SAF-T 1.3 in Norway.

Business Central helps businesses in Norway be compliant when authorities require the new SAF-T form (version 1.30) starting January 1, 2025.

Enabled for: Users, automatically
Public Preview: –
General Availability: Jan 2025

Feature Details

SAF-T Financial is a standard format used in the exchange of accounting data. SAF-T, or Standard Audit File-Tax, is the result of a joint development collaboration between the business community, the accounting sector, and the Norwegian Tax Administration, based on a recommendation by the OECD. SAF-T Financial has been revised and updated. The new form (version name 1.30) is required beginning January 1, 2025, but businesses can use the old form (version 1.20) for previous years (financial year 2024 and earlier).

Because of that, businesses can choose which format they want to use when they export data for SAF-T. If they want to report the previous fiscal year, they can still choose the old version 1.20, but if they want to use SAF-T export for the new fiscal year, they can easily change the format version to 1.30.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use The E-Documents Framework In The Spanish Version

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 2.

The 15th of the new functionality in the section is use the e-documents framework in the Spanish version.

This feature introduces electronic documents for invoices, which significantly enhances business efficiency by streamlining administrative processes and reducing operational costs. This feature minimizes manual data entry errors and accelerates transaction processing, allowing quicker and more accurate financial computation and tracking. Additionally, it reduces the need for physical storage space and paper usage, contributing to environmental sustainability. The real-time access to electronic documents improves transparency and facilitates better decision-making, ultimately leading to increased productivity and customer satisfaction, but it will also enable full compliance in Spain.

Enabled for: Users, automatically
Public Preview: Dec 2024
General Availability: Jan 2025

Feature Details

The E-Documents framework is localized for Spain, so you can use the Peppol BIS3 or FacturaE formats for electronic invoices. The Peppol BIS3 format will be enabled globally, but the FacturaE format will be available only through the Spanish localization.

You can choose to use one of the existing Peppol service providers as a communication channel via access points, or exchange documents by uploading them manually or using email.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index