SAP Knowledge Base Article - Public

2002909 - Journal Entry Voucher for Sales from Microsoft Excel Upload Errors

Symptom

You try to upload journal entry voucher for sales from Microsoft Excel.  But when you click Save Data to in the Excel template either a (500) internal or more specific messages appear, such as

  • Warning: Sales Document or Customer Project or Cost Object missing; Action POST not possible; Action deactivated.
  • Warning: Cost revenue type missing; Action Post not possible; action is disabled.

Reproducing the Issue

  1. In the General Ledger workcenter go to the Journal Entries - Journal Entry Vouchers view.
  2. Press New ->Journal Entry Voucher for Sales from Microsoft Excel.
  3. In the SAP Business ByDesign tab press Logon to log in.
  4. Maintain the data for all mandatory fields (*).
  5. Enter other necessary data, such as Sales Document IDs, item IDs, project tasks.
  6. Press Save data to

Possible Error Messages:

  • (500) Internal Server Error
  • Warning: Sales Document or Customer Project or Cost Object missing; Action POST not possible; Action deactivated.
  • Warning: Cost or Revenue type missing; Action POST not possible; Action is deactivated.

Cause

  •  (500) Internal Server Error
    - The sales document type is not maintained for all items
  • Warning: Sales Document or Customer Project or Cost Object missing; Action POST not possible; Action deactivated.
    - The sales document id and sales document item ID is not maintained for all items
  • Warning: Cost or Revenue type missing; Action POST not possible; Action is deactivated.
    You try to transfer amounts for a sales document from a G/L account of type REVGAN- Revenue or Gains or COSEXP- Cost or Expense  to an account of type OLIAB-Other Liabilites for which the G/L account (origin) needs to be entered.

Resolution

In order to successfully upload the journal entry voucher into the system, you need to

  • enter the sales document type for all items
  • enter the sales document ID and sales document item ID for all items
  • enter a G/L account (Origin) of the original sales revenue account for postings to G/L accounts of type OLIAB- Other Liabilities*

*If you post to Deferred Cost or Deferred Revenue accounts then maintain the actual expense or revenue accounts in the G/L account (Origin) field. If directly post to expense or revenue accounts the G/L Account (Origin) will be derived automatically.

This way the upload will work.

Keywords

KBA , cost and revenue type missing , journal entry voucher sales upload , journal entry voucher for sales excel , SRD-CC , Cross Components , How To

Product

SAP Business ByDesign all versions