Sage X3 – Tips, Tricks and Components
Greytrix is one of the oldest Sage Development Partner offering quality services of two decades for Sage product lines and have been awarded "Sage Partner of the Year" multiple times. Greytrix has a very strong technical and functional team of professionals and experts with hands-on experience in Sage X3. In these blogs, Greytrix will endeavour to share its knowledge with regards to implementation, training, customization, components, current technology trends and help users to understand in depth techno – functional aspects of Sage X3! Contact Greytrix Sage X3 Certified Specialists Team at x3@greytrix.com
Follow us on LinkedIn Follow us on Twitter Follow us on Facebook Follow us on YouTube
Skip to content
  • Home
  • Sage X3 Products
  • Sage X3 Services

How to do Control Account transfer in Sage X3

By Greytrix | March 12, 2021
0 Comment

Managing the Accounts in Sage X3 is the simple yet challenging task since X3 has provided most dynamic Account handling mechanism which includes customizable Automatic journal and Line level condition and formula. There may be a case in which a wrong account got picked due to the configuration error or a suspend account gets picked if the account is not defined in that setup screen to which Automatic journal is pointed.

Sage X3 provides a feature of Control account transfer which is used to replace the incorrect account with the correct control account. We can use this function to modify a source control account code with a destination control account code in the Journal accounting lines.

Below are the most important points to be considered before using this functionality:

  • This control is in effect only if the Chart of Accounts is associated with at least one consolidated ledger for the company.
  • This function is only launched for open financial years and involves all the postings with the exception of the RAN.
  • The control account transfer is made for a specific business partner. The process cannot be run for all the business partners in the source control account.

A selection screen is used to define the business partner (BP) line characteristics that the process must modify. Below are the criteria fields which are provided

Company, Site, Matched entries, the journal type, The journal, The user, Date range

Matched entries: The entries that are already matched can be included (by specifying the matching type: partial, full or both). In this case, the matching codes are also fused with the exception of the matching groups that mount two financial years that remain in the source control account (forward postings included).

Flow code coming from the account if the flow code management has been chosen for the account.

Flow initialization: The initialization rule only applies to accounts with Optional or Mandatory flow management selected and only for the first ledger defined in the journal entry transaction whose consolidation management is selected.

Source control account: User must enter the account code which is a incorrect or a suspended account.

Target control account: User must enter the account code which is a correct account which has to be applied in journal.

BP: User can only enter a Business partner with one of the following characteristics: Customer, Supplier, or Miscellaneous BP.

The Partner is the partner of original record if an account class is set to Yes, and it is empty if the account class is set to No.

Control Account transfer
Control Account transfer

Path: Financials > Utilities > Miscellaneous > Control account transfer

Control Account transfer enables you to correct your journal lines with the correct account if a wrong account got picked due to the configuration error or a suspend account gets picked if the account is not defined in that setup screen to which Automatic journal is pointed.

Hope this blog helps you correcting your journal lines with correct account and manages your accounts more efficiently!

Related Posts

  • How to setup Account/Dimension restriction in Sage X3
  • Sub contract Transfer in X3
  • Deferred Deletion in Sage ERP X3
  • How to do the inter-site transfer of balances in Sage ERP X3
  • Sage ERP X3 Integration with Salesforce.com
Category: Features Greytrix Sage ERP X3 Tags: Account, Journal
Post navigation
← How to configure additional process server and its benefit How to create schedule invoices in X3 →
traceability management erp webinar

Greytrix Website and Blogs

  • Greytrix
  • Greytrix Africa
  • Greytrix Australia
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage 300 – Tips, Tricks and Components
  • Sage CRM – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Intacct – Tips, Tricks and Components
sage crm and sage x3 integration

Categories

  • Configuration
  • Debug
  • FAQ
  • Features
  • Installation
  • Integration
  • Sage X3 Consulting
  • Tips

Archives

Awards

Greytrix Top ISV Partner
Greytrix Revenue Growth Enterprise Business
Greytrix Africa Highest Revenue
Greytrix Prtner of the Year
Greytrix Partner Award
Copyright 2022
Sage X3 – Tips, Tricks and Components
Iconic One Theme | Powered by Wordpress