web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

transfer data within A/R

(0) ShareShare
ReportReport
Posted on by

Hello Experts,

To allow for the accurate reporting, all open outstanding balances as at the end of August 2016  (i.e. Trade and other receivables G/L with a Balance) will be created as customers in customer card  and all transaction that make up that balance will be entered at the original transaction date. The corresponding entry will be to the old GL Accounts, thus no effect apart for the change from one Accounts Receivable GL Balance Sheet accounts to another Account Receivable GL Balance Sheet Account (GL-XXXXX)

I am naïve to accounting hence I need to understand how to capture the above information in general journal. Here the amount in GLXXXX_OLD needs to be transferred to GLXXXX_NEW and show the balance in the customer card at the same time.

What will be the accounting treatment?

1. Customer

2. GLXXXX_OLD

3. GLXXXX_NEW

Please also advise how you should treat such scenario.

Thank you

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: transfer data within A/R

    I do not get fully the final idea about that request, but if you need to transfer customer  A/R from one G/L account to another (assuming they were already posted through customer cards), you would need to do following steps to transfer outstanding A/R:

    - have two different customer posting groups (one for the one G/L account and one for the other) (generally, the group that is selected as default on customer card will generally specify the G/L account to which the posting will be made; e.g., if you select the customer in the sales order, the posting will be done to such G/L account that is by default selected in the customer card as a posting group)

    - create first line in the general journal, select "credit-memo" type and select your customer card in account no., enter negative needed amount; do not fill balancing account no.; select posting group as the old posting group bounded to old G/L account

    - create a second line in general journal, select "invoice" type and select your customer card in account no., enter positive needed amount; do not fill balancing account no.; select a new customer posting group, bounded to new G/L account.

    - you should have the same posting date and same document number for both lines

    - posting this would result that system would clear up the old G/L account and move the needed amount to new G/L account.

    - As those two lines will generate two customer ledger entries, you would need to apply the first one (the credit-memo) to your initial open balance transaction in customer ledger entry, and you will have the last one as new balance open.

     

     

    If for some reason you have your A/Rs posted not through customer cards but just as G/L entries and you would now need to convert them to Customer Cards, the process is similar, but you can enter just one line to the general journal:

    - put customer type and select you customer that would have new posting group assigned to new G/L account in the no. field, and in the balance part of the transaction select G/L Account type and needed old G/L account.

    - posting this transaction will allow system to clear up the old G/L account and create a new balance on a new G/L account, having also needed customer ledger entries.

  • Community Member Profile Picture
    on at
    RE: transfer data within A/R

    Hi Alexander,

    The reason for the request is that currently A/R is structured as one G/L to one sales customer and entries were posted through G/L. To elaborate this , whenever sales are made to a new customers instead of creating a customer in customer card a new AR G/L is created to accommodate the sales which is a bad practice.

    Now we want to move to customer functionality where we create new customers in customer card and report to at most to two AR G/L(i.e. trade receivables and other receivables). i.e. posting entries through sub ledger  

    And Your solution below meets my needs.

    --quoted

    If for some reason you have your A/Rs posted not through customer cards but just as G/L entries and you would now need to convert them to Customer Cards, the process is similar, but you can enter just one line to the general journal:

    - put customer type and select you customer that would have new posting group assigned to new G/L account in the no. field, and in the balance part of the transaction select G/L Account type and needed old G/L account.

    - posting this transaction will allow system to clear up the old G/L account and create a new balance on a new G/L account, having also needed customer ledger entries.

    --quoted

    Thank you Alex I appreciate you for posting the solution.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans