PO/ Serials

hi, how can we connect between purchaseorder/purchaseorderentery table with serial table, that i need a report shows a serialized item by POs or TRX. thaks

Reply to
Sad
Loading thread data ...

Sad - I think you will have to either create a custom report yourself or use a SQL query to get your results. There is a table called purchaseorderentrydetail that tracks serial data - join purchaseorderentrydetail to purchaseorderentry on purchaseorderentrydetail.purchaseorderentryid = purchaseorderentry.id, join purchaseorderentry to purchaseorder on purchaseorderentry.purchaseorderid purchaseorder.id; track PO number on purchaseorder.ponumber

I have not seen an existing report that includes this type of data.

H> hi,

Reply to
convoluted

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.