3329524 - Data Extraction - Open Items Receivable / Payables

Key notes for Data Extraction for OPEN_ITMS_RECEIVABLE - Open Items Receivable & OPEN_ITMS_PAYABLE - Open Items Payable.

SAP Business ByDesign

1. Go to Application and User Management work center. 
2. Click on Data Extraction view.
3. Click New.
4. Select Extraction Object - OPEN_ITMS_RECEIVABLE - Open Items Receivable or OPEN_ITMS_PAYABLE - Open Items Payable. 

Below are the key notes to consider after performing Data Extraction for Open Items Receivable & Open Items Payable:

1) Fields with Zero Amount: For any non-mandatory field If any field is having zero value, then the system is keeping as blank. For example - Cash Discount Relevant field. If there is 0,00 amount in Cash Discount then the field is blank.

This applies to all sheets - Open Items, Tax Data and Withholding Tax Data.

For any mandatory field, If any field is having zero value, then the system is fetching same as zero and not making it blank. Since ByD migration tool expects some value in a mandatory field. For example, in the data extraction excel you can find the Tax Amount as ‘0’, Tax Rate as ‘0’.

2) Cash Discount Gross Amount and Cash Discount Net Amount: If an open item is cash discount relevant, then the system fetches both Cash Discount Gross Amount and Cash Discount Net Amount. This applies to Open Items sheet.

Note - ByD migration tool don’t expect both Cash Discount Gross Amount and Cash Discount Net Amount to be passed. During migration of extracted file to ByD system one of the values should be removed manually. Also, ByD migration tool will give error, if Transaction Amount is less than Cash Discount Gross Amount.

3) Negative values: During data extraction the system is fetching all Amount as positive Amount. If any Amount is -ve then the system is converting to +ve Amount during extraction.This applies to all sheets - Open Items, Tax Data and Withholding Tax Data.

4) Tax Jurisdiction Code for Tax Country US: At the time of data extraction, the tax data sheet is aggregated based on lowest level tax jurisdiction code level.This applies to Tax Data sheet. For example:

• If we have two records with Tax Jurisdiction Code as OH and OH XX then both these records will be aggregated on lowest level tax jurisdiction code i.e OH XX will appear in the Tax Jurisdiction Code.
• If we have three records with Tax Jurisdiction Code as OH, OH XX and OH XX YY, then all three records will be aggregated on lowest level tax jurisdiction code i.e OH XX YY will appear in the Tax Jurisdiction Code.

Note - The Tax Amount will be aggregated for all the Due Categories.  For example, in the below screenshot, there are two line items in the Due Category. After performing Data Extraction, you can find the aggregated Tax Amount = 6.25 USD.

In the extracted excel the same appears as below:

5) Tax data handling for India and Mexico: 

• If product split line items have record with different Tax Net Base Amount scenario for example, Tax on Tax scenario for India as shown below, then no aggregation is applied on such product items. Instead, all tax split line items will be fetched as it is in data extraction excel.
  
• The same data appears in the excel as below:
  
  

• In case any performance issue occurs due to the different Tax Net Base Amount, then switch mechanism can be enabled from backend. In this case, all tax register split line items entries for country India and Mexico will be fetched as it is without any aggregation logic irrespective of any scenario.To Enable switch you have to Report an incident and mention this KBA.
  
  

6) Tax data handling for reverse charge case: No aggregation logic will be applied for reverse charge case for any applicable country. If any reverse charge case has multiple tax split line items, then only record with Due category ‘Payables’ will be considered for extraction. Record with Due category ‘Receivables’ will be ignored.

The same data appears in the Tax data sheet as below post extraction:

This is specific to Tax Data sheet.

Below are the key notes specifc to Data Extraction for Open Items Payable only:

1) Line-item id fix in withholding tax: Every Withholding Tax entry will be mapped to its corresponding tax register entry. This mapping can be found with line items id values.

2) Withholding tax data: The system is fetching Withholding Tax data as it is without any aggregation or any calculation logic.

Data Extraction - Open Items Receivable, Data Extraction - Open Items Payables , KBA , SRD-FIN-ACP , Payables , SRD-FIN-GLO-TAX , GLO - Tax Declaration , SRD-FIN-ACR , Receivables , Product Enhancement