Skip to main content

Balance Upload

 Before to start the balance migration, be sure that all the master data is in the system like bank accounts, GL accounts, vendors , customers and their posting profiles. Also need at least one journal to be able to post the transactions. You may use a separate journal to be used once or can use one of which are already defined and to be used while balance upload journal will stay forever in the system and can not be deleted. But you may restrict by to add a user group , so that users will not see in the future as a solution. Also may require a separate journal o use a separate voucher series for balance upload but that also can be managed by to change the original journals number sequence as well. One daily journal will be enough but it depends on the implementation type while if assets are going to be uploaded or vendor invoices for balance upload need to be reported as invoices in transactional level. 

   While modules are used in D365FO, module related accounts needn't to be used for the balance upload will require module codes like vendor code, customer code etc. 

  You need to have a cut off date. And balances of trial balance and module related accounts must be the same. 

  Transactions need to be uploaded in their own currency with the correct exchange rate.

   While voucher must be balanced, you need to create a dummy GL account to balance the voucher which to be used as offset account.

Labels:

Comments

Post a Comment

Popular posts from this blog

Management Reporter (MR)

      Management reporter is  a tool that help users to create their own financial reports without customization/development or help from the IT team/consultants . Is used to prepare financial statements such as income statements, balance sheet etc which has the GL transactional/budget data and dimensions in D365 F&O. It was outside Ax but now you can reach within the D365 F&O.      You may use the functionalities below:          -    Transactional and Budgets Data          -     COA and Dimensions          -     Total Accounts          -     Report Variances          -     Pre Set Reports          -     Report Details of Transactions like voucher number, vendor and customer etc for audit reporting         -    Report for Consolidations         -    Report in Different Currencies
Post a Comment
Read more

D365 F&O Transportation Module (TMS)

      I would like to give some summary information on the TMS module. TMS module helps you manage your both inbound and outbound operations.   You can plan your shipments, routes, loads, appointments and drier check in/outs.  You can see the fastest or less expensive routes as an example with to assign rates and calculate with engines. Also you can manage and reconcile charges. Please find the Microsoft Documentation for the Module below: https://docs.microsoft.com/en-us/dynamics365/supply-chain/transportation/transportation-management-overview Also I like the video series below from Michael Cobbin which give detail for the TM module from Tech Talk: https://www.youtube.com/watch?v=gqGKgiDEQLk https://www.youtube.com/watch?v=gqGKgiDEQLk&list=PLaKeZD0fHWIp8zD088_6svgMZ5v1CmJGz&index=8 https://www.youtube.com/watch?v=9-gGUxeQSAc&t=1408s https://www.youtube.com/watch?v=gqGKgiDEQLk&t=1456s
Post a Comment
Read more

Tax Calculation Service (RCS)

      Tax Calculation service helps system to calculate complex taxes between country and locations and EU and multiple tax registration ids. For this purpose you have to setup RCS, enable feature and setup all the scenarios in the tax calculation engine. Not only it helps calculate these but more complex scenarios like calculation of taxes based on margin.     You may find the documentation of Microsoft below and also a video that briefly explains how system works. https://docs.microsoft.com/en-us/dynamics365/finance/localizations/global-tax-calcuation-service-overview https://www.youtube.com/watch?v=B2fN9AHoYnQ
Post a Comment
Read more