Welcome, Guest
Username: Password: Remember me

TOPIC: Shop Floor Material Returns

Shop Floor Material Returns #2711

  • jreppert
  • jreppert's Avatar
  • 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.

Shop Floor Material Returns #2712

  • dgillz
  • dgillz's Avatar
  • 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.
Time to create page: 0.024 seconds
Powered by Kunena Forum  Protected by R Antispam