web
You’re offline. This is a read only version of the page.
close
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, ... / Invoice approval journ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Invoice approval journal invoice PO but apply invoice round off before posting

(0) ShareShare
ReportReport
Posted on by Kauto 2,699

Hi,

I am using invoice approval journals to fetch invoices from the registration pool, match them to a purchase order number and then post the invoice.

I am doing this from code, by simply using the PurchFormLetter_ApproveJournal framework class.

I have a problem though, in some cases I would like to be able to use the invoice round off function that applies a value to the VendInvoiceInfoTable record to help make the invoice and the pending invoice data match, as in some cases there will be VAT rounding or incorrect invoice rounding by the supplier etc.

There is no mechanism to do this from what I can see through this method, I could manually create the vendInvoiceInfo table records but I don't see where I can reference the ledgerJournalTrans record from the approval journal if I go down this route.

Has someone worked on something like this before or can someone offer help?

Thanks

I have the same question (0)
  • Suggested answer
    Michal Krejza Profile Picture
    Michal Krejza on at

    Hello Kauto,

    If your code is trying to copy the functionality  of Dynamics 365 Finanance system - why not to record a trace and learn from the trace which method and how is used for rounding in standard ?

  • Kauto Profile Picture
    Kauto 2,699 on at

    Hi Michal

    Thanks for coming back to me, firstly this applies to a customisation in AX 2012 R3.

    Secondly, as stated I have already customised processes in the past for creation of vendInvoiceInfo data as part of purchase order invoicing and I know where in this process I can apply the invoiceRoundOff value.

    My question however applies to use of the PurchFormLetter framework, using this mechanism to post a purchase order invoice from an invoice approval journal, I want to be able to intercept the vendInvoiceInfoTable record that gets created in this process during the run or update methods of PurchFormLetter, so I can update the the record invoiceroundoff field value so that the invoice voucher from the approval journal and the purchase order data fetched will match and allow the invoice to post in scenarios where there are rounding issues.

    Currently the client manually edits this data in the TOTALS function of the pending invoice data, this is what I need to automate but cannot see any option using PurchFormLetter framework to achieve this,

    I have asked the team out there in case someone else has customised this or can point me in the right direction, telling me to use a trace is about as useful as a chocolate fireguard and is not constructive, it patronising and condescending.

    If you can help with a positive contribution then please do so.

    Thanks

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

    Hi Kauto,

    If you have the problem only with penny differences, can't you simply increase the allowed differences e.g. from 0.00 to 0.01 or a higher penny difference value?

    You can use the standard GL/AP parameters for that.

    Have you already tested that option?

    Best regards,

    Ludwig

  • Kauto Profile Picture
    Kauto 2,699 on at

    Hi Ludwig,

    I am already aware of this functionality, the problem I have is that using the PurchFormLetter framework for invoicing purchase orders through invoice approval journals, does not give you an option to intervene in the posting process to handle a scenario where there is any difference at all, the system fails to post the invoice, so it appears that the penny difference setup is not being taken into play for posting in this process.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans