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 Server Error 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.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the General Ledger workcenter go to the Journal Entries - Journal Entry Vouchers view.
- Press New ->Journal Entry Voucher for Sales from Microsoft Excel.
- In the SAP Business ByDesign tab press Logon to log in.
- Maintain the data for all mandatory fields (*).
- Enter other necessary data, such as Sales Document IDs, item IDs, project tasks.
- 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
- Mandatory fields are maintained with empty values. - 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 Liabilities 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;
- Leave no mandatory field with empty values;
- 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
00088; 633;634; sales doc. type, sales doc. ID, sales doc. Item ID, sales document, customer project, cost object missing, journal entry voucher for Ssales from Microsoft Excel, , KBA , cost and revenue type missing , journal entry voucher for sales excel , journal entry voucher sales upload , SRD-FIN-GL , General Ledger , How To