I am attempting to follow the instructions found under the topic "Receive Inventory with Bill: To create a Linked Bill from at Purchase Order".  It works as written but some of my receipts are not for the entire amount on the P.O. line.  Is there a way to indicate that the line item is only partially received in the current bill?

The whole story is that I am recreating an Enterprise data file from an old one, making changes to the item list and job list in the new file.  I have exported all the QB files from the original file and am trying to insert them into the new file after I make the changes to the item list (all using Access). So I have the old PurchaseOrderLinkedTransaction.  I don't see anywhere in that file the quantity of each line received.  Each entry in the POLinkedTransaction file comes through as completely received but I can see in the old BillLineItem File by the amounts that the PO is not fully received.

Currently I have input all the POs I wish to have in my new file.  I have built a query to select from the OLD PoLinkedTransaction only the lines which are for the PO's in my new data file.  Now I wish to create the linked bills for those items.  Using the method above my new bills do not match the amounts of the bills in my original file because each line is coming over as fully received.

Long winded! Sorry, Hope you can help me.

Pam

There are three fields that allow you to create a bill from a purchase order. LinkToTxnID1 used to specify an entire purchase order to duplicate or ItemLineLinkToTxnTxnID and ItemLineLinkToTxnTxnLineID can be used to create a line in a bill that is a copy of the purchase order line (as shown in: How do I convert a Purchase Order into a Bill? ). The problem is that if you use the line by line method you can only specify the link fields and not the item, desc qty or amounts fields. Also if you do multiple lines they must be in the same order as they are in the purchase order.

The only way to partially receive items using QODBC is to modify the orginal purchase order line by changing the line quantity to the quantity received and then create (add) a new line at the end of the purchase order for the item with the quantity not yet received.