Calculating "velocity" of stock in a site.

Question

Hello, 
 We use Netstock which has a "velocity" identifier that tells you in layman's terms how fast a product sells. It is separated into three main classifications: A, B and C and then three velocities: High (H), Medium (M) and Low (L). I am not sure of the definition for the letter classifications, but our best-selling items would be classified as "AH". 
 I am just writing today to ask if Sage X3 inherently has this type of "velocity" information stored somewhere, or otherwise if it can be calculated using the data from different tables. We are trying to revamp our cycle count methods to use this data, but I can't find where it would be stored, if at all. 
 
 If you need any more info, please let me know. 
 Zoey

Julien Patureau · Accepted Answer

Hi Zoey Mattison 
 To be clear, Sage X3 has not a velocity field in the data model. But, I expect we have all information needed to make the calculation (statistic? bespoke calculation?) 
 X3 manages ABC class to set the frequence for cycle count. The way ABC class are calculated is explained in the online hep: 
 https://online-help.sageerpx3.com/erp/12/staticpost/abc-class-calculation/ 
 The process is based on a formula given you some flexibility on how the ABC class are assigned (based on quantity sold, or revenue generated or number of receipts and issues for instance). Past activities would be stored in tables ITMMVT and ITMMVTHIS accessible in the formula. If you are recently live with Sage X3, you won't have enough information to run this process for the moment. In addition, I believe only event in the current year are processed so you usually run this process at the end of the year and not in january.

Sage X3

Calculating "velocity" of stock in a site.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING