I have just started using Sage 200 with SQL in Excel. I now have the tables but getting stuck on the linking tables to each other to get a report out.
Is there any resources on the net or books with examples of 'how to produce a trial balance' for example.
Specifically I have been trying to produce a current outstanding transactions table from the purchase ledger into Excel that I can format into a pivot table.
I believe the tables I need are PLSupplierAccount, PLAllocationHeader, PLAlloicationTran, PLPosyedSupplierTran. That's about as far as I get, I think INNER JOIN comes into play but again I can't find information on these examples anywhere on the net. My Sage support company will produce the reports but will charge £'sss.
Thanks for any help you can offer.