Import excel service entry sheet with account assignment error.

[larissacandelorio]

Hello,

I'm trying to import a service entry sheet filled on the excel standar template, but it keeps returning the message Service entry sheet Account item 00001: account assignment definition not allowed, even though I already created another service entry sheet on the app using the same information, just changing the number of the PO.

It's my first time trying to import from the template. I used the help portal to fill it, but it keeps returing this message and I'm not sure which field is wrong. Does anyone know this error?

Thanks in advance!

[OwenLiu]

Removed tags other than Procure.

Suggest you read below Blog for tips of getting your answers faster:

Q&A for SAP S/4HANA Cloud Public Edition - How to ... - SAP Community

[HenrikeGrtecke]

Hello,

Thank you very much for your question and sorry for the late reply.

Can you please check whether the following information (GenAI was used to help generate this content) solves your issue?

The ‘Invoice Receipt Date’ field in the Create Supplier Invoice application is a new addition that can affect various aspects of invoice processing. Here are some potential impacts:

1. Tax Calculation: The receipt date might be used to determine the applicable tax rates if time-dependent taxes are active. This can influence the tax determination process.

2. Exchange Rate Determination: The receipt date could be used as a reference for determining exchange rates, especially if the translation date differs from the posting date.

3. Workflow and Approval Processes: Changes to the ‘Invoice Receipt Date’ might trigger workflow processes, especially if the date is relevant for approval conditions.

4. Reporting and Analytics: The receipt date can be used in procurement analytics to track and report on invoice processing timelines.

5. Compliance and Audit: Accurate recording of the receipt date is crucial for compliance and audit purposes, ensuring that invoices are processed within the stipulated time frames.

Overall, the ‘Invoice Receipt Date’ field adds an additional layer of detail that can enhance the accuracy and efficiency of supplier invoice management.

Kind regards,

Henrike

[HenrikeGrtecke]

Hello,

Thank you very much for your question and sorry for the late reply.

Can you please check whether the following information (GenAI was used to help generate this content) solves your issue?

When importing a service entry sheet using the Excel template, encountering the error message ‘Service entry sheet Account item 00001: account assignment definition not allowed’ can be frustrating. Here are some steps to help you resolve this issue:

1. Check Account Assignment Category: Ensure that the account assignment category in your template matches the one used in the purchase order. If the purchase order has an unknown account assignment, you need to specify it in the template.

2. Verify Mandatory Fields: Make sure all mandatory fields marked with an asterisk (*) in the template are correctly filled. This includes fields like ‘Header ID’, ‘Item ID’, and ‘Acct Assmgt ID’.

3. Review Conditional Fields: Some fields are conditionally required, marked with two asterisks (**). Ensure these are filled based on the conditions specified in the template instructions.

4. Check for Multiple Account Assignments: If your purchase order allows multiple account assignments, ensure that the template reflects this by setting the ‘has multiple Account Assignments’ field to TRUE.

5. Format Consistency: Ensure that the format of the template matches the requirements, such as date formats (YYYYMMDD) and character limits.

6. Consult the Help Portal: The SAP Help Portal provides detailed instructions Example: Importing Service Entry Sheets from Microsoft Excel Files on how to fill the template correctly. Double-check your entries against these guidelines.

If you continue to face issues, consider checking the app ‘Monitor Service Entry Sheet Generation Log’ for more detailed error messages that might help pinpoint the problem.

[1] Example: Importing Service Entry Sheets from Microsoft Excel Files

Kind regards,

Henrike