Skip to Content
0
Former Member
Jun 25, 2013 at 09:48 AM

Query for purchase vs sale

93 Views

Hello,

I need a query report that can tell me about AP doc number, ap item no., item description, ap Quantity, ap Assessable Value, AR doc number, ar Quantity.

The AP invoice number is also selected by the user at row level against each item on invoice? Can we make such report or two reports are required?

Or in simple I need to know how much item was purchased on ap invoice number 1 and how much was sold from ap invoice number 1?

BR,

RR