CAC Receiving Activity Summary

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
Enginatics, R12 only
Repository
GitHub
Especially for companies who do not use separate inspection receipt processes, this report nets the purchase order receipts into receiving against the deliveries into stock and WIP outside processing (OSP), using the Subledger Accounting entries on the organization's receiving account for the entered transaction date range.

Each row is one subledger journal line on the receiving account, with the receiving transaction details shown in the Receiving Transactions form. With Unbalanced Distributions Only set to Yes, only PO distributions whose net amount per period, organization and receiving account is not zero are listed, so receipts and deliveries that offset each other drop out.

Quantity and UOM are the receiving transaction's quantity and unit of measure. A receipt or return against several PO distributions shows each distribution's share of the quantity.

Differences may be due to the initial receipt occurring in the prior month, not running Create Accounting in the current month, the goods never delivered into stock or OSP, or the delivery not processed by Create Accounting.

Template Summary by PO Distribution sums the amount per PO distribution and account.

Parameters:
==========
Transaction Date From: enter the starting transaction date (mandatory). Defaults to the current period starting date.
Transaction Date To: enter the ending transaction date (mandatory). Defaults to the current period ending date.
Organization Code: enter the specific inventory organization(s) you wish to report (optional). Defaults to your session's organization code.
Operating Unit: enter the specific operating unit(s) you wish to report (optional).
Ledger: enter the specific ledger(s) you wish to report (optional).

/* +=============================================================================+
-- | Copyright 2010 - 2024 Douglas Volz Consulting, Inc.
-- | All rights reserved.
-- | Permission to use this code is granted provided the original author is
-- | acknowledged. No warranties, express or otherwise is included in this permission. |
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected])
-- |
-- | Program Name: xxx_rcv_activity_rept.sql
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 6 Jan 2010 Douglas Volz Initial Coding
-- | 1.1 05 Apr 2010 Douglas Volz Added PO number, PO Distribution id to query
-- | 1.2 25 Oct 2017 Douglas Volz Now use the receiving parameter Receiving ccid
-- | and added transaction source.
-- | 1.3 13 Mar 2018 Douglas Volz Added Ledger parameter
-- | 1.4 08 Jul 2022 Douglas Volz Multi-language tables for item master.
-- | 1.5 24 Jun 2024 Douglas Volz Remove tabs, reinstall parameters and inventory org access controls.
-- | 1.6 16 Oct 2026 Andy Haack One row per subledger journal line with the receiving transaction columns.
-- | 1.7 21 Oct 2026 Mrugesh Poojary Quantity and UOM columns.
-- +=============================================================================+*/

SQL 229 lines

Parameters 6

ParameterTypeList of values SQL
Transaction Date FromDate
rt.transaction_date>=:p_trx_date_from and
rrsl.transaction_date>=:p_trx_date_from
Transaction Date ToDate
rt.transaction_date<:p_trx_date_to+1 and
rrsl.transaction_date<:p_trx_date_to+1
Organization CodeLOV
mp.organization_code=:p_org_code
Operating UnitLOV
haouv.name=:p_operating_unit
LedgerLOV
gl.name=:p_ledger
Unbalanced Distributions OnlyLOV Oracle
round(x.net_amount,3)<>0