I recently joined a company using Pastel, a lot of there reporting is done by running exports or other reports and then punch that into Excel. I want to write macros to automate this, but don't understand the structure of the tables. I can't seem to get the qty on hand from the multistore or inventory tables. Does Pastel calculate the qty on hand from transactions tables or by some other means?
I basically need the qty on hand, sales order qty and PO qty's. Where can I find these figures or how must they be calculated?