Inventory Reconciliation Report

Question

Dear All Gurus,

I just want to create the inventory reconciliation report that is possible, we want to show the transfer order fulfillment amount vs receipt amount has been different at the transfer inventory in transit. That why we want to reconcile report for this condition and also want to see the receipt and bill differently. Is that possible?

With Many Thanks,

Honey

Micah Timbol-Oracle · Accepted Answer

Hello there! Thanks for starting this discussion! To the other members: If you’ve got ideas or insights to share, don’t hold back—dive into the thread and let us hear from you!

Amanda Edwards · Accepted Answer

Good Morning,

There is a suite answers (67893) that shows how to create a report that show what was posted to the inventory accounts for the related Item fulfillment. receipt, and transfer order. Is this what you are looking for? Or are you looking to see the quantity and details of each transaction?

Solution

To create the Report, follow the steps below:

* Navigate to Lists > Search > Saved Searches > New
* Select Transaction
* Search Title: Enter Title
* Filter:
Note: For every required filter stated in the below substeps, use the dropdown menu to select it.* Select Type* Value: Select Item Fulfillment, Item Receipt

* Select Created From Fields...* Value: Select Type* Value:  Select Transfer Order

* Select Account* Value:  Select Inventory Account/s

* Click Results Tab
* Field:
Note: Always click Add once Field is selected and adjust as needed.* Select Date
* Select Type
* Select Document Number
* Select Account
* Select Amount (Debit)* Custom Label: Enter Debit

* Select Amount (Credit)* Custom Label: Enter Credit

* Click Save & Run

Note: Date Filter may be added should the Results need to be limited to specific Dates/Periods only for reconciliation purposes with Balance Sheet amounts.

Niks Blando-Oracle · Accepted Answer

Hi @Honey Soe,

Have you checked @Amanda Edwards' comment? Kindly let us know if you need further assistance on this.

https://community.oracle.com/netsuite/english/discussion/comment/16875576#Comment_16875576