Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

Generate a report to get the list of Products without customer through SEI

Posted By Shivam Rajput over 5 years ago

Dear All,

I am facing some problem to generate a report through sage enterprise intelligence.

I want information from the report is 'product without customer' but when i apply criteria/filter to the customer i.e. 'customer code=null', the output of the report is blank, not a single product is listed in the report whilst there are many products with out customer available in SAGE.

Table Used:-

ITMBPC(FACT table)

ITMMASTER

BPCUSTOMER

Please suggest how can i resolve this problem.

0 FrankBernal over 5 years ago

Shivam,

I know you are asking for an SEI solution, but you may want to take a look at VEN027 Graphical requester as it may provide you with the information you are looking for.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shivam Rajput over 5 years ago in reply to FrankBernal

Hi Frank,

Thanks for the revert on my query, Can you please advise me the criteria/formula that should apply to get the list of Products with out customer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 FrankBernal over 5 years ago in reply to Shivam Rajput

I am not a programmer, but what you want is a list of the products where a record does not exist in the Customer product table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Generate a report to get the list of Products without customer through SEI

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING