Skip to content
P4 Software P4 Software / logisticaHQ-en

Add these docs to Claude

Ask Claude questions about these docs. Claude reads the published pages and links you back to them. Copy this address:

https://p4-software.opendocs.page/mcp

In claude.ai or Claude Desktop: open Settings, then Connectors, choose Add custom connector and paste the address.

In Claude Code, run:

claude mcp add --transport http docs https://p4-software.opendocs.page/mcp

Audit

Audit
← Back to System

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

Overview

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:

  • Where did these 12 units go? Every move of the SKU, bin by bin.
  • Who adjusted stock out last week, and why? Every adjust-out with the user and the reason.
  • How many picks did each picker do today? A count of pick records grouped by user.
  • What happened to lot L2409 or serial SN-0042? Every record for that lot or serial, from receipt to shipment.
  • Did this adjustment reach our ERP? The Integration column says so for every record.

Navigation

Setup > System > Audit

How the screen works

A query is built top to bottom, and Run (top right) sends it. Nothing is shown until you press Run.

  1. Time range: which period to look at. It always comes first.
  2. Conditions (optional): narrow the records further, for example one SKU or one user.
  3. Summarize (optional, in the panel on the right): totals instead of a list.
  4. Run, then read the results underneath.

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.

Step 1: Choose the time range

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.

Step 2: Add conditions (optional)

Conditions narrow the records inside the time range. Without conditions the screen says No conditions yet: every record in the time range is shown.

  1. Click Add condition. A new row appears.
  2. Pick a field, then an operator, then type or pick a value.
  3. Choose how the conditions work together in the line Records that match [all of these conditions / any of these conditions]. All means a record must satisfy every condition; any means one is enough.
  4. Click Run.

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.

Field names

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.

Operators

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).

Conditions compare the stored values

The screen shows friendly words, but a condition compares what is stored. Two places where this matters:

  • The Type list offers the stored names (ProductAdd, ProductMove, ProductRemove, LicensePlateMove, Handling, CustomAction, UserAction), not the words shown in the results ("Product added" and so on).
  • Action must be typed as stored: AdjustOut, not "Adjust out". See What is recorded below for the stored names.

Date conditions

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.

Step 3: Summarize (optional)

The Summarize panel (marked Optional) gives totals instead of a list: group by one or more fields, then count or add them up.

  1. Under Group by, pick a field from the list (it says Select a field) and click Add field. Add more fields to group inside groups, for example User and then Action.
  2. Use the up and down arrows (Move up, Move down) to reorder the fields, and the x (Remove) to take one out. Adding the same field twice shows The field is already in the list.
  3. Under Calculate, choose what to work out for each group:
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.
  • of picks the number field (usually Quantity). It applies only to Sum, Minimum, Maximum and Average; for List every record and Count it stays disabled.
  • Click Run.

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:

  • Picks per picker today: time range Last 24 hours, condition Action equal Pick; group by User; Count.
  • Units adjusted out per reason this month: Last 30 days, Action equal AdjustOut; group by Reason; Sum of Quantity.
  • Units received per SKU: Action equal ReceivePo; group by SKU; Sum of Quantity.

Step 4: Read the results

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:

  • Search: finds text in any column.
  • Filters: shows a filter row under the column titles. When filters are active, a Clear filters button appears.
  • Columns: opens the column chooser.
  • Export: downloads the rows as they are shown (after the search, the filters and the tab) to Excel, not the whole audit log.

The columns

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.

The Integration column

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.

Reset integration status

Use this after you have fixed the cause of a Failed upload, so the ERP integration sends the records again.

  1. Run a query and tick the records (the box at the start of each row). A bar appears above the table showing how many are ticked.
  2. Click Reset integration status in that bar. The button only exists while at least one record is ticked.
  3. A confirmation asks Reset integration status for [n] records? and explains: This clears the integration status of the selected records, so the ERP integration sees them as not uploaded and can send them again. Under it the records are listed (Reference and SKU, up to eight, then and [n] more).
  4. Click Reset [n] records to confirm, or cancel to change nothing.
  5. A message confirms Integration status reset for [n] records. The records' Integration cell goes blank at once, the ticks are cleared, and the query is not run 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.

Request sent to the server (for Support)

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.

How many records a query Returns

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.

What is recorded

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.

Stock records and their actions

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.

Handling records

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.

User records

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.

The fields of a record

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.

Audit and your ERP

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.

Good to know

  • Audit records are kept for good; nothing deletes them over time.
  • A client user sees only their own client's records through the REST API.
  • The layout of the results table (columns shown, widths, filters) is remembered per user. If a result looks filtered when it should not be, click Clear filters above the table.
  • Exact dates in the time range are sent with your computer's time zone: two Users in different Zones who pick "14:30" ask for different moments.
  • For changes to documents and settings, such as who changed a product's weight or a purchase order's date, use the record's History button or History search. Audit covers stock and people; History covers edits to records.

Troubleshooting

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.

Related features

  • Setup > System > Configuration: the Audit Records Limit setting.
  • History button on a record: edits to documents and settings.

Was this page helpful?