SAP Knowledge Base Article - Public

2870124 - Upload Manual Tax Entry: Assignment to Sales Order is Not Permitted

Symptom

You cannot upload manual tax entries via Excel due to the following error message:

"Assignment to Sales Order is Not Permitted."

Or

"The following Error(s) occurred while saving data:
The underlying connection was closed: An unexpected error occurred on receive.
Total Number of Records Saved: 0."

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Login to the SAP Business ByDesign system.
  2. Open the Microsoft excel file, you want to upload.
  3. Navigate to the SAP Business ByDesign tab.
  4. Login to the ByDesign system via Microsoft excel.
  5. Click Save data to.

You get the error message:

"The following Error(s) occurred while saving data:
The underlying connection was closed: An unexpected error occurred on receive.
Total Number of Records Saved: 0."

  1. Click Ok.

You have another pop-up window with the following message:

"0 Record(s) saved successfully to SAP Business ByDesign."

  1. Click ok.

Or

You get the error message: "Assignment to Sales Order is Not Permitted."

Cause

In the excel file, when you select both Project Task and Sales Order references you have to choose the AccoutingCodingBlockTypeCode as PRO as system logic will determine it as SLS (sales order) which is not allowed to post according to the Business Configuration.

Assignment of sales order in a manual tax entry is not supported in Business ByDesign system.

As of now only the account assignment types ACC, CC, IMAT, PRFT and PRO are supported via manual tax entry.

You can see this setting under the following path:

  1. Go to the Business Configuration work center.
  2. Go to the Overview view. 
  3. Search and select the Account Assignment Types activity. 
  4. Click on the same to open it or Click Change Immediately.
  5. Click the Maintain Account Assignment Types link. 
  6. Search and select Account Assignment Type SLS. 
  7. Under Details, navigate to the Assignment to Business Transaction tab. 

The business transaction type 794 -Cash Flow Expense and Receipt Explanation is not assigned

Resolution

You need to add the following columns to the excel to solve the issue:

  1. SalesOrderItemId
  2. AccountingCodingBlockTypeCode

In the column AccountingCodingBlockTypeCode you enter the value as PRO.

PIC1.png

  1. Go to the Application and User Management work center.
  2. Go to the Microsoft Office® Template Maintenance subview in the Business Flexibility view.
  3. Search and select the "Manual Tax Entries Upload" template.
  4. Click Download.
  5. Open the Microsoft Excel file Manual Tax Entries Upload.
  6. Add in the columns SalesOrderItemId and AccountingCodingBlockTypeCode.
  7. Enter all the required data.
  8. In the AccountingCodingBlockTypeCode column, enter the value as PRO.
  9. Click Save.
  10. Navigate to the SAP Business ByDesign tab.
  11. Login to SAP Business ByDesign from Microsoft Excel.
  12. Click Save Data to.

The File is uploaded without any issues.

Keywords

manual tax entry upload; Manuelle Steuerbuchungen hochladen , KBA , SRD-FIN-TAX , Tax Management , How To

Product

SAP Business ByDesign all versions