P4 Software
/
logisticaHQ-en
Applies to: logisticaHQ tenants, version 2.56.83 and later (the redesigned screen)
Roles required: anyone who can open Setup > System > Audit. The screen has no extra permission of its own, and the same people can use Reset integration status.
Regulatory references: none
Every time stock is added, moved or removed, every time a pallet, tote or order changes hands, and every time someone signs in or out, logisticaHQ writes an audit record: who did it, when, with which product, lot, serial and quantity, from where to where, against which document, and for what reason. Records are never edited and never purged. The Audit screen is where you question them.
Audit answers the questions a Warehouse is asked every day:
A query is built top to bottom, and Run (top right) sends it. Nothing is shown until you press Run.
When the screen opens it is already set to the last 10 days with no conditions, so pressing Run straight away lists everything recorded in the last 10 days.
The Time range has four buttons: Last 24 hours, Last 7 days, Last 30 days and Custom. The pressed button is highlighted. A line under the buttons tells you exactly what you are asking for, for example Counted back from the moment you run the query: Oct 14, 2026, 8:19 AM to now.
Custom is pressed when the screen opens, set to 10 days. It shows two choices:
| Choice | What you enter | What it means |
|---|---|---|
| Within the last | A whole number and a unit: seconds, minutes, hours or days | The period is counted back from the moment you press Run. Run the same query tomorrow and the window has moved by a day. |
| Between | A Start date and, if you want one, an End date (date and time, to the minute) | A fixed period. If you leave the End date empty the period runs from the start up to now. Use the x inside a date box to clear it. |
Typing in the number box or changing the unit switches the row to Within the last; picking a date switches it to Between. The dates are your computer's local time. There is no "weeks" unit: type 14 days.
If something is wrong, a red message appears under the buttons and Run does nothing until you fix it:
| Message | What to do |
|---|---|
| Enter a whole number of 1 or more | The number box is empty, zero, negative or has a decimal. Type a whole number such as 3. |
| Enter a number up to 100,000 | The number is too large. |
| Pick the start date | Between needs a start date. |
| The end date is before the start date | Pick an end date that comes after the start date, or clear it. |
Conditions narrow the records inside the time range. Without conditions the screen says No conditions yet: every record in the time range is shown.
To remove a condition click the x at the end of its row (Remove this condition). Nothing asks you to confirm.
To mix "all" and "any", click Add group. A group is a set of conditions with its own AND / OR choice, nested inside the main one. For example, all of: the last 30 days, and any of: Action = AdjustIn or Action = AdjustOut, finds every manual adjustment of the last month. A group has Delete group, which removes the group and every condition in it.
A condition that is not finished blocks Run. A condition with no field picked, or with an operator that needs a value and no value, stops the query; the condition is marked in red (This field is required). Fill it in or remove it, then press Run again.
Fields have plain names, for example From Warehouse, From bin, From license plate, To Warehouse, Integration message, Integration Reference and Uploaded on (the time the integration acknowledged the record). The other fields are named the same way: User, When, Type, Action, Client, SKU, Reference, Reference type, Quantity, Lot number, Serial number, Expiry date, Manufacture date, Reason, Pack size, Each count and Number of packs. The same list feeds the Summarize panel.
The operators offered depend on the kind of field:
| Kind of field | Operators |
|---|---|
| Text (SKU, Bins, lot, reason, Action ...) and ids | Equal, Not equal, Has a value, Has no value. The value must match exactly: INS-9005, not INS-90. There is no "contains". |
| Numbers (Quantity, Each count ...) | Equal, Not equal, Greater than or equal, Less than or equal |
| Dates (When, Uploaded on, Expiry date ...) | Greater than or equal, Less than or equal, Has a value, Has no value |
| Type | Equal, Not equal, with one of the seven record types chosen from a list |
Has a value and Has no value need no value, so the value box is hidden. For example, Uploaded on + Has no value finds the records no integration has acknowledged yet (that includes Failed ones, and user actions, which are never uploaded).
The screen shows friendly words, but a condition compares what is stored. Two places where this matters:
A date condition such as When is separate from the time range above. When offers a Relative Date checkbox with a number and a unit (counted back from the moment you run the query), or, unticked, a date and time picker. The other date fields offer the picker only. For a window between two moments in conditions, use two date conditions in one group, for example When greater than or equal to the start and When less than or equal to the end. The time range at the top does this for you, so prefer it.
The Summarize panel (marked Optional) gives totals instead of a list: group by one or more fields, then count or add them up.
| Choice | Result |
|---|---|
| List every record | No calculation. Without groups you get the normal list of records. With groups you get the number of records in each group. |
| Count | How many records. |
| Sum | The total of a number field. |
| Minimum | The smallest value of a number field. |
| Maximum | The largest value of a number field. |
| Average | The average of a number field. |
Grouped results show as a summary table instead of the list: one column per group field, outermost first, then the total. The last column is titled Records, Count or, for example, Sum - Quantity. A group whose field is empty shows as (empty). The heading says how many groups there are, for example 3 groups. A calculation with no groups shows a one-row table.
Examples:
After Run, the results appear under the filter.
The count and the time span. The heading says how many records were found (1 record, 412 records) and, beside it, the period that was searched, for example Oct 14, 2026, 8:19 AM to Oct 24, 2026, 8:19 AM.
Tabs. Under the heading there is an All tab, then one tab for each kind of record in the answer (Products added, Product moves, Products removed, License plate moves, Handling, Custom actions, User actions), each with its count. Click a tab to see only that kind. Tabs only filter the records already loaded; they go back to All every time you press Run.
The toolbar above the table has:
| Column | What it shows |
|---|---|
| User | Who did it, with their picture. |
| When | The date and time, in your time zone. |
| Type | The kind of record as a coloured pill: green for stock coming in (Product added), amber for stock going out (Product removed), blue for moves (Product moved, License plate moved), grey for everything else (Handling, Custom action, User action). |
| Action | Exactly which operation produced it, for example "Adjust out" or "Logout expiry". |
| SKU | The product. |
| From | Where the stock came from: the Warehouse on the first line; under it the bin and the license plate. Empty for stock that came in from nowhere. |
| To | Where it went, shown the same way. Empty for stock that left. |
| Qty | How much, always positive and always in single units (eaches): 2 cases of 12 are recorded as 24. The Type says whether it went in or out. |
| Reference | The document behind it: a purchase order line, a tote, a production order, a Truck Load. |
| Integration | Whether the ERP integration took the record. See below. |
| Details | A Review link that opens the whole record. |
Click Review to open Audit details: the full record exactly as it is stored, including the ids and the fields that are not columns.
Hidden columns. More columns are available in the column chooser (Columns): From bin, From license plate, To bin, To license plate (the same information as From and To, one column each), Client, Reason, Integration message, Integration Reference and Uploaded on. Show the ones you need; logisticaHQ remembers your choice. The layout you had on the old Audit screen does not carry over to this one.
Many records, mainly stock Adjustments, are meant to reach your ERP. The Integration column tells you what happened:
| What you see | What it means |
|---|---|
| Uploaded to ERP (green) | The ERP integration acknowledged the record: it has an upload time (Uploaded on). The integration's Reference, if it sent one, is shown under the pill. |
| Failed (red) | The integration reported a failure. Its message is shown under the pill. The record stays on the list of records not yet uploaded, so the integration retries it. |
| Blank | No claim either way. User actions (sign-ins, approvals) are never uploaded, so they are always blank; an adjustment the integration has not picked up yet looks the same. |
To list what the ERP has not taken yet, use the condition Uploaded on + Has no value. Records reset before 2026-10-16 kept an upload time from the old reset, so they read as Uploaded to ERP; that is also how the integration treats them.
Use this after you have fixed the cause of a Failed upload, so the ERP integration sends the records again.
What it does: it clears the integration Reference, the integration message and the upload time of the ticked records. The ERP integration then sees them as not uploaded.
Be careful with records that show Uploaded to ERP. If the ERP already has the record, resetting it lets the integration send it a second time. Reset only records the ERP does not have, which in practice means Failed ones. A reset cannot be undone, but you can see what was reset: the Integration column is blank again.
At the bottom of the page a folded section called Request sent to the server (for Support) shows the exact query you ran. Leave it closed. Open it, copy it and send it only when logisticaHQ Support asks, so they can run the same query. It appears after a successful Run.
A query Returns at most the Maximum number of records an audit report should return, which is 1,000 unless your administrator changed it (Setup > System > Configuration, Audit Records Limit). The newest records come first. When the count in the heading is exactly the limit there are probably more: narrow the time range or add conditions. The tab counts, the totals and the averages cover only the records returned.
Each record has a Type, which says what kind of event it was, and an Action (stored as the SubType), which says exactly which operation produced it. Use Type for a broad question and Action for a precise one. In conditions, type the stored names shown in this section.
| Type (stored name) | Meaning |
|---|---|
| ProductAdd | Stock came into a location from nowhere: a receipt, an adjust-in, a production build, a count that found more. |
| ProductRemove | Stock left a location for nowhere: a pick, an adjust-out, production consumption, a count that found less. |
| ProductMove | Stock went from one location to another: a move, a letdown, a pick to a production work area, a tray refill. |
| LicensePlateMove | A whole pallet (LPN) moved, with one record for each product on it. |
| Handling | Something happened without stock changing: a tote moved, an order shipped, a count confirmed, stock blocked. |
| CustomAction | A value-added service was performed. |
| UserAction | A person signed in or out, approved a count, or took a quality-control step. |
| Action (stored name) | Type | Produced by |
|---|---|---|
| ReceivePo, NonPoReceive | ProductAdd | Receiving against a purchase order, or without one. The Reference is the PO and line. |
| UnreceivePo | ProductRemove | Reversing a receipt. |
| ReceiveRma, NonRmaReceive | ProductAdd (Handling when received as damaged) | Receiving a customer return. The Reference is the RMA and line. |
| Pick | ProductRemove | Picking into a tote or carton. The Reference is the tote's SSCC. |
| UnpickPickTicket, UnpickTote | ProductAdd | Putting picked stock back. |
| AdjustIn, AdjustOut | ProductAdd, ProductRemove | Manual Adjustments on the Handheld, with the reason code chosen. |
| CustomerReturn, VendorReturn | ProductAdd, ProductRemove | Adjusting in from a customer or out to a vendor. |
| ProductMove, BinMove, WarehouseMove | ProductMove | Moving a product, a whole bin, or stock to another Warehouse. |
| Letdown | ProductMove | Replenishing a pick location from reserve. |
| PacksizeConvert, PacksizeBreakdown | Any | Consolidating or breaking pack sizes. |
| SubstituteConvert | ProductRemove + ProductAdd | Converting one product into its substitute. |
| CycleCount | ProductAdd / ProductRemove, plus Handling | A Cycle Count. The Handling record holds the quantity counted; an Add or Remove record is written only where the count differed. |
| ProdOrderPick, ProdOrderBuild, ProdOrderConsume | ProductMove, ProductAdd, ProductRemove | Production: components to the work area, finished goods built, components consumed. |
| KitRefill, KitPull | ProductMove | Surgical Trays: items picked into or pulled out of a tray. |
| LicensePlateMove | LicensePlateMove | Moving a pallet, including to a dock door. |
| Init | ProductAdd / ProductRemove | Initial stock loaded when the company was set up. |
| Action (stored name) | Produced by |
|---|---|
| ToteBinMove, ToteDockDoorMove, ToteLpnMove, ToteFloorMove | Moving a tote to a bin, a dock door, a pallet or the floor. |
| ShipToteCount, DeliveryToteCount | Confirming a tote's contents at shipping or at Delivery. |
| Repackage | Repackaging or merging Totes. |
| SmallParcelShip, TruckLoadShip, PrivateFleetShip, ExternalShip, MasterTruckLoadShip | Shipping an order or a Truck Load, one record per tote. |
| PalletPrinting | Giving a pallet its SSCC label. |
| BlockInventory, UnblockInventory | Blocking or Releasing stock, with the reason. |
| ProdOrderProdStep | A production order moving to its next step. |
| KitDispatch, KitDispatchCancel, KitReconcile, KitRefillComplete, KitHomeCustomerSet | Surgical tray office actions. |
| FieldDraftApprove, FieldDraftReject | Reviewing a consumption report sent from the Field app. |
| Action (stored name) | Meaning |
|---|---|
| Web, Handheld, Other | Signed in on the web, on a Handheld, or through another channel such as the client portal or the Field app. |
| LoginImpersonate | An administrator opened a session as this user. |
| LogoutRegular, LogoutByAdmin, LogoutExpiry | Signed out, signed out by an administrator, or signed out after inactivity. |
| LogoutUserDuplicate | Signed out because the same user signed in on another device. |
| LogoutNoLicense | Signed out to free a license seat for someone else. |
| LogoutUserDeactivated | Signed out because the user was deactivated. |
| CycleCountApproval | A supervisor approved a count adjustment. The user is the approver. |
| QcInspectionStart, QcHold, QcRelease, QcComplete and the other Qc... actions | Each step of an outbound quality-control inspection and its Corrective actions. |
| FieldPhotoUpload, FieldDraftSubmit | Photos and consumption reports sent from the Field app. |
The Action of a CustomAction record is the name of the value-added service, as configured on the VAS screen.
| Field | Meaning |
|---|---|
| User | Who did it. |
| When | When, shown in your time zone. |
| Type, Action | What it was; see above. |
| Client | The client the product belongs to. |
| SKU | The product. |
| From Warehouse, From bin, From license plate | Where the stock came from. Empty for an add. |
| To Warehouse, To bin, To license plate | Where it went. Empty for a remove. |
| Quantity | How much, always positive and always in single units (eaches). Whether it went in or out is told by the Type. |
| Pack size, Pack size barcode, Each count, Number of packs | The pack size handled and how many packs. |
| Absolute from quantity | What was left of the product at the source after the operation. What was there before is this plus Quantity. |
| Absolute to quantity | What there was of the product at the destination after the operation. What was there before is this minus Quantity. |
| Lot number, Serial number, Expiry date, Manufacture date | The lot, serial and dates of the stock handled. |
| Reference type, Reference, Reference ID | The document behind it: a purchase order line, a tote, a production order, a tray, a Truck Load. |
| Reason | The reason code or note given. |
| Integration Reference, Integration message, Uploaded on | Set when another System, such as your ERP, has taken the record. See The Integration column. |
Absolute from quantity and Absolute to quantity make Audit a running stock card. Query one SKU in one bin and read the records from the oldest up: each line shows what moved and what was left.
Stock Adjustments usually need to reach your accounting or ERP System. The REST API offers them through POST /Adjustments, which reads these same audit records. It can return only the records not yet uploaded, and POST /Adjustments/upload marks records as uploaded by setting their Uploaded on time. The Integration column and the condition Uploaded on + Has no value show you which Adjustments your ERP has not yet taken. Reset integration status puts records back on that list.
| Symptom | Likely cause | What to do |
|---|---|---|
| Run does nothing | The time range shows a red message, or a condition is not finished. | Read the message under the time range; fill in or remove the marked condition. |
| This field is required on a condition | The condition has no value. | Type or pick a value, or remove the condition. |
| No records, and you expected some | The time range is too short, or a condition does not match the stored value. | Widen the range. Check that Type and Action use the stored names (AdjustOut, not "Adjust out"). |
| The count equals the records limit | There are probably more records. | Narrow the time range or add conditions; see How many records a query Returns. |
| A column you want is not visible | It is hidden by default. | Open Columns and show it. |
| Reset integration status is not there | No record is ticked. | Tick one or more records in the table. |
| A summary table appears instead of the list | Group by or Calculate is set in the Summarize panel. | Remove the group fields and choose List every record to get the list back. |
Was this page helpful?