You’re offline. This is a read only version of the page.
Announcements
2,654
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
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.
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
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
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 ?
#1
André Arnaud de Cal...
294,099
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
