Oracle Fusion SCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to create a report with Opening,Closing,Inbound and Outbound stock?

Accepted answer
34
Views
2
Comments
KashifRaza
KashifRaza Rank 1 - Community Starter

I want to create a report like below format, but as Inbound and outbound qty change whenever a new entry hit, so i'm unable to achieve it datewise or you could say a Static record for a specific day. and same for Opening and closing balance.

If someone have done this before please do let me know. Thanks in advance

Best Answer

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    Answer ✓

    Hello @KashifRaza

    We have a Prebuilt Analyses in FDI called “Current Inventory Balances Analysis” which provides insight on current Inventory balances, Quantity in Receiving, Inbound quantity, In-transit, and Consigned quantity. Please check if it helps.

    https://docs.oracle.com/en/cloud/saas/analytics/24r2/fascm/chapter-prebuilt.html#GUID-65253E0C-A6FD-4C7E-9ED3-56650B98F6A9

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @KashifRaza - Please let us know if you are using FDI or OTBI. Additionally, specifying which subject area you are referring to would help us guide you further. Thank you.