Hello, I uses Sage 300, 2014 and like to get the information about Purchase Order amount issued and how much is delivered or received for a specific time period. i tried in the Purchase Action report both for Summary & Details. in the summary spreadsheet, the col lists; PO #, PO Date, Expected Date, Vendor Currency, Po amount, Function currency PO Amount,and then exchange rate. As i mentioned above, i need PO Amount as well as received amount and PO balance, did i go to wrong place to export the information? My second question is there is no total amount at the bottom in the sheet. and the amount col is merged cell and i have to un-merge the col. even i un-merged the col, my excel did not show the total when i choose all number in the row. Is there any way to show total at the bottom and no merge cell when i export spreadsheet from the system. i think may be my company's setting is not as friendly as it should be?
For the detailed action report, there is also no total but for the vendor and all the vendors. My prior ERP experience (not Sage) tells me it should have total.is there something wrong?
Thanks
Frank
