Pastel - Which table stores inventory quantities

[Zaz]

Hey Guys

I'm quite familiar with the ins and outs of pastel and the reporting portion of it.

But something that baffles my mind is how pastel determines inventory quantities on hand... if someone could shed some light or insight on this I'd be greatly appreciative...

I'm assuming it looks at various tables and calculates based on various parameters.

Anyone know how this magic software works it's hokispokis?

 

[Navie]

Hi Zaz

I have the same problem. Did you manage to find out how pastel determines quantity on
hand and from which tables.
I have looked at MultiStoreTrn table and the OpenQty field quantity is not
what is reflected in the pastel program activity screen for that itemcode.

Will really appreciate any help I can get.
regards
Navie

 

[Navie]

Solution found here
http://www.theforumsa.co.za/forums/...tel-Partner-to-MySQL-website/page3?styleid=19