Hi

Has anyone perhaps created a report looking at open / undelivered purchase orders with the detailed line items on order i.e. , Supplier, Item description, Qty ordered etc?

Views: 279

Replies to This Discussion

Hi  Annelize

You can try this container

_bvInvLinesFull
inner join InvNum on iInvoiceID = invnum.AutoIndex
inner join _evGLaccountsFull on accountlink = iledgeraccountid
where DocType = 5  -- Purchase Orders
and DocState in (1,3)  -- Partial and Open
and iLedgerAccountID <> 0  -- GL only

As always please check to your Evolution report

Thanks Frans. That helped allot. I am sorted.

Sorry for the late reply

Hi Annelize, 

If you are wanting some help with a report like this, we can help you. Please email me on meg@customconsultingsa.co.za - I have a consultant that only works with Evolution reporting.

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service