nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

KashifRaza

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

Find more posts tagged with

Reporting

Oracle Fusion Analytics

Customizing Reports

Fusion SCM Analytics

Accepted answers

Ashish-Oracle

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

All comments

Sumanth V -Oracle

@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.

Ashish-Oracle

Hello @KashifRaza

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

Christian Postey

Same question for Netsuite Analytics Warehouse (NSAW)

User_XLK48

Since this is a report you'll be looking back on, If you make the inbound and outbound values correct at the closing balance, I predict, those numbers will also be the inbound and outbound for the following opening balance.