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
PO/ Serials
Aug 15, 2008
3 Replies
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,
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required