Skip to main content
Question

BR - Aging Report


Forum|alt.badge.img+16
  • Hero (Customer)
  • 611 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.

This topic has been closed for comments

4 replies

Dilmi Gunasiri
Hero (Employee)
Forum|alt.badge.img+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. 


Forum|alt.badge.img+8
  • Hero (Employee)
  • 59 replies
  • August 5, 2021

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


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • 611 replies
  • August 5, 2021

@Dilmi Gunasiri 

@Voshitha 

 

Appreciated your prompt reply. will try.

 

Thank you.


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • 611 replies
  • August 5, 2021

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings