Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Invoice Filter does not work. Please review and provide any suggestion for this OTBI code.

edited Feb 22, 2023 8:22PM in Reporting and Analytics for ERP 3 comments

Summary:

Invoice id Filter does not work. Please review and provide any suggestion for this OTBI code.

Content (required):

OTBI

Version (include the version you are using, if applicable):

22D

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT 

  v_0 saw_0,

  v_1 saw_1,

  v_2 saw_2,

  v_3 saw_3,

  v_4 saw_4,

  v_5 saw_5,

  v_6 saw_6,

  v_7 saw_7,

  v_8 saw_8,

  v_9 saw_9,

  v_10 saw_10,

  v_11 saw_11,

  v_13 saw_12,

  v_14 saw_13,

  v_15 saw_14,

  v_16 saw_15,

  v_17 saw_16,

  v_18 saw_17,

  v_19 saw_18,

  v_20 saw_19,

  v_21 saw_20,

  u_1 saw_21,

  u_2 saw_22

 FROM (SELECT 

  "- General Information"."Invoice Number" v_0,

  "- Invoice Distribution Details - General Information"."Distribution Line Number" v_1,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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