PanatrackerGP SQL databases
There are generally two tables for each transaction in the PanatrackerGP database. Those are typically the tables are clients want to report on.
Adjustments (Add and Remove Inventory) are in the TrxAdjustment and TrxAdjustmentUnit tables. The base table (TrxAdjustment) has one row for each transaction performed. The line items are in the "Unit" table.
To obtain a "flat view" of each transaction, the units can be joined to the base table in this manner:
- select h.*, u.*
- from TrxAdjustment h
- join TrxAdjustmentUnit u
- on u.TrxAdjustmentOid = h.oid
If you aren't sure of your table name, just poke around and compare the results and match up the data to what's in the portal. PO Receipts are in TrxReceiving/TrxReceivingUnit. Fulfill Order is in TrxFulfillOrder/TrxFulfillOrderUnit.
Item Bin Moves and Put Aways are all in TrxMoveInvUnit (no header).
We can create a report for you if you'd like (or just SQL for a View). This would offer you a template from which to expand. Contact our Professional Services team to request a statement of work.
Related Articles
SQL Error is displayed: OpenAccessException
Symptom "OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATEDATABASE Panatracker'; already exists." Cause This error occurs after the Panatracker transaction database has been modified or moved. The Panatracker SQL ...
Implementing PanatrackerGP-System Requirements
Verify your environment meets these requirements before installing PanatrackerGP. Installation Components PanatrackerGP requires three installation components: SQL Server login account Intranet website using Microsoft IIS Client app on supported ...
Timeout to the PanatrackerGP website
Symptom "Timeout expired. The timeout period elapsed prior to completion of the operation, or the server is not responding. The wait operation timed out." Cause This error means the handheld cannot contact the server hosting PanatrackerGP. A timeout ...
How PanatrackerGP Works With Your Dynamics GP
PanatrackerGP integrates with Dynamics GP to streamline inventory data collection and management through mobile devices. System Architecture Administrative Portal PanatrackerGP operates as a website portal and web services hosted within IIS (Internet ...
Adding a New GP Company to PanatrackerGP
Overview To add a company to PanatrackerGP: Grant the Panatracker SQL login access to the company Download and run required scripts Create the company record on the PanatrackerGP portal and aim it at the proper database Create a profile that ties ...