Hello,
Using the Add-in query for Lawson 10, I am able to create a TB report using GLAmounts where it gives me the Current year beginning balance and each subsequent months activity.
The short of it is, there are several sites here that do not have access to Lawson 10, and only have access to add-ins. I need to create a query that runs similar to the GL291 which allows me to filter by acct-period (currently cannot do that out of GLAmounts) as well as provides me columns for:
1) Selected month beginning balance
2) Debit activity for the selected month
3) Credit activity for the selected month
4) Selected month ending balance
Any feedback would be greatly appreciated.
Thanks.
Jason