Home Page link  

Physical inventory formula problems

 

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
Physical inventory formula problems Doug Pic-N-Pac 08-14-2008
Posted by Doug Pic-N-Pac on August 14, 2008, 10:57 am
Please log in for more thread options


I am having a problem with the physical inventory feature. This is the example

I pull a Item Value List report with only supplier as the filter. The total
on this report is as follows QTY: -5 EXTENDED COST - $10 (these are
minus's)
Now I go to the physical inventory and select NEW then ONLY ITEMS FROM
SELECTED SUPPLIERS and I choose the same supplier I choose on the ITEM VALUE
LIST I choose to update maching item and replace existing items. I am
importing 10 of the item that had a -5 when I started. Now when I calulate
now expected should read what my ITEM VALUE LIST started with which was -$10
but instead this is starting with a +$10???????? Those items were already
sold so my beginning inventory should not have been $10 it should have been
-$10. Right? This is how i think the formula is for the Summary EXPECTED
VALUE + OVER VALUE - UNDER VALUE= total of that supplier (or what ever your
filter is) If the formula is what i think it is that would mean that my total
would be $40 Which is not right. But when I run a report in Item Value list
again the correct total is right.

Posted by Doug Pic-N-Pac on August 15, 2008, 10:32 am
Please log in for more thread options


Is no one else seeing this problem??? If anyone is using this to see how much
is missing from inventory your figures are wrong if you have any minus in
your inventory


"Doug Pic-N-Pac" wrote:

> I am having a problem with the physical inventory feature. This is the example
>
> I pull a Item Value List report with only supplier as the filter. The total
> on this report is as follows QTY: -5 EXTENDED COST - $10 (these are
> minus's)
> Now I go to the physical inventory and select NEW then ONLY ITEMS FROM
> SELECTED SUPPLIERS and I choose the same supplier I choose on the ITEM VALUE
> LIST I choose to update maching item and replace existing items. I am
> importing 10 of the item that had a -5 when I started. Now when I calulate
> now expected should read what my ITEM VALUE LIST started with which was -$10
> but instead this is starting with a +$10???????? Those items were already
> sold so my beginning inventory should not have been $10 it should have been
> -$10. Right? This is how i think the formula is for the Summary EXPECTED
> VALUE + OVER VALUE - UNDER VALUE= total of that supplier (or what ever your
> filter is) If the formula is what i think it is that would mean that my total
> would be $40 Which is not right. But when I run a report in Item Value list
> again the correct total is right.

Posted by dan on August 18, 2008, 6:55 am
Please log in for more thread options


sorry no help, but plenty PLENTY errors in RMS. Be careful basing real
business figures in what you see!
PLANTY ERORS (intended)

> Is no one else seeing this problem??? If anyone is using this to see how
> much
> is missing from inventory your figures are wrong if you have any minus in
> your inventory
>
>
> "Doug Pic-N-Pac" wrote:
>
>> I am having a problem with the physical inventory feature. This is the
>> example
>>
>> I pull a Item Value List report with only supplier as the filter. The
>> total
>> on this report is as follows QTY: -5 EXTENDED COST - $10 (these are
>> minus's)
>> Now I go to the physical inventory and select NEW then ONLY ITEMS FROM
>> SELECTED SUPPLIERS and I choose the same supplier I choose on the ITEM
>> VALUE
>> LIST I choose to update maching item and replace existing items. I am
>> importing 10 of the item that had a -5 when I started. Now when I
>> calulate
>> now expected should read what my ITEM VALUE LIST started with which
>> was -$10
>> but instead this is starting with a +$10???????? Those items were already
>> sold so my beginning inventory should not have been $10 it should have
>> been
>> -$10. Right? This is how i think the formula is for the Summary EXPECTED
>> VALUE + OVER VALUE - UNDER VALUE= total of that supplier (or what ever
>> your
>> filter is) If the formula is what i think it is that would mean that my
>> total
>> would be $40 Which is not right. But when I run a report in Item Value
>> list
>> again the correct total is right.



Similar ThreadsPosted
Problems with Physical Inventory import April 5, 2006, 3:52 pm
Physical inventory July 25, 2005, 6:36 pm
Physical Inventory HQ March 2, 2006, 5:19 am
physical inventory May 1, 2006, 11:13 am
after physical inventory THEN what? December 13, 2006, 6:08 pm
physical inventory January 29, 2007, 3:17 pm
Physical Inventory February 16, 2007, 12:21 pm
physical inventory: What's the best way? February 28, 2007, 10:43 pm
physical inventory March 11, 2007, 9:44 pm
physical inventory March 16, 2007, 6:13 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