David Waldmann
Active Member
   

Live to work, or work to live?
Posts: 1919
Gender:
|
Like Tim said, Data Export to spreadsheet. First you have to run the BKCVUTIL (UT-A, or someplace on the menu) - select Customers and both years. Then export data from BKARCUST (DE-A) to a delimited text file. Select whatever fields you want, but probably BKAR.CUSTCODE, BKAR.CUSTNAME and BKAR.GROSS.LYR. Then open it in your spreadsheet, add a couple very simple formulas (one grand total, and then customer total divided by grand total, format as a percentage) and there you are. You can also do the same type of thing for Vendor purchases.
|