On Wed, 2013-09-25 at 07:46 -0700, Chris Travers wrote:
>
>
>
> On Wed, Sep 25, 2013 at 7:27 AM, DDT <410845...@qq.com> wrote:
> By the way, you can try to save the current totals to another
> table.
> update it through triggers when the inventory transactions
> c
On Wed, Sep 25, 2013 at 7:27 AM, DDT <410845...@qq.com> wrote:
> By the way, you can try to save the current totals to another table.
> update it through triggers when the inventory transactions changed.
> it may lead to better performance on a large set of inventory transactions
> for query curre
Support at it's finest.
Thinking maybe ALLOCATED transactions zero out
when the allocated qty is shipped, but I would like to save
the original allocated qty..maybe add another field in my
transaction table to save the allocated transaction qty.
Also don't see any problem with deleting the ALLOCAT
