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
- posted
15 years ago
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
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,
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.