C.05 - Goods received (no invoice) to GL
This workflow determines whether goods received but not invoiced are recorded in the correct GL accounts. The Goods Receipt/Invoice Receipt (GR/IR) account is a G/L account used to accrue for goods received. When an invoice is received it is posted to the GR/IR account. At this point, the invoice should clear the goods receipt entry (Debit GR/IR) and credit the vendor’s accounts (A/P).
Unmatched items can occur in the GR/IR clearing accounts due to quantity differences between the invoice posted and the purchase order. The GR/IR balances should be reviewed regularly to ensure that unmatched items are cleared in a timely manner.
The workflow reads table T030U (Account Determination for Balance Sheet Transfer Postings) to obtain a list of accounts where the column values match the following conditions:
-
The KTOPL (chart of accounts) column has the value INT (user defined).
-
The KTOSL (transaction key) column has the value GNB (delivered but not yet invoiced).
The SKB1 table is accessed to obtain the auto posting indicator setting for each account for accounts that have the specified company codes. The SKAT table is accessed to obtain account description details.
The account results are stored in the Results_C05 Table dataset, which has the following columns:
| Column | Description |
|---|---|
| MANDT | Client. |
| KTOPL | Chart of accounts. |
| BWBER | Valuation area for FI year end closing. |
| KTOSL | Transaction key. |
| HKONT | Account to be adjusted. |
| KORRK | Adjustment account. |
| ZIELK | Target account. |
| BUKRS | Company code. |
| XINTB | Auto posting indicator. |
| TXT50 | Account description. |
Creating RFC Destinations
Before you begin, you will need to create an RFC Destination for the SAP system you wish to analyze.
Preparing the Workflow
To prepare the C.05 - Goods received (no invoice) to GL workflow, drag its workflow template from the Templates folder into your own workspace, and modify the workflow as follows:
To specify the system to analyze:
-
Select the System to Audit parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.
-
Select the RFC Destination for the system to analyze, then click ‘Save’.
To specify a range of company codes:
-
Select the Define Company Code parameter and choose ‘Edit Select List’ from its context menu to display the Select List Editor dialog.
-
Modify the selection criteria to create your own specifications for the BUKRS field. See the Select List Parameters help topic for details.
Save the workflow using the ‘Save’ toolbar button.
Running the Workflow
To run the C.05 - Goods received (no invoice) to GL workflow, click the ‘Run’ toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select the Results_C05 dataset and choose ‘View Details’ from the context menu to display the result table.