Hi,
I am trying to write a report that shows our Payments made by related Nominal Code.
The Purchase Payments (PP) are however stored with a Nominal Code relating to the bank the money is coming out of.
So I need to relate these PPs to the corresponding Purchase Order Items (which have the correct Nominal Codes against them)
I can happily do a report of Purchase Orders against Nominal Code but as the Payments are not made at the same time the PO is rasied, this is not what I want.
Can anyone help?
Thanks, Steve.
Related resources
Replies (2)
Please login or register to join the discussion.
Report
This is a complex one and, whilst I've not tried it, it may be boyond the capabilites of the Report Designer.
As there is no direct link between a Purchase Payment and a Purchase Order, you'd need to go via the Purchase Invoice as that has links to both.
How familiar are you with the Report Designer and joining tables?
John
Report
Hi John,
I can do complex SQL views so I guess it wont be too much of a problem!
Knowing all the relationships (which Sage don't seem to want us to know) is the difficult bit!
Thanks, Steve.