Home Page link  

Item Movement Report Amendment

  
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
Item Movement Report Amendment Ryan Faught 07-06-2008
Posted by Ryan Faught on July 6, 2008, 11:19 pm
Please log in for more thread options
 Dear all,

My business partner and I have the following requirement:

If we could have the Item Movement Report have the following additions:

1. Qty On Hand
2. Qty Committed
3. Qty Available (Ideally we would have a field that would total Qty
Sold and Qty Committed as to us that is what we need to see from an
order).
4. A filter for item.subdescription1

Any help would be 'greattttttly' appreciated.

Ryan



Posted by JerryData on July 7, 2008, 5:39 pm
Please log in for more thread options
 That's an easy one, just have to call that stuff in the report template and
save it as a memorized one, for example:
add this to SELECT Statement:
Item.QuantityCommittedAS QuantityCommitted,
then add the column:
Begin Column
FieldName = "Item.QuantityCommitted"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Quantity"
VBDataType = vbDouble
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1080
GroupMethod = groupmethodNone
End Column
email me directly if you need more help.
jerry@jrdata.us
--
-Jerry
JR Data Inc.


"Ryan Faught" wrote:

> Dear all,
>
> My business partner and I have the following requirement:
>
> If we could have the Item Movement Report have the following additions:
>
> 1. Qty On Hand
> 2. Qty Committed
> 3. Qty Available (Ideally we would have a field that would total Qty
> Sold and Qty Committed as to us that is what we need to see from an
> order).
> 4. A filter for item.subdescription1
>
> Any help would be 'greattttttly' appreciated.
>
> Ryan
>
>
>

Similar ThreadsPosted
Item Movement Report with On Hand and Reorder kudos to Akber - "Items - Item Movement Report.qrp.zip" yEnc (1/1) April 17, 2008, 2:02 am
Report on the item movement report should show qty on hand as we September 1, 2005, 10:37 am
Item Movement Report @ HQ December 20, 2005, 6:07 pm
Item qty/movement report January 15, 2006, 12:52 am
Item Movement Report July 22, 2006, 11:29 am
Item Movement Report August 6, 2006, 10:38 pm
item movement report July 3, 2007, 6:52 pm
Item Movement Report August 10, 2007, 10:16 am
Custom Item Movement Report October 11, 2005, 10:07 am
Report for Zero Item Movement - What *hasn't* sold February 28, 2006, 1:05 pm

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