Method Community

In QuickBooks there is a PO No. field on the Item Receipt lines and the Bill Lines. In that field the PO number is automatically displayed and is grayed out showing what PO each line is connected to.

Where is this field in Method? I see there is a field in Method's Item Receipt Line table called Link To Purchase Order, so I added that field to the grid  on the Item Receipt (old version. new version doesn't give me the option to add it to the grid). The field shows up as a drop down allowing me to select whatever ID from the POLine table I would like.

I don't know what to do. I would like the Item Receipt Lines to be connected to the PO lines like they are in QB. I would like to be able to easliy see what PO the receipt line belongs to.

No can do without alot of customization and even then I'm not sure, because... the sync engine deletes data from any field i add to the grid. 

Stumped...

Any and all ideas are appreciated. I would like the PO number to show on each of my item receipt lines.

Lance,

I think your answer here may be linked fields and linking the RefNumber from the PO table into the BillLineItem and ItemReceiptLineItem but it looks like for some reason it is not allowing that field to be linked. I am going to have to look into this further.

-Michael

Yeah, it's weird. I tried to add a liked field to the PurchaseOrderLine table on the ItemReceiptLineItem table, but it did't give me the option for that table even though there's already a dropdown field for the PurchaseOrderLine.RecordID.

Another interesting fact is the ItemReceiptLineItem.LinkToPurchaseOrder field populates after lines are added from the Add PO popup screen, but after a qb sync the data is wiped out.

Hi Lance,

Try this again now. It should be working.

-Michael

Hi Lance,

I am going to have to confirm that and do some tests. I will get back to you on it.

-Michael

Hi Lance,

I was able to duplicate what you mentioned and will create an internal ticket for this.

-Michael