tommouk
Blogger
Share this content
0
2
1044

Sage : Purchase Payments relating to POs

Sage : Purchase Payments relating to POs

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.

Replies

Please login or register to join the discussion.

avatar
15th Mar 2012 10:34

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

Thanks (0)
avatar
By tommouk
Democratus
15th Mar 2012 15:42

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.

 

Thanks (0)