Item Ledger -
Hi,
We have a requirement to generate a Stock Ledger Report in the below Format.
ItemNo | Description | Open Qty | Received Qty | Write Off | Adjustment Qty | Closing Qty | On Hand |
---|---|---|---|---|---|---|---|
But every time for getting the Open Qty for a particular date we need run the F4111 table from the starting of the ERP till that given date to calculate the opening which is taking a lot of server processing time.
Is there another way or option to get the Open Qty for a particular Date or any BSF which can get me the Opening qty for a particular date.
JDE 8.11 SP1