Macola Forum :: Topic: Shop Floor Material Returns (1/1)

Welcome, Guest

TOPIC: Shop Floor Material Returns

jreppert OFFLINE Senior Boarder Posts: 68 Thank you received: 1 Karma: 0	I'm trying to write a report for material returned from a Shop Floor order. What table has this info? Is this in the Inventory Transaction table (as opposed to somewhere in SF)? THANKS!
	The administrator has disabled public write access.

dgillz OFFLINE Platinum Boarder Posts: 395 Thank you received: 14 Karma: 6	Yes this is in the iminvtrx_sql table. Look for source = 'S' and doc_type='R' transactions. A good way to determine this is to log into a test database and enter several issues, returns and receipts, then query the iminvtrx_sql to see how to discern returns from issues and receipts.
	www.gainfocus.biz Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports. The administrator has disabled public write access.