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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Customer/Ledger differ...
Microsoft Dynamics AX (Archived)

Customer/Ledger differences

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All

i ran the report to show the difference between the customer account and ledger and it showed many differences as posted

2744.Untitled.jpg

no i don't know what to do to settle these differences as i'm new to the program and it happened that i'm supposed to finish all the pending issues.

Customer/Ledger reconciliation Page 1 of 1
4/19/2018
7:19 PM
Sun City Live
From date 1/1/2017 To date 4/19/2018
Main account Name
12030950 مصروفات  للمالك مستحقة علي  المستأجر              
Date Voucher Journal number   Customer   Name Customer balance   Ledger balance   Difference
1/22/2017 COLLMVCR-000001014     CUST-0034   I. Zone 60,233.04   0.00   60,233.04
1/22/2017 COLLMVCR-000001015     CUST-0034   I. Zone 45,712.64   0.00   45,712.64
3/19/2017 COLLMVCR-000001873     CUST-0165   CINNABON 105.00   0.00   105.00
3/19/2017 COLLMVCR-000001874     CUST-0102   Cinnabon & Carvel 286.00   0.00   286.00
3/19/2017 COLLMVCR-000001875     CUST-0102   Cinnabon & Carvel 2,064.00   0.00   2,064.00
4/30/2017 COLLVCR-000004623 SCL-022356   CUST-0091   Seif Pharmacy 0.00   -53.48   53.48
4/30/2017 COLLVCR-000004624 SCL-022357   CUST-0091   Seif Pharmacy 0.00   -39.95   39.95
4/30/2017 COLLVCR-000004638 SCL-022371   CUST-0009   Mazaya for Perfumes 0.00   -17.58   17.58
4/30/2017 COLLVCR-000004650 SCL-022383   CUST-0023   Carrefour 0.00   -1,244.37   1,244.37
4/30/2017 COLLVCR-000004651 SCL-022384   CUST-0023   Carrefour 0.00   -1,205.04   1,205.04
4/30/2017 COLLVCR-000004652 SCL-022385   CUST-0023   Carrefour 0.00   -51.90   51.90
4/30/2017 COLLVCR-000004653 SCL-022386   CUST-0023   Carrefour 0.00   -21.91   21.91
4/30/2017 COLLVCR-000004654 SCL-022387   CUST-0023   Carrefour 0.00   -8.63   8.63
4/30/2017 COLLVCR-000004655 SCL-022388   CUST-0023   Carrefour 0.00   -5.53   5.53
4/30/2017 COLLVCR-000004656 SCL-022389   CUST-0023   Carrefour 0.00   -1.01   1.01
5/31/2017 COLLVCR-000004696 SCL-022766   CUST-0046   Premaman Belgium Brand 0.00   -95.52   95.52
5/31/2017 COLLVCR-000004697 SCL-022767   CUST-0046   Premaman Belgium Brand 0.00   -45.45   45.45
9/30/2017 COLLVCR-000005105 SCL-024844   CUST-0036   BTC 0.00   -14.03   14.03
9/30/2017 COLLVCR-000005107 SCL-024846   CUST-0036   BTC 0.00   -62.60   62.60
9/30/2017 COLLVCR-000005108 SCL-024847   CUST-0036   BTC 0.00   -62.60   62.60

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    The best thing is working through the different vouchers.

    Take the first one as an example that is only posted in the customer subledger but not in GL.

    Can you open that voucher and have a look at the transaction origin form?

    What do you see in this transaction origin form?

    Can you share a screenprint of the transaction origin form?

    Best regards,

    Ludwig

  • Suggested answer
    ZvikaR Profile Picture
    ZvikaR 190 on at

    1. you have transactions in the ledger which are not in the customer sub ledger

    does your ledger account marked as "do not allow manual entry" in the chart of accounts?

    2. you have transactions in the sub-ledger which are not in the general ledger

    do you have several posting profiles (going to other ledger accounts?)

    are these transactions using those other posting profiles?

    are you using customer pre-payment functionality?

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig

    i take example the second number for customer Izone amount 45,712.64

    the voucher number is COLLMVCR-000001015 which is an automatic Journal happened because this was a check under collection last year and this year was returned from the bank and find below the screenprint

    3821.Untitled.jpg

    it's affecting other customers and other ledger accounts which is wrong as this check was only for one customer .

    so i don't understand this matter and why is it happening like this.

    the other example posted in ledger and not in customer Voucher COLLVCR-000004623 amount 53.48 the amount is shown without any dimensions i don't know why too and below the transaction origin.

    3821.Untitled.jpg

  • Community Member Profile Picture
    Community Member on at

    1-no i just figured out that it wasn't checked but i didn't check again until i fix everything first then i will check it all for not allowing the manual entry but the journals posted in the GL and not in the Sub are automatic Journals which means it's out of settlements .

    2- yes we have different posting profiles for different ledger accounts in customer posting profile.

    3- no we are not using prepayment.

    thanks

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    What is the customer summary account that ia setup in the customer posting profile? Is this the account that has the $53.48 posted? The last line shows the transaction in the customer subledger.

    Can you summarize the amounts that have been recorded on the summary account that is setup in your customer posting profile?

    Has this summary account possibly been changed in the meantime?

    Best regards

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    the account setup on customer posting profile is 12030950 the amount 54.48 is posted on different account and it was not changed by anyone at all.

    how can i summarize the amounts that have been recorded on the summary account ? if you are asking if all amounts were posted on setup account 12030950 it's all posted on it except that 54.48

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Ahmed_Elsayed,

    Do you have a clue where the account 12030200 is setup?

    Is it an automatic posting account?

    Is it an account that is used e.g. in combination with a charge code?

    In the voucher document that you shared can you find the 'original document' button and open that?

    You should probably see a sales order document. Can you select 'view details' then, which should open the sales order that created the voucher.

    Once you are there can you investigate the sales order and sales order lines to identify where the account 12030200 comes from?

    (For example check the different sales order lines, the accounting distributions, etc.

    Best regards,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans