Forum Discussion

Razor1999's avatar
Razor1999
9 months ago

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 screen (generic inquiry) it shows both receipts and returns as a positive number showing on our dashboard as receiving more than we actually received.

 

Example for the month of February
Purchase Receipt: 10

Purchase Return: 5
Dashboard will display 15.

What formula can i input into the generic enquiry so that it will make the returns show up as a negative on Purchase Receipts screen ScreenId=PO3020PL?

dashboard
MYOBAdvanced
  • Will_H's avatar
    Will_H
    MYOB Moderator
    9 months ago

    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.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.