9 Replies Latest reply on Nov 2, 2016 9:04 AM by Magnus Fransson

    Getting balance of last month summary in current month.

    akhlaq38

      Hi all

      I have a layout where I got sub summary report of all the products showing total quantity purchase and total

      quantity sale with balance quantity in each line. It shows month wise like this;

      September

                Product Code                         Qty Purch                    Qty Sold                    Balance

                10e1.2c18                                   320                              212                         108

                 30m1.6d14                                140                              114                           26

      Octobar

                10e1.2c18                                   290                              278                         12

                 30m1.6d14                                188                              164                          28

      I want to show balance of last month in new month / next month like this;

      September

        Product Code      Balance Last month        Qty Purch                    Qty Sold                    Balance

      10e1.2c18                                                       320                              212                         108

        30m1.6d14                                                     140                              114                           26

      Octobar

        10e1.2c18                108                               290                              278                          120

        30m1.6d14                 26                               188                              164                            50

      Is this possible to do this in FM? Actually we have about 550 products to show as above. It is a long list.

      To see the balance of last month is required to search by scrolling.