Anyone know of a report on net suite that will reconcile the accrued purchases account. The accrual account that is generated from the Item Receipt and Billing against a PO? Nightmare to reconcile manually with large transactional data.

You can recline either by creating saved search or by running vendor bill variance as a month end process.

Any recommendations on the proper results fields to use for the saved search? Need to be able to identify the issues I am seeing such as foreign exchange differences between bill and IR, Billed but no receipt, IR but no invoice, on a purchase order level

Look into SuiteAnswers ID : 50506

Thanks Sam1128. Do you know of a way to easily identify fx differences between the Billing and the Item Receipt? Currently there are some massive differences which are due to different exchange rates at billing and receipt date. With those differences staying in accrued purchases account on the balance sheet. These should get booked to a gain/loss account or P&L account. Or is this part of the vendor bill variance solution?

Yes it is part of vendor bill variances. I’ve seen many Netsuite implementations where vendor bill variance is never run which means balance sheet accrued purchase balance is always wrong.

Thanks this is the issue I am running into. Will Netsuite make the adjustment to the variance to the proper GL account? Example - if the PO is for inventory will the adjustment go to inventory or will all transactions go to the Default account that is setup in setup?