Query for all open items including billed location, contact and amount outstanding at line level
Guys is anyone able to help
I need a query that can give me a listing of all open items, the site that the open item is for and will be paid by,
the contact who may pay it from the site , the amount outstanding at each line, the discounted amount available.
I've googled and looked on metalink and can't find anything that is relevant, and a query like the below gives me multiple records.
I've looked on the ETRMs and ERDs to try and find relationships etc Does anyone have a query that works and can give me this information,
I need a query that can give me a listing of all open items, the site that the open item is for and will be paid by,
the contact who may pay it from the site , the amount outstanding at each line, the discounted amount available.
I've googled and looked on metalink and can't find anything that is relevant, and a query like the below gives me multiple records.
I've looked on the ETRMs and ERDs to try and find relationships etc Does anyone have a query that works and can give me this information,
0