Using the Cash Impact Report

This report shows your expected cash flow over a specified period of time for a selected range of currencies in summary or detail format. The information is organized in six user-defined pay range periods (or buckets).

You can include this information on the report:

  • A/R transactions, A/P transactions, and early payment discounts
  • Transactions for customers and vendors that are on hold
  • Customer orders and vendor purchase orders. For customer orders, you can elect to include blanket releases and progressive billings. For vendor orders, you can elect to include blanket releases and PO requisitions.
  • Estimated. If you include estimates, you can select the types to include (Working, Quoted, Planned), and specify the estimate order offset days.
Note: 

If you are using advanced terms, the European algorithm is used to calculate the due date buckets for purchase orders and customer orders.

Landed Costs

Landed cost records are accessed to determine the outstanding, unvouchered, landed cost amounts. The landed costs are not quantity-based; therefore, it is not possible to simply multiply the costs by the difference between the quantities ordered and vouchered.

The report finds all landed cost PO receipt records for the PO line record, and subtracts the vouchered amount from the total estimated cost for the landed cost on the PO line.

When no landed cost PO receipts exist for a PO line (because, for example, no receipts have been posted against the line), the full estimated cost is still payable.

Also, landed cost PO receipt records with a vouchered amount of zero may exist (that is, the line was received but not vouchered). In such cases, the full estimated cost is also still payable.

The calculation for the material portion uses the PO line material cost, multiplying it by the difference of the quantity ordered minus the quantity vouchered.

At the point of vouchering, the landed cost estimate amount will reduce the cash outflow commitment from the PO, and show separately as an A/P transaction under the voucher number that's created.

Related topics