MAS90/MAS200 Open Order Report – Printing Only Orders With XXXX Product Line Items

A client wanted to see the open order report only for orders containing items in XXXX product line.  However, he wanted to see the ENTIRE order if ANY item was in that product line.  You would not know until you had read the entire order whether any items were in the selected product line, so the following changes were made to the standard Open Order Report.

First, the Group Header information was moved to the Group Footer (sales order number, customer, etc).  Since the decision to print would come at the time of printing the Footer, this is where the information needed to be.

Next, another group footer section was added (same group footer, just a new section).  A subreport was added into this group footer section to print the line detail.  It was linked by sales order number, and I just took the detail lines from the original report and copied them over to the subreport.  I also had to copy a few variables (re the number of decimal places to print), as well.  I also had to setup the conditional line suppression, based on whether the line type was “4″ (“Comments”), or not.

Now I was ready to determine which orders fit the criteria.  I created a variable “@CorrectProductLine” which I set to “Y” if the item was in the selected product line, and “N” if it wasn’t.  At the same time, I created a RunningTotal variable “ProductLineExists” which looked for the maximum of the {@CorrectProductLine} variable, resetting on each change of sales order.  Since “Y” is after “N” alphabetically, the max would be “Y” if a “Y” existed ANYWHERE in the lines of the order.

I then hid the detail lines and suppressed all of the group footer information if “ProductLineExists” was “N”.

A new Running Total for the order total was also required, which involved adding User-Defined Fields for the Taxable and Non-Taxable totals,  and then it was ready for use!

 SO_OpenOrderMod (Sample printout)

via: Beth Bowers – Sage MAS 90 and MAS 200 Consultant – Michigan

« Breaking News-Looks Like Microsoft FRx lives as PerformancePoint "dies" | Home | Converting an old Sage FAS 50 or 100 installation to MAS 90 or MAS200 FAS »

• 
  
  Need help? Click Here.