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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

GL (Control account) not getting updated while settling the prepayment for few suppliers

(0) ShareShare
ReportReport
Posted on by 5

Hi,

I am facing an issue for few prepayment suppliers. I made them a prepayment, and when the products/material is received (product receipt is entered in AX) i booked the invoice through PO module (did not apply prepayment here), and then i applied the prepayment through the prepayment option through "all vendors" screen. But when i see the sub ledger/GL transaction report, i see some of this prepayment transaction not getting posted to AP control account, and show up as difference in this report.

I am not able to pinpoint exactly which transactions are not hitting the control account, but there are 3-4 supplier account for which this is happening. Can anyone suggest if there has been any change in setup for those vendors, which is why this is happening. Also since the prepayment application is matter of few clicks (i dont have to pass any manual GJ entry) i am not sure why system is behaving in this way.

your help in this matter is greatly appreciated.

Thanks,

Chetan

I have the same question (0)
  • Suggested answer
    SouravDam Profile Picture
    11,732 on at

    Hello Chetan,

    This is clearly related to setup change in vendor posting profile form.

    I have checked the scenario you explained and found no challenge in system. So after posting the PO invoice; if I apply the prepayment in the same invoiced PO from the "All vendors" form; I am getting the impact in the same main account set for vendor control as well as in prepayment account.

    Below highlighted entry I have got after applying the prepayment from "All vendors" form after this PO was fully invoiced.

    0486.JPG

    Now I have below queries to you.

    --- Have you got this mismatch in the same vendor ?

    For example; every time transactions are posted in the correct vendor controlling account (say; 1001) for the vendor (say; vendor account is V001) but then one or two times, the entry is posted in a different vendor controlling account (say; 1002) while using the same vendor account V001.

    If the answer is 'Yes', then you can be sure that somebody is playing with the vendor posting profile setup.

    --- You mentioned that, "some of these prepayment transaction not getting posted to AP control account ". Then in which account it is posted ? Is it posted in another vendor controlling account ? For example; instead of posting in account 1001, it is posted in account 1002.

    --- Have you set the purchase order prepayment account in the inventory posting profile setup form ?

    --- When you book the prepayment in PO, what is the journal entry you are getting ?

    Appreciate if you kindly elaborate these points which could be helpful to understand the entire scenario in more specific.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Suggested answer
    Rahul Mohta Profile Picture
    21,046 on at

    in the prepayment posting profile, d you have a generic setup for all vendors or limited to select vendors or groups

    would be better to provide one for all vendors

  • Suggested answer
    saurabh bharti Profile Picture
    15,059 Moderator on at

    Hi Chetan,

    Here are few things about prepayment:

    1. prepayment functionality does not have any impact on sub ledger , this is an standard feature

    2. If we use prepayment from PO, that is tagged to the PO not with vendor sub ledger

    3. SO, when you will apply this to any vendor from all vendors, just check is it impacting the "Actual posted Invoice Amount"

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Chetan,

    Can you let us know what system version you operate?

    You mentioned 'AX'; yet, which AX version do you operate or do you run D365FO?

    Many thanks,

    Ludwig

  • Prepayment Issue-2 Profile Picture
    20 on at

    4212.Scan2020_2D00_05_2D00_21_5F00_192704.pdf

    Hi Sourav,

    Thank you for your reply. I will provide you with one of the example with the couple of attachments, may be that way I can explain the issue I am facing. If you see the first page in attachment you can see a prepayment made (PPAY-1401068) for USD 656.15 (CAD 867.76), and (PPAY-1401067) for USD 3352.33 (CAD 4433.465) on the same page I added a screen shot of prepayment application entry passed by system where I applied USD 656.15 (CAD 867.76) in full, and part of USD 3352.33 (I.e. USD 1634.41 (CAD 2161.51) system passed a entry

    2210 (AP control account) Dr

    1140 (Prepayment) Cr

    In this above entry it shows its updating the AP control account (2210), but when you see the second page of attachment (vendor/ledger reconciliation) it shows the reconciliation is off by CAD 867.76. (CAD 2161.51 which was applied in the same entry is updating GL correctly) not sure why system is throwing this amount as off balance.

    Can you please have a look at it, and let me know what exactly is happening?

    I hope I answered all your above questions. Please let me know if you need additional information

    Thanks again for all the help.

    Chetan

  • Prepayment Issue-2 Profile Picture
    20 on at

    Thanks Saurabh

  • Prepayment Issue-2 Profile Picture
    20 on at

    Hi Ludwig,

    Its AX2012

    Thanks,

    Chetan

  • Prepayment Issue-2 Profile Picture
    20 on at

    Hi Rahul,

    I think we have Generic setup for all vendors.

    Thanks,

    Chetan

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    moved to the ax forum

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 804

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 639 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 528

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans