OpenSync

Home Forums OpenSync RefNumber in the SalesOrderLineDetail or InvoiceLineDetail

This topic contains 3 replies, has 2 voices, and was last updated by  Yudel Rosales 3 months, 3 weeks ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #65460

    nguyen_uniz
    Participant

    I’m looking for the RefNumber column in the SalesOrderLineDetail or InvoiceLineDetail. This RefNumber is available in the parent table (SalesOrder or Invoice) but not in the children table.
    In order to query filter by RefNumber in the LineDetail table, I have to inner join the children with the parent table.

    Please confirm that.
    Should you put RefNumber column in the LineDetail table too so I don’t have to inner join?

    #65461

    nguyen_uniz
    Participant

    Also, how to fetch the Open Invoices Report? I select Customers & Receivables –> Open Invoices
    Set date range: Today, Report Open Balance as of: Today, Report Basis: default, Detail Level: All Except Summary.

    After fetch, MySQL shows all the pending invoices that are not paid. Because it’s pending invoice, it won’t be paid. And those shouldn’t be on the Open Invoices report.

    Not sure how to configure to get the same Open Invoices from Quickbooks.

    #65467

    nguyen_uniz
    Participant

    I have found how to elimiate the non posting invoices in the Open Invoices report, by filtering transactions by “Posting Status Filter” = “Posting”

    The funny thing is although the configuration of the task is saved, whenever I go back to look at the task configuration, it’s always inverted to the default settings.

    #65470

    Yudel Rosales
    Keymaster

    Parent and children are connected through IDKEY field. Parent table TxnID or ListID will be saved in IDKEY field in the child table.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.