Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Customer transaction a...
Finance | Project Operations, Human Resources, ...
Suggested answer

Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

(0) ShareShare
ReportReport
Posted on by Vinesh Tandel 582

Hello Experts,

I have an issue please help.

  • Any FTI (free text invoice) used for a customer which has main account used '217111' (profit &loss account - for bank fees) if we see the transaction on the customer we see that the amount shows up on the 'right side of the amount column indicating a credit with -ve sign', technically it is right because we need to debit it, "so system is posting in credit side column with -ve sign", however this is confusing the accounts personnel.

    Ideally it should be in left side of the amount column without any sign indicating the debit.
    check attachment to better understand. 
    NOTE : This happening if we use a particular GL account 217111' only. rest FTI with other GL accounts is fine.

Amount_5F00_shown-on-incorrect-side-_2D00_forum.PNG

Thanks,

Vinesh Tandel

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

    Hi Vinesh,

    The treasury management module is not part of the standard application.

  • Suggested answer
    Vinesh Tandel Profile Picture
    Vinesh Tandel 582 on at
    RE: Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

    Hey all the issue root cause has been found the FTI was posted from treasury mgmt module which in turn fetches the 

    data from third party and posts AR - FTI as write offs. after checking the subledger postings of FTI the issue was found there 

    the posting was swapped up for debit/credit columns. As  the transaction are triggered from data based on third party input 

    checking with the third party providers. 

  • Suggested answer
    Vinesh Tandel Profile Picture
    Vinesh Tandel 582 on at
    RE: Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

    Thanks Andre, the issue is auto resolved, only changes was Server maintenance happened after that issue was fixed as it was only a view issue. The voucher postings were correct only displaying on wrong side was the issue.

    Thanks all for your valuable inputs.

    Happy daxing.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

    Hi Vinesh,

    I do recommend to have a developer doing some debugging. There could be a setting or customization on another place in the system.

  • Vinesh Tandel Profile Picture
    Vinesh Tandel 582 on at
    RE: Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

    Hey Andre yes i compared the GL 'issue' account with other GL account used in FTI no difference and other GL account used in FTI is showing up fine

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

    Hi Vinesh,

    Can you check if some settings on this main account are different compared to other main accounts your are using on the free text invoices? If you can't find a difference in settings, you can ask a developer if he can debug the scenario to find the cause.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Customer transaction after Free text invoice using a particular main account shows amount in credit with negative sign.

    I have joined the threads as it is not intended to duplicate your questions on the forum.

  • Suggested answer
    Vinesh Tandel Profile Picture
    Vinesh Tandel 582 on at
    RE: Customer transaction issue

    please follow below for details. i have mentioned this link above as well.

    https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/392202/customer-transaction-after-free-text-invoice-using-a-particular-main-account-shows-amount-in-credit-with-negative-sign/1055518#1055518

  • saiijima Profile Picture
    saiijima on at
    RE: Customer transaction issue

    HI!

    Thanks for posting this!
    Could you give us the details of the problem?

    Thanks, Satomi

  • Vinesh Tandel Profile Picture
    Vinesh Tandel 582 on at
    Customer transaction issue

    Any FTI (free text invoice) used for a customer which has main account used '217111' (profit &loss account - for bank fees) if we see the transaction on the customer we see that the amount shows up on the 'right side of the amount column indicating a credit with -ve sign', technically it is right because we need to debit it, "so system is posting in credit side column with -ve sign", however this is confusing the accounts personnel.

    Ideally it should be in left side of the amount column without any sign indicating the debit.

    check attachment to better understand.

    NOTE : This happening if we use a particular GL account 217111' only. rest FTI with other GL accounts is fine

    Below is my original post but i could not get much response all screen shots are being added there.

    https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/392202/customer-transaction-after-free-text-invoice-using-a-particular-main-account-shows-amount-in-credit-with-negative-sign/1055518#1055518

    Thanks,

    Vinesh Tandel

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,356 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans