Insights & Information regarding enterprise resource planning software from a leading industry expert.

SAGE ACCPAC INTELLIGENCE – BEYOND REPORT MANAGER, PART 3

  

 Email Article  

Tweet  

  

  

 delicious  

  

  

We continue the SAI series, building consolidated Aged Payables Report. We left last time with adding Connection in B/X Connector.

Please note that table connections and Join types are not discussed here, so for those unfamiliar with ‘joining tables’ concept there is a lot of written material on the subject that you might want to look up.

Now, as our container built, we need to  add expression in order to define what information (Fields) will be used in the report. Let’s give it a name Aged Payables ‘COMPANY NAME’ Connection and then right click on that icon and select ‘Add Expression’.

Pick ‘Data Fields’ from a Table/s’ option, and let’s select following  fields from all previously selected Tables: IDVEND, AUDTORG, IDINVC, DATEINVC, AMTDUEHC, AMTBALDUEH, SWPAID, VENDNAME.  So we have enough information gathered in relation to outstanding balances, document details and Vendor details to start building our report to proceed to the next stage - Report Manager and further define our settings for consolidated Payables Report.

Let’s create a personal folder first, where all new reports can be stored. Right click on the top left icon in Report Manager and select ‘Add folder’ and give it a name - something like 'My Folder' and right-click on it. Select ‘Add Report’ and pick ‘Standard Report’ from the dialog box. Let’s name it the ‘Payables COMPANY NAME’ and from opened dialog box pick ‘Data Container’ you previously created. Select all fields from yet another dialog box.

It is at this stage you can define your columns, filters, parameters and sort order – whatever information you want to see on the report and the way you want it to be displayed. Let’s now make  the following configuration on 4 tabs:

Congratulations – you’ve just created your own SAI report! But it is a bit early to celebrate, since this is only the first part of the exercise, remember the consolidation thing? To achieve that, create another report to the second company by following the same steps, and then you’ll be ready to consolidate them together. What now follows is the consolidation via ‘Union Report’. Let me be clear, this is not the only way to consolidate data in SAI; the other options would be explained in future articles on SAI series.

Add another report in Report Manager and call it ‘Consolidation Payables Report’. This time around pick the ‘Union Report’ option. Add both created Payables reports at the ‘Union Sub-reports’ tab, assuming they have similar configuration.

In the next article we will review running this report and creating Excel Template that is going to format the layout of the report according to your requirements.