Hello, Am looking to find the table thats stock status report uses to provide stock status on a given day for a part.
Looking at the data definition StkStatus used by the repot, it uses 2 tables called StkActivity & StkPart.
Any idea what these are and how to extract info.
Thanks,
Kiran
I don't think there is a table that you can access to pull stock quantities for a particular time. I think the stock status report takes current values and adds and subtracts transactions back to date given for report. If you want something d with different options I think you would have to follow the same methodology.
You can use Erp.PartTran table to “reverse” transactions back from the current quantities in Erp.PartWhse table. You have to reverse engineer logic for each TranType though. We’ve tried that and it works now, but with each upgrade we have to re-evaluate and re-validate the whole logic again and again ...
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.