Generating Goods Received and Shipped Reports without Invoices

Reporting  •  Article  •  10/17/2023  • 

Goods Received Not Invoiced

You can generate the Goods Received Not Invoiced report, a financial and inventory management document to track and manage the goods received from suppliers without invoicing. This report provides a summary of accurate financial reporting and inventory management.

To generate the Goods Received Not Invoiced report:

  1. Select the Search icon , enter Goods Received Not Invoiced, and then choose the related link.

    Alternatively, select Report > Goods Received Not Invoiced action on the Vendor Card or the Vendors list page.

    The Goods Received Not Invoiced report page opens.

  2. In the Report ID field, select the report ID (60134) from the lookup table.

  3. Fill in the fields as required.

  4. Select Print.

    For each posted purchase receipt line and posted return shipment line that is not yet invoiced, the report shows the following values:

    • Purch. Unit Cost – Specifies the Direct Unit Cost field value of the posted document line in the local currency. When the document is posted in a foreign currency, the value is converted using the currency factor and the posting date of the document.
    • Purch. Amount – Specifies the Purch. Unit Cost field value multiplied by the Qty. Rcd. Not Invoiced field value of the posted purchase receipt line or the Return Qty. Shipped Not Invd. field value of the posted return shipment line.
    • Unit Cost and Total Unit Cost – Specifies the expected cost of the item ledger entries of the posted document line, in the unit of measure of that line.

    The values of the posted return shipments are shown as negative amounts, so that the returns reduce the total value that is not yet invoiced per vendor and for the report as a whole.

Goods Shipped Not Invoiced

You can generate the Goods Shipped Not Invoiced report, a financial and inventory management document to track and manage the goods sent to customers without invoicing. This report provides a summary of customer information, product details, shipment date, invoice date, and total value.

To generate the Goods Shipped Not Invoiced report:

  1. Select the Search icon , enter Goods Shipped Not Invoiced, and then choose the related link.

    Alternatively, select Report > Goods Shipped Not Invoiced action on the Customer Card or the Customers list page.

    The Goods Shipped Not Invoiced report page opens.

  2. In the Report ID field, select the report ID (60140) from the lookup table.

  3. Fill in the fields as required.

  4. Select Print.

    For each posted sales shipment line and posted return receipt line that is not yet invoiced, the report shows the following values:

    • Sales Unit Cost – Specifies the Unit Cost (LCY) field value of the posted document line.
    • Sales Amount – Specifies the Sales Unit Cost field value multiplied by the Qty. Shipped Not Invoiced field value of the posted sales shipment line or the Return Qty. Rcd. Not Invd. field value of the posted return receipt line.
    • Unit Cost and Total Unit Cost – Specifies the expected cost of the item ledger entries of the posted document line, in the unit of measure of that line.

    The values of the posted return receipts are shown as negative amounts, so that the returns reduce the total value that is not yet invoiced per customer and for the report as a whole.