GRNI reports in D365

(0) Share

Report

Posted on by Community Member

There does not seem to be an obvious GRNI report in D365, Is the accrued purchases report the closest thing?

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

RE: GRNI reports in D365

So what we did was run the ledger detail against the details provided in the Accrued Purchases excluding VAT report. What that highlighted was that the report as we ran it included Fixed Asset PO's which in the ledger we treat differently and do not form part of our GRNI accrual but the D365 did. By switching the toggle for Display items accruing receipt liability that eliminated the Fixed Assets from the report and brought our reconciliation issues dramatically down.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,728 on at

Like (0)

Report

RE: GRNI reports in D365

Thanks for the update.

Appreciate if you kindly share the experience you had with this case and the solution steps you adopted to fix the value mismatch and how it appeared.

Regards,
Sourav

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: GRNI reports in D365

Thanks everyone, it looks like i have resolved the issue now, and I just had to switch on

Display items accruing receipt liability and that brought the report in line with the GL.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,728 on at

Like (0)

Report

RE: GRNI reports in D365

In addition to what Ludwig mentioned; question is;

-- Which account you want to match with your TB? Is that the 'accrual' account as recorded in the posted product receipt journal?

-- Is there any tax also recorded in the same journal?

Accrued PO excluding sales tax report shows transaction excluding sales tax as the report title itself explained. Therefore; if sales tax also posted, it will be clubbed with the expenditure account and a total Credit value will display in the accrual GL account which therefore, balance will not match with this report.

As an alternative way out as mentioned by Ludwig in AP module. It shows the values including tax wherever is posted in product receipt or even not posted.

Can you check if this helps you matching balances with TB for each GL account as posted?

Regards,
Sourav

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: GRNI reports in D365

Hi BoydBrebner,

Ok. So your report shows you a different amount compared to what you see in the GL trial balance. Is that right?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: GRNI reports in D365

worked out the reason why it was running but not matching the ledger, thanks for the advice etc,

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: GRNI reports in D365

Hi,

Please check out the following form:

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: GRNI reports in D365

Hi,

We have an online form available for that.

Alternatively, you can configure your own electronic report for that purpose.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

udaY-ch 5,090 on at

Like (0)

Report

RE: GRNI reports in D365

Hi,

Similar post you can find it here,

community.dynamics.com/.../purchase-orders-accrual-report-is-there-in-d365-f-o

Uday

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GRNI reports in D365

Hi

I can not find a GRNI report, trying to find a report that will show me PO's raised and have been received but not yet invoiced.

Was this reply helpful? Yes No