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) / Account for sales tax ...
Microsoft Dynamics AX (Archived)

Account for sales tax prepayment for customer account XXXX in posting profile ADV does not exist

(0) ShareShare
ReportReport
Posted on by benjamin84 2,075

Dear All,

I want to ask about customer settle open transaction,

my user want to settle invoice to customer prepayment.

but infolog showed message like  this 'Account for sales tax prepayment for customer account XXX in posting profile ADV does not exist'

please help.

Note : do I  should go to  AR Parameter,  ledger and sales taxes , payment - prepayment journal voucher

and tick at Salex tax on prepayment journal voucher ?

thank you 

Settle-Open-Transaction.png

*This post is locked for comments

I have the same question (0)
  • Anisha Fakir Profile Picture
    Anisha Fakir 680 on at

    Hi, The error message says a ledger/main account has not being setup for your posting profile. Go to Accounts Receivable \ Setup \ Customer posting profile. On this form you will specify an account for your Sales Tax Prepayment to post to.

  • Verified answer
    benjamin84 Profile Picture
    benjamin84 2,075 on at

    Hi Anisha,

    I found that the payment journal is setted to the wrong sales tax group.

    I had tried to create another payment journal for reverse ( the amount is in debit, the wrong one at credit )

    and tried to settle those two, but still trouble.

    do I just create the correct payment journal and settle with the correct one ?

    how to clear unsettled posted wrong payment journal ?

    thank you

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Check your customer posting profile which you have created for prepayment, attach "sales tax prepayment" account.

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

    Hi benjamin84,

    Can you compare your setups with the ones shown in the following screenprints that I made from one of the MS contoso demo companies?

    arpar2.png

    arpar2.png

    Do you make use of a different setup?

    Best regards,

    Ludwig

  • benjamin84 Profile Picture
    benjamin84 2,075 on at

    Hi Hafiz,

    yes, but my posting profile has been set up for long time not using sales tax prepayment account,

    we not gonna change this setting.

    if I create again payment journal with right data,

    how to correct/reverse the wrong old one ?

    thank you

  • benjamin84 Profile Picture
    benjamin84 2,075 on at

    Hi Ludwig,

    thank you for your information.

    my company has different set up, my user accidentally create payment journal with type prepayment and choose wrong sales tax group.

    if my user create again payment journal with type prepayment and choose correct sales tax group , how to reverse/ clear the wrong old one, because its cant be settle.

    or do I change the setup for a while for settle this wrong payment journal, once done, change the setting back  ?

    please advice Ludwig,

    danke, appreciate.

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

    Hi benjamin84,

    To correct the wrong payment journal that has been posted by the user, I would create another 'wrong' payment journal with the exact same Settings but an opposite sign for the amount posted.

    Once the two 'wrong' payments are made, you can make use of the open transaction editing form and settle them to make them disappear from the open transactions form.

    Best regards,

    Ludwig

  • benjamin84 Profile Picture
    benjamin84 2,075 on at

    Hi Ludwig,

    Let me test this first at Demo.

    Danke Ludwig.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    If you want to reverse your previous posted payment journal. Go to that customer, click on "Transaction" button. Find the customer Payment which you want to cancel, select that payment & click on "Cancel Payment" button as per given snapshot.

    This process will reverse your posted payment journal

    7840.Snapshot.JPG 

  • benjamin84 Profile Picture
    benjamin84 2,075 on at

    Hi Hafiz,

    very nice information.

    btw, my user create 1 payment header, its has 5 payment lines, its has 1 'wrong' line.

    its is ok to cancel one of the payment line, and create another 'correct' another payment header with 1 lines  ?

    Thank you

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