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

[purchasing3Premium 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.

[purchasing3Premium 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.

[Tom CrawfordKeymaster]

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

[jaydeepParticipant]

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 ?

[jaydeepParticipant]

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 ?

[purchasing3Premium Member]

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

[purchasing3Premium Member]

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

[Tom CrawfordKeymaster]

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