The received - not yet invoiced report is used for reconciling accounts connected to M10, M14, M18, M142, M155 and M91 posting types. You can compare the total amount on the report with amounts booked on these accounts.
The report may be ordered for a particular company, site and part type (inventory or non-inventory). The system will scan for all system events created by inventory and purchase transactions as well as invoices connected to receipts. The report will only summarize and display transactions and postings, of receipts that have not yet been invoiced or partially invoiced. The report will give the inventory quantity and value due on each of these receipts.
There will be a separate section on the report for periodic weighted average enabled parts at the site. Receipts that are not yet invoiced are grouped under the respective part number, quantities and values due are given per part. Note that it doesn't matter whether a part had been previously enabled for periodic weighted average. Values will not be summarized and displayed per part, but per receipt, unless the part is currently enabled for periodic weighted average.
Whether a receipt is regarded as been invoiced or not, depends on the To Date for which the report was ordered, when compared with the Applied Date of the transaction and Closed Date of the receipt. This is described in detail below.
The Closed Date of a receipt is when it is entirely received into stock, and all matched invoices have been posted authorized. This is automatically set on the Purchase Order Receipt page. If a receipt's Closed Date is later than the To Date specified on the report, this becomes a receipt which has not yet been invoiced, and is included in the report.
Note that if you do not expect any more invoices for a receipt, you can manually set the Closed Date of that receipt and exclude it from the received - not yet invoiced report. But to keep the report in balance with accounts, you will have to enter a manual voucher and book the remaining difference on the account connected to posting type M10 (for inventory parts) or M91 (for non-inventory parts).
Applied Date of the transaction will be used as the voucher date of the created voucher. (Vouchers are created when you transfer inventory transactions to financials.) This is displayed on the Inventory Transactions History page. Only receipts with Applied Date prior to the To Date will be displayed on the report.
The Applied Date is defaulted to the date on which the transaction is created (system date). But this could have been subsequently updated to move the transaction to a different date. If the transaction for the receipt has thus been moved, and transaction is transferred to financials, it is the updated Applied Date which would be compared with the To Date of the report.
Note that changing the Applied Date should have been done with great care. If the Applied Date has been moved later than the To Date, even if the receipt's Closed Date is later than the To Date, it would not be given in the report as a receipt to be invoiced. This could be very misleading, and accounts would not balance. The Applied Date must always be before the To Date, in order for the receipt to be displayed on the report.
Note: If the receipt is from an internal supplier, it will not be included in the report, unless that supplier is connected to a company different from the company of the site for which you ordered the report.
Please note that purchase orders for inventory parts with Company Rental Asset ownership are included in the report for the non-inventory part type, since the postings created for these orders are connected to the purchase transactions, and not the inventory transactions.