Hi all,
My customer wanted to update his HQ and SO quantities to zero, i wrote him a query which was UPDATE item SET quantity = 0 WHERE quantity 0
up to now everything was ok, all quantities in Hq and stores were Zero. i did also worksheet 501 and 190 and everything was ok too, but today he came back to me and told me that, the quantities returned back to the previous records....
Can Anyone help me in that please ? i keep on facing this problem and i never get a solution for it.. Thanks in advance