Skip to Content
Former Member
May 12, 2011 at 07:28 PM

Need tables for tracking Invoice Items back to the Batch Numbers/Item codes


Trying to build report to show the Inventory movement from a Sales Invoice Item back to the source items and the Batch Numbers for assigned along the way. Having problems finding all the tables to connect the Batch information to the Invoice information.

In B1 under batch management I can see fields that belong to tables RBTN, RITL and OBTN but I can only find OBTN in Crystal.

Are these tables hidden for some reason or are they Temporary tables that B1 creates when opening the form/report.