SAP Knowledge Base Article - Public

3310073 - Several errors in App Upload Customer Open Items - SAP S/4HANA Cloud Public Edition

Symptom

Upload fails in App 'Upload Customer Open Items'.

  1. "An error occurred. Please create an case on component FI-FIO-AR."
  2. "System can not calculate cash discount base amount, please enter it"
  3. Parameter has invalid value: Parameter IV_VALUE has invalid value DDMMYYYY. or Property 'InvoiceDate' has invalid value DDMMYYYY.
  4. "A/c & requires  a revenue-based account assignment relevant to cost accounting"
  5. "Withholding tax is not supported for this business process"

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Enter App 'Upload Customer Open Items'.
  2. Upload the excel file.
  3. The upload fails due to above mentioned two errors.

Cause

  1. Incorrect filling of tax lines in the upload excel file.
  2. Incorrect filling of debit/credit indicator in the upload excel file.
  3. Incorrect format of Document Date (INVOICEDATE) in the upload excel file.
  4. Controlling (CO) account assignment object for the G/L account is missing.
  5. The app does not support calculating and posting withholding tax.

Resolution

1. The application is not supporting manually input tax. For "Item Amount" (Technical name: AMOUNTINTRANSACTIONCURRENCY) enter the gross amount to post to the G/L account. The system calculates the taxes automatically during checking or posting based on the tax code. 

2. Check that you entered the correct value in Debit/Credit field.  If the item is a credit, but you entered 'S' or the item is debit and you entered 'H' by mistake the upload fails.

3. Please use the date format used in your operating system. For example, if the date format of your operating system is MM/DD/YYYY, then you need to use this format when entering dates in the template.

4. Specify a Controlling (CO) account assignment object for the G/L account. Possible account assignment objects include cost center, WBS element, profitability segment, and so on.

5. If you've maintained withholding tax information in the master data of a customer, do not use this app to post the corresponding customer open items.

See Also

Upload Customer Open Items

Upload Customer Open Items - Default Fields in the Template

Upload Customer Open Items: FAQ

Keywords

Upload Customer Open Items, tax amount, gross, item amount, AMOUNTINTRANSACTIONCURRENCY, F4051, F4 051, IV_VALUE, Document Date, INVOICEDATE, withholding tax , KBA , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , Problem

Product

SAP S/4HANA Cloud 2302