How are you keeping Cin7 COGS aligned with Xero over closed periods?

Hi Cin7 community,

I’m looking for practical advice from anyone who has successfully kept Cin7 COGS values consistently aligned with Xero over time.

Our issue is that balances which were correct at month end can change months later, throwing out previously reconciled periods. After a deep dive, we’ve isolated the main cause:

Partially receipted purchase orders across closed periods
Historically, if a supplier short-shipped (e.g. 30 units missing), we’d leave the PO open and receipt the remaining stock when it arrived - sometimes in a later month.

What we’ve now realised is that receipting part of a PO in a later period changes COGS values for the earlier month, even though that month was already closed, reported, and reconciled in Xero.

We’ve stopped accepting supplier invoices dated into locked periods, but this doesn’t fully solve the issue when stock is physically received later.

My key question: Is there any way to lock purchase orders or prevent changes once a Xero period is closed?

We’re aiming for a system where once a month is closed and reconciled, COGS cannot silently drift later due to operational actions.

Any real-world workflows, settings, or hard-won lessons would be hugely appreciated.

Thanks in advance.