PO with multiple Lines - Entering bill with 1 Line - but entire PO closes.

Tagged: PO to bill conversation

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

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

Author
Posts
October 26, 2017 at 4:18 pm #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.
October 26, 2017 at 8:29 pm #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.
November 3, 2017 at 4:13 pm #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
November 6, 2017 at 12:19 am #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 ?
November 6, 2017 at 7:56 am #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 ?
November 6, 2017 at 11:30 am #62340

purchasing3
Premium Member
Yuden/Tom- Can you please help us with above issue.
November 8, 2017 at 7:32 pm #62377

purchasing3
Premium Member
Synergration… Please refund premiums support amount. At this pace.. we cant work with your product.
November 17, 2017 at 3:27 pm #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
Author
Posts

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

The forum ‘OpenSync’ is closed to new topics and replies.