Symptom
You are creating invoices via WebDav, on the excel, you fulfill the external reference field, but when you release the Invoice document, the external reference is changed for the invoice ID.
Environment
SAP Business ByDesign.
Reproducing the Issue
First, you would need to use the excel to create your WebDav invoice with the external reference fulfilled.
After creating your invoice, schedule the run to upload your invoice document into the system.
-
Go to the Application and User Management work center.
-
Select the File Input view.
-
Select your Run and click on the Schedule button.
-
Select the option Start Immediately.
Now, you need to check if the invoice document has been uploaded
-
Go to the Customer Invoicing work center.
-
Select the Invoice Requests view.
If you see the Invoice Request list, it has been uploaded as expected.
Once the invoice has been uploaded, you need to release it.
-
Go to the Customer Invoicing work center.
-
Select the Invoice Requests view.
-
Select the Invoice Request ABC (ABC represents your Invoice Request ID).
- Click on Edit button and View All button.
- Note that the external reference has the information which you've entered on the excel.
-
Click on the Release button.
-
Select the Invoice Document ID and copy it.
Now it's necessary to check if the external reference has been overwritten.
- Go to the Customer Invoicing work center.
- Go to the Invoice Documents view.
- Search for the Invoice Document ID DEF (DEF represents your Invoice Document ID).
- Note that the external reference has the Invoice Document ID instead the information which you've entered.
Cause
The external Reference is being overwritten due a Business Configuration set.
Note that the Determination Method is maintained as Copied from Own ID which means that the system going to copy the ID from the Invoice document and going to overwrite the External Reference information.
This is the reason why the system behaves like that.
Resolution
To fix this scenario, you'd need to change the Determination Method from Copied from Own ID to Copied from Predecessor Reference ID and then, the system going to respect the information maintained on External Reference.
- Go to the Business Configuration work center.
- Select the Implementation Projects view.
- Click on Open Activity List button.
- Search for the activity External Reference Number Determination for Customer Invoice.
- Open this activity.
Here you can change the Determination Method from Copied from Own ID to Copied from Predecessor Reference ID.
Keywords
WebDav; External Reference; Invoice , KBA , SRD-CRM-INV , Customer Invoicing , How To