Hi, I would like to raise an issue regarding snapshot data output. I have created a small database to illustrate the issue. Situation We want to monitor stock, we have enabled a daily snapshot to provide the “Syncmoment”. The design is very simple as below: [image] Please take note of highli…

Hi @JonKemp , you need to edit your stream in Designer and tick the “Balance Brought Forward” box.

I’m pretty sure if you raise this with your contact at Phocas they will be able to sort it. I have a stock database that has both an Inventory Balance Stream (As at x date - the same as you’re showing above) and a Movement Stream (showing the net movement of that balance in the month). When I sele…

Hi @nyphocas , Superb! thank you. @nyphocas - Could this post please be moved to tips and tricks so it is no longer classified as a product suggestion? Kind Regards, Jon

So I had this same issue, and checked the box hoping to be able to report on sales vs inventory again, after enabling snap shots in inventory, and now my inventory value doubled and I can’t revert it. I tried rolling back the database. Unchecked the roll forward, and rebuild, and nothing is fixing i…

Appears reverting back two checkpoints ago and rebuilding now got me back to where I started thankfully. However, how do I enable the ability to look at current inventory vs sales for those items over a time range, without the inventory values adding up once I get past a month. I am scared to check …

I’m trying to understand how it works and can’t find the right setup for this? I have the Balance Brought Forward checked, snapshots ticked as Monthly in Sync. SyncMoment as in Date dimensions. Do I miss anything in the setup?

Snapshot data issues on display (semi additive)

Ask the Community

JonKemp July 16, 2019, 1:24pm 3

Thanks @StuartH ,

I was unaware thanks for the heads up.

Cheers,

Jon

Totals in Grid View

Topic		Replies	Views
Totals in Grid View Product Ideas	2	1704	January 17, 2020
Stock Position - Balance At Date Ask the Community	2	1075	January 9, 2020
Retain Snapshots - Inventory Ask the Community	3	1302	August 25, 2021
All about Snapshot data Ask the Community	1	1027	March 29, 2023
👀 Advice re: Snapshots, Open Orders/Bids Ask the Community	1	834	March 29, 2023

Snapshot data issues on display (semi additive)

Related topics