Dashboard Purchase History on MYOB Advanced
We have a graph on our dashboard of our purchase history with specific suppliers. The quantity data is summed up of an inventory item through the puchase receipts screen. In the purchase receipts sc...
Forum Discussion
Hi Razor1999 ,
IN general, Generic Inquiries are a powerful tool, but you may need assistance from your consultant/support partner to be able to leverage them fully.
Based on this post in the AUG Forums (they've got lots of useful information that applies to Advanced),
The basic version is you want an if statement, which is an IIF in the Generic Inquiry writer.
I think you want something like this:
=IIf( [POReceipt.ReceiptType]='RT', 1, -1 )*[POReceipt.OrderQty]
Note: That's a really quick mock, and if you need support with it you'll need to talk to a consultant.
