Account Determination Group by Product

[Former Member]

Dear all,

Is there a way to list out the account determination group(and the respective G/L account) by Product in Business byDesign?

Actually, I am trying to pull the outstanding PO by product and by account determination group to form a report.  Is there a way to do that?

Thanks in advance!

Norine

[Former Member]

Hi Norine,

Unfortunately there is no such report as standard on ByD system.

You can create your own report by going at:
1. Business analytics work center
2. Data Sources view.
3. Design Data Sources

Kindly make use of the Data Source for instace FININVU01 to create the report. This DS will have 3 fields G/L account, Account Determination Group & Product Category ID

Thanks
Lokesh Sharma

[Former Member]

Hi Lokesh

Thanks for your prompt reply. 

Too bad that in our current setting, the Account Determination Group is based on Product rather than the Product Category. The Data Source, FININVU01, does not have the required information.

Thanks and regards,

Norine