Dynamics Community Forum Thread Details

GRIR Reconciliation

We have an issues with our GRIR reconciliation

Our consultants have produced a report for us which ties to the GRIR balance in our balance sheet, they have built a taylor made report using SQL server

Our goods receipts are fine and allocate against our PO numbers

Unfortunately we have a problem with our invoice receipts. In our business we receive invoices from our suppliers which can be spread over several PO's. The report we have assigns the entire amount against the first PO in the sequence, which causes an issue for us.

Our consultants have produced a second report which then details (in a subsidiary report) the invoice receipts but this is coming from the purchasing module and

(I) They haven't managed to integrate to our GL report (this doesn't seem possible)

(2) If the currency is non GBP (we are located in the UK), the value defaults to the PO currency and doesn't consider the ex-rate of the posting on the day of the transaction

(3) The subsidiary report isn't able to deal with PPV , it is just PO value * quantity invoiced

Is anyone aware of a GL report within Dynamics GP , or combination of reports, which will enable us to have both goods receipt transactions and invoice receipt transactions (even where invoices are received from suppliers which relate to multiple PO's) which we can then reconcile back to the general ledger?

Quick Links