Categories
How to create a report with Opening,Closing,Inbound and Outbound stock?
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
-
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
0
Answers
-
@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.
0 -
Same question for Netsuite Analytics Warehouse (NSAW)
0 -
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.
0
