Home › Forums › OpenSync › 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 3 years, 2 months ago.
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.
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.
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
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 ?
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 ?
Yuden/Tom- Can you please help us with above issue.
Synergration… Please refund premiums support amount. At this pace.. we cant work with your product.
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
You must be logged in to reply to this topic.