2644523 - Petty Cash Journal Export Does not ShowOutgoing and Incoming Cash Payment Columns

You are trying to Export Petty Cash Journal to an Excel and the excel does not contain the Outgoing Cash Payment and Incoming Cash Payment column.

SAP Business By Design

1. Go to the Payment Management Work center.
2. Go to the Petty Cash view.
3. Show All Petty Cash and Search for Petty Cash ID XYZ(XYZ represents Petty Cash ID).
4. Select the Petty Cash ID and Choose view.
5. In the Petty Cash Journal,Choose Export To Microsoft Excel.

The Excel that is exported do not contain Incoming/Outgoing Cash Payment.

In the new HTML5 UI, there is a separate column for Incoming/Outgoing Cash payments that needs to be added through the personalization mode. When this column is added, the corresponding data would be copied over to the exported excel that is generated.

SAP currently supports a feature to display the Incoming and Outgoing cash in a single column in the excel that is exported.

1. Go to the Payment Management Work center.
2. Go to the Petty Cash view.
3. Show All Petty Cash and Search for Petty Cash ID.
4. Select the Petty Cash ID and Choose view.
5. In the Petty Cash Journal Screen,Go to Personalization mode.
6. Go to Unnamed table and Select the checkbox for Outgoing/Incoming Cash Payment.

Once this is done,the Excel export contains a column Outgoing/Incoming Cash Payment and you can use Transaction type for distinguishing Incoming and Outgoing Cash Payments.

Petty Cash Export,Incoming Cash Payment ,Outgoing Cash payment. , KBA , incoming cash payment , outgoing cash payment , petty cash journal export , SRD-FIN-MOP , Payment Management , Problem