OpenSync

Home Forums OpenSync PO with multiple Lines – Entering bill with 1 Line – but entire PO closes.

This topic contains 7 replies, has 3 voices, and was last updated by  Tom Crawford 2 years, 11 months ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #28035

    purchasing3
    Premium Member

    We are using OpenSync and we have one urgent issues that has been bothering us for while. When we enter bill for 1 line item from multiple lined PO.. it closes entire PO with full value of PO rather than bill.

    Example : I have 5 different line items for different products on single PO with each with $100 value on PO. Not, In my case.. I have only received shipment on 1st item and have invoice for value of $100. When we try to sync that single bill .. In quick books it closes the PO with full value and marks other 4 items in bill.

    #28260

    purchasing3
    Premium Member

    We also wanted to know that .. If I have single bill with multiple lines from multiple POs. How can we link such bill to each purchase order.

    – Please update me ASAP.

    #62308

    Tom Crawford
    Keymaster

    In order to link a single line item from a bill to a single line item on a PO using the following relationships in the line item for the bill:

    TxnItemLine.TxnID = PurchaseOrder.TxnID
    TxnItemLine.LinkedTxnLineID = PurchaseOrderLineDetail.TxnLineID

    #62334

    jaydeep
    Participant

    Can you suggest me Bill items linkup With PO Items.

    TxnItemLine.TxnLineID= PurchaseOrder.TxnID
    TxnItemLine.LinkedTxnLineID = PurchaseOrderLineDetail.TxnLineID
    TxnItemLine.LinkedTxnID = ??

    Which value store in LinkedTxnID ?

    #62335

    jaydeep
    Participant

    TxnItemLine.LinkedTxnID = PurchaseOrder.TxnID
    TxnItemLine.LinkedTxnLineID = PurchaseOrderLineDetail.TxnLineID

    I have try about solution and got some of records has a error report like
    The ‘LinkToTxn’ field has an invalid value ‘TxnID=A56-1423517858, TxnLineID=A5C-1423517858’.

    Can you suggest me Bill items linkup With PO Items.

    TxnItemLine.TxnLineID= PurchaseOrder.TxnID
    TxnItemLine.LinkedTxnLineID = PurchaseOrderLineDetail.TxnLineID
    TxnItemLine.LinkedTxnID = ??

    Which value store in LinkedTxnID ?

    #62340

    purchasing3
    Premium Member

    Yuden/Tom- Can you please help us with above issue.

    #62377

    purchasing3
    Premium Member

    Synergration… Please refund premiums support amount. At this pace.. we cant work with your product.

    #62452

    Tom Crawford
    Keymaster

    We have refunded your payment for the premium forum support.

    I mistyped my original post it should have been:

    TxnItemLine.LinkedTxnID = PurchaseOrder.TxnID
    TxnItemLine.LinkedTxnLineID = PurchaseOrderLineDetail.TxnLineID

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

You must be logged in to reply to this topic.