cancel
Showing results for 
Search instead for 
Did you mean: 

"Simple Query" Summary of Invoices & Credit Memos

ryanspencer
Explorer
0 Kudos

Hi Experts,

I have a requirement to produce a query which returns the following fields, in this format;

|  Warehouse  |  Item Code  |  Invoice Qty  |  Credit Memo Qty  |  Current In Stock  |

Initially, this seemed straight forward, I can access all the information. I just can't get in columns.

Anyone have any ideas how this could be achieved, it's driving me crazy

Many Thanks

Ryan

Accepted Solutions (1)

Accepted Solutions (1)

ryanspencer
Explorer
0 Kudos

I think I've managed to generate the logic.

...maybe I should log more on here, then I'll work it out myself!

If anyone's interested, let me know and I'll post the script.

Answers (0)