Skip to main content
Unicart+ / Topic 09 of 19

How Is the Stock Sync Quantity Calculated?

Implementation steps, settings and original screenshots from the SiteGiant ERP–AutoCount integration guide.

PDF TOPIC 09

How Is the Stock Sync Quantity Calculated?

Use this topic to understand how Unicart+ decides the final stock quantity to sync from AutoCount to SiteGiant. An order may update in SiteGiant and AutoCount at different times. Unicart+ adjusts the quantity so the same order stock is not added or deducted twice.

Why Is the Stock Quantity Adjustment Required?

SituationWhat Could HappenSystem Action
Order quantity already deducted in AutoCount but still locked in SiteGiantThe same quantity may be deducted twice.Add Invoice Qty back temporarily.
SiteGiant released quantity but AutoCount has not deducted itToo much stock may be sent to SiteGiant.Deduct Unposted Qty temporarily.
No timing differenceNo adjustment required.Use AutoCount Balance Qty.
Original Unicart+ screenshot, training PDF page 31, image 1
Original screenshot · PDF page 31 · Click to enlarge

Unicart+ (AutoCount) Quantity Definitions

QuantityMeaning
Balance QtyCurrent stock balance shown in the AutoCount Stock Card.
Invoice QtyOrder quantity already deducted from AutoCount but still locked in SiteGiant. Added back temporarily to avoid double deduction.
Unposted QtyQuantity released in SiteGiant but not yet deducted from AutoCount. Deducted temporarily from sync calculation.
Onhand QtyAdjusted AutoCount quantity after adding Invoice Qty and deducting Unposted Qty.
Computed Sync QtyQuantity calculated after applying stock-sync settings from Topic 08.
Sync QtyActual quantity sent to SiteGiant. Normally follows Computed Sync Qty unless changed manually.

Unicart+ (SiteGiant) Quantity Definitions

QuantityMeaning
Stock On HandCurrent total stock recorded in the selected SiteGiant warehouse.
Sellable StockQuantity currently available for customers to purchase.
Locked QtyQuantity reserved or locked by orders and currently unavailable for sale.
New Stock On HandExpected Stock On Hand after Sync Qty is sent to SiteGiant.
New Sellable StockExpected quantity available for sale after considering locked and non-sellable quantities.
ChangesDifference between the current Stock On Hand and New Stock On Hand.

Example (as stated in the original PDF)

AutoCount Balance Qty is 57. An order quantity of 1 has already been deducted from AutoCount but SiteGiant still shows it as locked.

CalculationQuantity
AutoCount Balance Qty57
Add: Invoice Qty+1
Deduct: Unposted Qty0
Onhand Qty58

The PDF then states: if Sync Stock Percentage is 80%, Computed Sync Qty = 44, Sync Qty = 44 and SiteGiant New Stock On Hand = 44. PDF example: These figures are reproduced as stated in the original training guide.

The PDF also states that if SiteGiant has 1 Locked Qty and no other reserved or non-sellable quantity, New Sellable Stock will be 57.

Original Unicart+ screenshot, training PDF page 33, image 1
Original screenshot · PDF page 33 · Click to enlarge
Original Unicart+ screenshot, training PDF page 33, image 2
Original screenshot · PDF page 33 · Click to enlarge
Original Unicart+ screenshot, training PDF page 33, image 3
Original screenshot · PDF page 33 · Click to enlarge
Original Unicart+ screenshot, training PDF page 33, image 4
Original screenshot · PDF page 33 · Click to enlarge

How to Verify the Quantity

01
Run Inquiry in Stock Listing.
02
Check Balance Qty in the AutoCount Stock Card for the same Item Code, Location and UOM.
03
Check whether Invoice Qty or Unposted Qty is shown.
04
Confirm that Onhand Qty follows the adjustment logic.
05
Compare Computed Sync Qty, Sync Qty and New Stock On Hand.
06
If Sellable Stock is lower, check Locked Qty and other SiteGiant stock details.

Troubleshooting / Common Errors

IssueWhat to Do
Quantity is inaccurate during the first stock syncConfirm that the client completed the stock take in AutoCount before synchronizing.
Stock Listing shows a data-expired messageDo not continue with the old quantity. Run Inquiry again before synchronizing.
AutoCount and SiteGiant quantities keep becoming differentConfirm stock adjustments are made in AutoCount only. Correct AutoCount quantity and synchronize again.
Unposted Qty is not updated because invoice is still DraftApprove the AutoCount invoice, then run Inquiry again.
Unposted Qty is incorrect when using multiple locationsCheck AutoCount Location to SiteGiant warehouse mapping. If correct but issue persists, confirm latest Unicart+ version.
Stock Listing quantity is much lower than expectedUse Filter Oversell Item to identify affected item. Check AutoCount balance, settings and pending documents before synchronizing.