Skip to content
September 8, 2010 / opennav

New Report: Item 12 Months Statistics

Hi all,

my first .fob is a report. A classic one: item statistics!

It shows sales and purchases amounts and quantities, grouping for months starting from a date to insert in the option tab: good for distribution / retail customers.

This simple report got two points of strenght:

  1. High speed in calculating amounts and quantities due to the powerful NAV SIFT feature
  2. Variant Level details

In the onaftergetecord trigger of both dataitems there are the few code lines that calculate the values shown in the section via the calcfields method. In these case, we have to use item2 variable to apply filters without changing the original item dataitem variable filters.

Maybe someone could add output or consumption details or some interesting option…

The .fob object is in the box.net frame on the right side of this blog.

If you have problems in downloading it, maybe you can try here: https://www.box.net/shared/f4qzig0473

Leave a comment