alanmacc
Member
Hi Guys,
I am looking a running balance cardex in JDE if there exists such a thing, the current cardex contains (but not limited to)
Document Number
Doc Type
Transaction date
Branch Plant
Quantity
Cost
Extended cost
....... Ect.
However the balance only shows in the header level as quantity on hand, meaning if you are required to trace back this can be lengthy and tedious to troll through several hundred / thousand lines until the reach the first entry which can them allow you to track the balance.
We have a macro script on excel to carry out this function but that in itself can be problematic.
Is this type of historical tracking available in JDE, In my mind it would look something like
item
doc type
transaction date
quantity
balance
cost
extended cost
.... et all
Im sure this must have been asked at some point to oracle ??
Thanks in advance
Alan
I am looking a running balance cardex in JDE if there exists such a thing, the current cardex contains (but not limited to)
Document Number
Doc Type
Transaction date
Branch Plant
Quantity
Cost
Extended cost
....... Ect.
However the balance only shows in the header level as quantity on hand, meaning if you are required to trace back this can be lengthy and tedious to troll through several hundred / thousand lines until the reach the first entry which can them allow you to track the balance.
We have a macro script on excel to carry out this function but that in itself can be problematic.
Is this type of historical tracking available in JDE, In my mind it would look something like
item
doc type
transaction date
quantity
balance
cost
extended cost
.... et all
Im sure this must have been asked at some point to oracle ??
Thanks in advance
Alan