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

Purchase invoice - amount cleared when G/L account changed

(3) ShareShare
ReportReport
Posted on by 6

Hi all,

I posted this in the General Forum but maybe this is more applicable to this forum

We are using OCR (Readsoft) to bring invoices into 'Incoming documents' which are then generated into the 'Purchase invoices'.

We have also setup dimension defaults for some of the Vendors we have we have utilised Test-to-Account mapping for G/L accounts for Vendors where possible to get as close as possible to the chargeable account string and minimize the requirement to change the G/L account and/or and dimensions.

However..... obviously sometimes the G/L account may not be mapped and fall into the default G/L account or just may need to be changed because the nature of the transactions requires a different G/L account charge code to be used.

When the user goes into the Purchase Line and updates the G/L account code, it is wiping all the amount values and resetting them back to 0 (both at the line level and at the header/totals level)! This happens to be a REAL pain. Therefore, if the user didn't take notice of the amounts before this , they have to open up the whole invoice pdf again to re-enter the line amounts. Surely this isn't right.  I can't see why changing an account number value should reset the amount fields to 0.00 and require re-entry.

Can someone please let me know if this is "out-of-the-box" functionality and if so, is there anyway to disable this for these purchase invoice scenarios. Unfortunately, I feel we will face a lot of these scenarios when we go live......

Thanks!

I have the same question (0)
  • Shubba Profile Picture
    6 on at
    Purchase invoice - amount cleared when G/L account changed

    Hi All,

    I'm new to Dynamics so I may be asking something that is fairly straight forward or a basic configuration related setting......

    We are using OCR (Readsoft) to bring invoices into 'Incoming documents' which are then generated into the 'Purchase invoices'.

    We have also setup dimension defaults for some of the Vendors we have we have utilised Test-to-Account mapping for G/L accounts for Vendors where possible to get as close as possible to the chargeable account string and minimize the requirement to change the G/L account and/or and dimensions.

    However..... obviously sometimes the G/L account may not be mapped and fall into the default G/L account or just may need to be changed because the nature of the transactions requires a different G/L account charge code to be used.

    When the user goes into the Purchase Line and updates the G/L account code, it is wiping all the amount values and resetting them back to 0 (both at the line level and at the header/totals level)! This happens to be a REAL pain. Therefore, if the user didn't take notice of the amounts before this , they have to open up the whole invoice pdf again to re-enter the line amounts. Surely this isn't right.  I can't see why changing an account number value should reset the amount fields to 0.00 and require re-entry.

    Can someone please let me know if this is "out-of-the-box" functionality and if so, is there anyway to disable this for these purchase invoice scenarios. Unfortunately, I feel we will face a lot of these scenarios when we go live......

    Thanks!

  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at
    RE: Purchase invoice - amount cleared when G/L account changed

    Hi Shubba,

    In standard system, it doest not remove amount, you can change GL code and split in to two different GL code of dimensions.

    Looks like you have some customization around that which is causing this issue.

  • Shubba Profile Picture
    6 on at
    RE: Purchase invoice - amount cleared when G/L account changed

    Hi Saurabh.

    Thank you for response however the company implementing the system has advised me that this is delivered unless you customise NOT to do it.

    Is there a way to find out if it has been customised as you suggested or an online trial version of dynamics to see it work as I had hoped for?

    Thanks!

  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at
    RE: Purchase invoice - amount cleared when G/L account changed

    Hi Shubba,

    1. Best practice will be defining the posting profiles properly for all possible Product or product categories , so that you need not to change the "GL code mapping at purchase line by users (Thats not a suggest able way)

    2. By any chance did you try changing GL code at the time of Invoice?

  • Shubba Profile Picture
    6 on at
    RE: Purchase invoice - amount cleared when G/L account changed

    Hi Saurabh,

    Not sure if you understood my initial post. We are not using Purchase Orders, only Purchase Invoices. Therefore all invoices are being created from the actual invoice metadata and no details are being inherited/copied from anything already in dynamics. Also, we have OCR setup to extract information at the header level only and no line level data is being selected.

    We have some mapped some suppliers to GL account number (via the Text-to-Account Mapping page)  however even if suppliers had a GL account mapped, there maybe an occasion where we change the GL account because of the purchase

    type (for example, the supplier was Amazon, and we have a 'Text-to-Account mapping' for Amazon for stationery but for this particular invoice was for a printer and the GL Account for this purchase should be office equipment).

    The invoice comes from OCR to Dynamics incoming documents and then when it generates into a Purchase Invoice, the GL account is set to the Text-to-Account mapped account of 'stationery', and then the AP user updates the GL Account to the Office Equipment number. This step of changing this GL account value is causing all of the line amounts (and any dimensions) to be cleared out and requires someone to retype in all of these values that had been defaulted/extracted into the line.

    Hopefully this makes sense.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Purchase invoice - amount cleared when G/L account changed

    Hello Shubba,

    Where and how is the 'text to account' mapping made?

    Is this part of a 3rd party solution or something that you build?

    Best regards,

    Ludwig

  • Shubba Profile Picture
    6 on at
    RE: Purchase invoice - amount cleared when G/L account changed

    It is delivered functionality

    When in the Incoming Documents page, select 'Actions' --> 'Process' --> 'Map Text to Account'.

    This brings up the 'Text-to-Account Mapping' page

  • DN-27020019-0 Profile Picture
    12 on at
    Purchase invoice - amount cleared when G/L account changed
    Hi Shubba,

    Keen to understand if you have resolved this issue and how you did it? Could you please share?

    Thank you in advance.

    Daniel

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,100

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 890 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 633 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans