SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SAP Business By Design

Reproducing the Issue

  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.

Cause

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.

Resolution

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.

Keywords

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

Product

SAP BUSINESS BYDESIGN 1808 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805