Loading ...

What is the difference between Purchasing values and Sales Values tables | CLEARIFY

Posted in: QQube    Excel and the Excel Add-In

What is the difference between Purchasing values and Sales Values tables

Subscribe to RSS
  • Hi

    In SALES VALUES there is a Line COGS Amount field.  This is always different to the equivalent amount in the PUCHASING VALUES Line Purchasing Amount field.

    I assumed that one was sales data and the other P&L?

    Biagio

     

  • Answered

    The COGS in the Sales Detail represents the exact posting amount in the particular transaction.  In this case, Invoices, Credit Memos, Sales Receipts.

    This is designed to match exactly what QuickBooks has in its reports - and to meet proper accounting standards.  It has to match.

    Invoice posting example:

    FYI, you can hover over a field in the Select Assistant for the Excel Add-In to garner this type of information: 

    If you want to create a "theoretical" COGS for items, then you would have to create a DAX Measure in Power Pivot or Power BI to include the current price of an item.  But that has its drawbacks, because the price could change - and there is no historical state of the price of that item.

    If you don't run in negative inventory quantities, chances are that the actual COGS posted in the transaction will be close the posted Cost you currently have for the item.  If it is really off, then you need to track down your inventory ins and outs of that item to ascertain what may have happened.  My two cents.

Page 1 of 1 (2 items)