Finance | Project Operations, Human Resources, ...

Ledger accrual on Pending vendor invoices

(0) Share

Report

Posted on by Joao Almeida

Hi,

I'm trying to develop a customization where the standard Ledger accrual functionality gets used in the "Pending vendor invoice" form.

The standard functionality lets you define an accrual scheme, and in the general journal lines, you can go into Functions - Ledger Accruals and use your accrual scheme. When posting, the voucher lines automatically split into months based on the accrual scheme. More details here (https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/create-ledger-accrual-transactions)

I'm wondering if it is possible to apply the same logic for pending vendor invoices. On the vendor lines, it would have the same "Function" button with the Ledger accruals functionality where you could set it up and once the vendor invoice was posted it would use the accrual scheme logic. I tried doing this but I can't seem to link the accrual scheme with the vendor invoice lines so that they post the same way it does for general journal lines. I can't seem to find the relation between LedgerJournalTransAccrual and VendInvoiceInfoLine so that the vendor invoice lines get posted as the accrual lines.

Can someone help me figure out what I need to do or if you already implemented something similar, could you let me know how you did it?

Thank you.

All responses (4)

Answers (0)

Suggested answer

OsmanIstanbul 2,814 on at

Like (0)

Report

RE: Ledger accrual on Pending vendor invoices

Hi,

I have made such customization for one of my clients. I didn't use standard accrual functionality, instead added new fields on products and captured with this mark and added a code to the posting class that creates and posts a journal that contains related accrual transactions.

Best.
CapsLock 1,375 on at

Like (0)

Report

RE: Ledger accrual on Pending vendor invoices

Hi Ludwig,

Could you please provide more information on how to automatize accruals in pending vendor invoices with power automate?

Thank you!
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Ledger accrual on Pending vendor invoices

Hi Joao,

If you are on D365FO then you can create those accrual postings with the help of PowerAutomate out of the box.

For AX2012 environments you can think of leveraging UI Flows or - alternatively - make a system modification in case you don't have licenses / access to PowerAutomate.

Best regards,

Ludwig
Michal Krejza on at

Like (0)

Report

RE: Ledger accrual on Pending vendor invoices

Hi Joao,

What if you try record trace from General journal lines ? Maybe you will find some hint from that ?