It is common for organizations that have multiple sites that those sites will buy and sell products between divisions. Oftentimes organizations will model the bookkeeping for the intersite shipments and intersite purchase receipts to pass through the intransit inventory account vs mapping it through the RNI account.

The RNISQL requester always includes these intersite receipts which depending on the accounting setup may not be correct. A quick resolution to this problem would be to include a new filter on this report that would allow the user to specify if they want to include the receipts for intersite or intercompany PO's.

Comments

  • In my mind the inter-site receipts should be filtered out by default. They have nothing to do with RNI reconciliation and must use inventory in-transit account. Using RNI account on inter-site receipts is incorrect. Therefore I would not make it even an option.

    Inter-company receipts are different story but I think it is more complicated. I can vote for a parameter to specify if I want to include inter-company receipts (in case company pays for the merchandize).

  • Sounds good to me.