I am working on the Inv. Val. Report in a 3.10 database. When the report returns a Remaining Qty, I would like to report the serial number(s) of the item(s) related to the Remaining Qty field. I have added the Item Tracking Entry table as a dataitem indented under the Item Ledger Entry data item. I have tried several scenarios with the DataItemLink property of the Item Tracking table and have been unsuccessful. Anyone have any ideas?
If memory serves me right, the Item Tracking table is a “work” table and does not contain permanent data entries. Try looking at the Reservations table. You will have to choose the proper “Source Type” records. This is not an easy to use table.
Take a look at the Reservation Entry table, which is where these numbers are stored. To see how they are linked, just open the Item tracking entry form and see what the corresponding fields are. Then you can use these fields to link a new Reservation Entry dataitem to the other records you are reporting on.
hey guys, remember that 3.10 still had the item tracking entries seperately stored in the table item tracking entry. In higher versions the item tracking information is stored in the posted item ledger entries directly, the reservation entries are just intermediate before posting. Steve, if you mean report 1001, the qty. is calculated and printed summing up sum item ledger entries. the printout is done in a group footer. I think the only possibility to print the item tracking entries is to save them for each called item ledger entry to a temp table and print the content of that temp table in a integer dataitem below the group footer of the item ledg entry group footer. a bit tricky, but shoudl work.
Thanks for the response guys. The client is not using reservations, therefore there are no entries in the Reservation Entry table. Beaver, The report I am working with is 10139, Inventory Valuation. It returns a calculated remaining quantity. My problem is finding a link to tie this remaining item(s) to its serial number(s). I think Item Tracking Entry is the right data item, just not sure what the link is.
Steve, that report is US specific. Field 18 “item ledger entry no.” is the field that links item tracking entries to the respective item ledger entry. But I guess that report 10139 is quite complex too, so that just linking the two dataitems will not yield the right item tracking entries for the remaining amount. Just a guess, somebody who has access to that report could give you more information. Or send it as fob to: cumulo@web.de Than I can have a look at it, if time permits.