Warning: iconv_mime_decode() [function.iconv-mime-decode]: Malformed string in /home/rockryno/public_html/lib/standard.lib.php on line 2258

Warning: iconv_mime_decode() [function.iconv-mime-decode]: Malformed string in /home/rockryno/public_html/lib/standard.lib.php on line 2258
PO/ Serials
Home Page link  

PO/ Serials

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
PO/ Serials Sad 08-15-2008
Posted by Sad on August 15, 2008, 12:55 pm
Please log in for more thread options

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 by convoluted on August 19, 2008, 12:37 pm
Please log in for more thread options

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.

Hope this helps.....

"Sad" wrote:

> 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 by Sad on August 19, 2008, 12:58 pm
Please log in for more thread options


thank you convoluted, i`ll try to make a report ( i am using acces 2007)
best reqards

"convoluted" wrote:

> 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.
>
> Hope this helps.....
>
> "Sad" wrote:
>
> > 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 by Sad on August 19, 2008, 1:06 pm
Please log in for more thread options


hi ,
this report will help me to track a serialized item by PO then by vendor,
that many serialized items come from more than one supplier .

"convoluted" wrote:

> 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.
>
> Hope this helps.....
>
> "Sad" wrote:
>
> > 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

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap