Question

BR - Aging Report

  • 4 August 2021
  • 4 replies
  • 372 views
R
Rank
Userlevel 7
Badge +16
  • ronhu
  • Hero (Customer)
  • 547 replies

almighty community,

 

i am trying to build an inventory aging report using IFS Business Reporter. i am trying to use Receipt Date this column in Inventory Part in Stock window as a calculation base. 

 

but i cannot find this field any where in below 3 data sources.

  1. Inventory Transaction History
  2. Inventory TurnOver
  3. Total Inventory Value

kindly advise.

 

Thank you.

Ron
This topic has been closed for comments

4 replies

Dilmi Gunasiri
Rank
Userlevel 5
Badge +7

Hi @ronhu,

If it is not available under existing information sources, you will have to create an IAL to fetch that value. From the IAL created you can then create a quick information source so that newly added quick information source can be used to create the report.

 

https://wit.ifsworld.com/f1docs/apps10upd7/Foundation1/040_administration/255_br_and_a/010_Information_Sources/060_Quick_Info_Source_Drafts/120_qis_functionality.htm

 

Regards,
Dilmi. 

V
Rank
Userlevel 4
Badge +8

Hi,

It is not necessary to create a IAL and quick information in this case. It is possible to add the item as a custom attribute to dimension or fact (information source). 

Please check below links for more information. 

IEE

https://docs.ifs.com/techdocs/Foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/010_Custom_Attr_Info_Src/default.htm

 

Aurena

https://docs.ifs.com/techdocs/Foundation1/045_administration_aurena/255_br_and_a/010_Information_Sources/055_custom_objects/010_Custom_Attr_Info_Src/default.htm

 

Webcast - Information Source Customization
https://web.microsoftstream.com/video/18f1d5c1-07bd-497f-931b-131fcae5fa45?channelId=2b438332-bbf4-4b39-931f-421fcd892a75

 

Demo - Information Source Customization

https://web.microsoftstream.com/video/cab5a5e4-8b5d-45c4-befc-4487ed911d51?channelId=2b438332-bbf4-4b39-931f-421fcd892a75

 

Go for IAL and quick information source options in complex cases where it is not possible to customize information source using above options.

 

Best regards,

Voshitha

Voshitha
R
Rank
Userlevel 7
Badge +16

@Dilmi Gunasiri 

@Voshitha 

 

Appreciated your prompt reply. will try.

 

Thank you.

Ron
R
Rank
Userlevel 7
Badge +16

@Voshitha thank you for the link you provide. i pretty much like the webcast and demo, but unfortunately, these videos are within IFS network, and not open to customer.

 

Thank you.

Ron

Ron
Terms & ConditionsCookie settings