Logo
banner

Blogs

How to insert new balances for Vendors and Customers in a new company in Business Central

, April 14, 2022 698 Views

Requirement:

We had a requirement to import the balances of the Customers and Vendors in a fresh instance.

 Issues:

  • The master data wasn’t imported in the system.
  • No direct way to post the opening balances in the system.
  • While posting the balances there was an error related to the General Journal posting.

Solution:

  • Master data was imported in the system using the steps mentioned below.
  • To post the direct opening balances of the Customers and Vendors we used General Journal’s lines and then posted the balances which was then visible in the customers and vendors list.
  • To resolve posting error, we did the General Journal posting setup and associated the correct G/L account.

Pre-Requisite:

  • Master data should be imported in the system.
  • General posting should be setup in the instance.

Kindly check the below mentioned steps for the importing of the master data:

  •  Configure a new company, insert all the necessary information in the company.

  • Click on the Tell Me icon. Enter “Assisted setup” and click on the related link. Click on the “Migrate Business Data” link.

  • Data Migration wizard will open. Click on the Next

  • Click on Next button again. Here we are using the Excel way to import the data in Business Central.

  • Click on Download Template and follow the on screen instructions.

  • An excel template will be downloaded in your local machine. Fill the excel template with the appropriate data. Click on the Choose button to select the excel template.

  • Choose the downloaded template. Open the configuration worksheet and import existing data about customers, items, vendors, and the general ledger. Click on the Migrate button.

  • Click on the OK

  • Click on the Finish button.

Follow the below mentioned steps to import the balances of the Customer and Vendor.

  • Click on the Tell Me icon and type “General Journal”, click on the related link.

  • General Journal page will open. Click on the 3 dots, to create and use a new general Journal batch.

  • Click on the New button, create a new batch named as OPBAL and click on the OK button.

  • Click on the Actions >> Opening Balance >> Prepare Journal >> Customer Opening Balance.

  • Once we click on the Customer Opening Balance, all the lines with all the customers will be auto populated by the system itself.

  • Insert the important information like Amount, Bal. Account Type, Bal. Gen. Bus. Posting Group, Bal. Gen. prod, Posting Group and Bal. Gen Posting Type.

  • After all the information is inserted, click on the Post button to finally post the entries and balance.

  • Go to Customers to check if the Balances are now posted.

This was how we managed to import the balances of the Customers and Vendors in a fresh instance.

Hope this helps!

 


ATM Inspection PowerApp to ease ATM inspection and report generation process.
https://www.inkeysolutions.com/microsoft-power-platform/power-app/atm-inspection

Insert data into Many-to-Many relationship in Dynamics CRM very easily & quickly, using the Drag and drop listbox.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/drag-and-drop-listbox

Comply your Lead, Contact, and User entities of D365 CRM with GDPR compliance using the GDPR add-on.
https://www.inkeysolutions.com/microsoft-dynamics-365/dynamicscrmaddons/gdpr

Create a personal / system view in Dynamics CRM with all the fields on the form/s which you select for a particular entity using the View Creator.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/view-creator

mm

Inkey

INKEY is your solution partner.
Our focus is to deliver you in-time intelligent innovative solutions ("key") for the problems in hand. Maintaining a quality standard right from the inception of a project is our top most priority.

Our team of talented professionals will execute your projects with dedication and excellence. We take ownership and accountability for the effort that goes into meeting our client’s needs.

Years of experience and proven success of delivering innovative custom solutions.

More posts by

2 responses to “How to insert new balances for Vendors and Customers in a new company in Business Central”

  1. Ms. Ishani Makan says:

    Test

Leave a Reply

Your email address will not be published.

The maximum upload file size: 2 MB. You can upload: image, audio, video, document, spreadsheet, interactive, text, archive, code, other. Drop file here