You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Tax Registration from Supplier Address out of Supplier Real Time OTBI

Accepted answer
24
Views
3
Comments
edited Jul 1, 2020 3:47AM in Reporting and Analytics for ERP 3 comments

Summary

Looking for Supplier's Tax Registration Linked to Address

Content

I'm building a supplier report inside the Supplier - Supplier Real Time subject area and attempting to pull the Tax Registration Number from the supplier's address. However the only Tax Registration field available is pulling the value from the profile's tax registration, *not* the address, which is more specific and could vary depending on which office the supplier is using. Is this field accessible from OTBI? 

 

 

Code Snippet

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Supplier - Supplier Real Time"."- Income Tax"."Tax Payer ID" s_1,
   "Supplier - Supplier Real Time"."- Income Tax"."Tax Registration Number" s_2,
   "Supplier - Supplier Real Time"."- Income Tax"."Withholding Tax Group" s_3,
   "Supplier - Supplier Real Time"."- Procurement BU"."Default Legal Entity Name" s_4,
   "Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Name" s_5,
   "Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Number" s_6,
   "Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Type" s_7,
   "Supplier - Supplier Real Time"."- Supplier
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!