Adding quantity from invoice lines to project lines view/explorer screen.

SOLVED

We are starting to you use Project accounting, and find the explorer window great. However, the quantity invoiced in the vdvproject lines view, seems to be inaccurate. Infact, we would like to quantity from invoices lines view. I have tried a couple joins, and attempting to look through the schema, but cant seem to find the link between the mods. They must link somehow, because if i enter an invoice, i can add project and project number into the invoice.

Any help is much appreciated.

Parents
  • +1
    verified answer

    First rule of BI is don't mess with standard views. Second rule of BI is don't mess with standard views.

    The vdvProjectLines view does not appear to have a link to the invoice line. To do this properly, you would need to aggregate the invoice quantity or line totals because there is a one to many relationship between the two (a project line can have multiple billings). I would recommend you review Invoice Lines in AR (vdvInvoiceLine). It contains project references and details the relationship between the invoice line and project billing schema, specifically dbo.paarInvcLine.

Reply
  • +1
    verified answer

    First rule of BI is don't mess with standard views. Second rule of BI is don't mess with standard views.

    The vdvProjectLines view does not appear to have a link to the invoice line. To do this properly, you would need to aggregate the invoice quantity or line totals because there is a one to many relationship between the two (a project line can have multiple billings). I would recommend you review Invoice Lines in AR (vdvInvoiceLine). It contains project references and details the relationship between the invoice line and project billing schema, specifically dbo.paarInvcLine.

Children