Symptom
Upload fails in App 'Upload Customer Open Items'. The following errors occur in the Log:
- An error occurred. Please create an case on component FI-FIO-AR.
- System can not calculate cash discount base amount, please enter it.
- Parameter has invalid value: Parameter IV_VALUE has invalid value DDMMYYYY. or Property 'InvoiceDate' has invalid value DDMMYYYY.
- A/c & requires a revenue-based account assignment relevant to cost accounting.
- Withholding tax is not supported for this business process.
- Failed to set a background job to check or post the selected items.
- For G/L account & entry for house bank/account required.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Enter App 'Upload Customer Open Items'.
- Upload the excel file.
- The upload fails due to above mentioned errors.
Cause
- Incorrect filling of tax lines in the upload excel file.
- Incorrect filling of debit/credit indicator in the upload excel file.
- Incorrect format of Document Date (INVOICEDATE) in the upload excel file.
- Controlling (CO) account assignment object for the G/L account is missing.
- The app does not support calculating and posting withholding tax.
- Document type entered to upload file has external document number range maintained.
- Incorrect G/L Account entered in upload excel file in G/L Account section.For example the G/L Account used is a bank reconciliation account.
Resolution
- 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.
- 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.
- 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.
- 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.
- 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.
- Document types with external document number range are not supported by the app.
- The app is for customer invoice posting. Payment or payment clearing related cash accounts are not accepted. Use P&L accounts instead.
See Also
Keywords
Upload Customer Open Items, tax amount, gross, item amount, AMOUNTINTRANSACTIONCURRENCY, F4051, F4 051, IV_VALUE, Document Date, INVOICEDATE, withholding tax, external number range, document type, F1520, account assignment, house bank, bank reconciliation, cash account , KBA , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , Problem
Product
SAP S/4HANA Cloud Public Edition all versions