Project

General

Profile

Edit Copy Actions
Copy link

Feature #4162

open

Feature #4154: Inventory Actuals Capture

Feature #4160: User Story: Preview Planned vs Actual

Backend api for getting inventory data for review

Added by Yalavarthi Thriveni 4 months ago. Updated about 1 month ago.

Status:
Resolved
Priority:
Normal
Assignee:
Ajit A
Target version:
-
Start date:
09/30/2025
Due date:
09/30/2025 (about 4 months late)
% Done:

100%

Estimated time:
8:00 h
Quote

Description

API / Backend

Preview Endpoint

GET /jobs/{id}/actuals/preview returns full job snapshot.

Must include planned, actual, variance, remarks, attachments.

Return error 404 if no actuals exist.

Variance Calculation

Validate calculation logic:

Planned=10, Actual=8 → Variance=-2.

Planned=5, Actual=7 → Variance=+2.

Ensure percentage variance is included if required.

Threshold Highlighting

Backend marks variance items exceeding threshold with flag highlight=true.

Ensure configurable threshold value (e.g., 10%) loaded from system settings.

Attachments

Ensure API returns attachment metadata: fileId, filename, fileType, presignedURL.

Validate expiry time on presigned URL.

Read-Only Enforcement

Ensure preview API is GET only, no mutating operations.

Audit Logging

Verify viewPreview entry added to audit table when Admin calls preview endpoint.

Add

Subtasks

Add

Related issues

Edit Copy Actions
Copy link

Also available in: Atom PDF