Denver Research

Screen shot sent.

When I used the Define Product Case in the manner that you described it DID automatically fill the fields with the correct data when I supplied the item number.

When the "single" item is restocked from the "case" item the quantities are modified correctly.  The software appears to be multiplying when it should be dividing.

I purchase Pepsi in 36-packs to sell as singles.  I have records for "Pepsi - 36pk" and "Pepsi - Single".

"Pepsi - 36pk" has a cost of 12.29 and a Markup% of 45, causing Retail to be 17.82.

"Pepsi - Single" has a cost of 0.34 (12.29/36) and a Retail of 0.70.  When I select "Functions/Build from Parts" I see that I have selected "Case Definition".  I also see that the "Part#" is the correct number for "Pepsi - 36pk" as that is what is displayed in the "Description" field.  The "Qty" is set to 36.

This all appears to be correctly entered as, when the "Pepsi - Single" record has a Qty of 5 and I sell 6 the quantity in the "Pepsi - Single" record is set to 35 and the Qty in the "Pepsi - 32pk" is decremented by one.

EXCEPT for this odd behavior... when I close the "Build from Parts" window the Cost is changed from 0.34 to 442.44 and the Retail Price is changed from 0.70 to 641.52.  I have deduced that these numbers are derived by multiplying the respective numbers from the "Case" record times the "Qty per Case".

It WOULD be nice for the unit cost to be derived, automatically, from the Case cost; but I would, apparently, need to set the "Qty per Case to 1/32 instead of 32 - which would not allow the case-to-singles stock transfer to function properly.

I have found this to be repeatable with all such Case/Single pairings I have created.

What am I doing wrong?  Thanks.

I just used "product control" to receive gasoline and update the cost.  Ten days ago, when I performed this function all was fine.  Today I found the average cost to be $1.20.  I can't remember when I could get gas for that price....

I have yet to identify the "trigger" for these anomalies.

Sometimes, when adding inventory, I use the Inventory Adjust.  Other times, when time permits, I go to the product record directly to adjust the quantity and to check for cost changes.  The ONLY method I have ever used to change the quantity and cost of gasoline is by altering the record itself.

I checked yesterday's sales report to find a total income of $1400 and a cost of $6,853 for a Gross Profit of -$5497 (rounded figures).

Investigation found that the software decided - for whatever reason - to set the average cost of gasoline to $80.19.  So, that screws up the monthly report AND the historic graphs I had come to use.

This is not the first time this has happened.

Yesterday a sale was transacted and paid for with a Discover card.  The ezPos software did not register the payment and the transaction is listed as "Not Paid".  The card was run a second time to make the payment and it was reported as a "duplicate transaction", which it would have been. 

This morning I find that the Discover card was processed as the funds have been deposited into my checking account.  However, the payment has not been recognized by the ezPos.

How should I proceed to close this transaction and print the appropriate receipts?

This is a small matter, but it would be nice....

While receiving stock, under Products/Adjust Stock, I hear a pleasant little "Ding" when the scanner has understood the bar code and received one unit (in one-per-scan mode). 

Sadly, the computer makes the same happy little sound when it scans a UPC that is not in the database because it is a new product.

What would be nice would be to have the ability to modify the audio files so that an unrecognized or new UPC made an unpleasant sound, or say "Unrecognized Code" or something.

I know that the terminology can be modified, would it be difficult to allow for the modification of the sound files (that is, if the ability isn't already there someplace and I just haven't found it).  If the software just invokes a sound file I could re-name a more desirable sound-bite to that file name; but I'm guessing that the software invokes the same file whether the UPC is valid or not.

Thanks Ronald,
Lee

From another thread:

"The number used for the Total Assets is the Avg Cost field times the Qty field on all the products.  Check those fields."

Having learned this I checked one product that I sell... propane.  My most recent purchase was of 640ga at $2.88/ga. while the previous delivery was of 475ga at $2.74/ga.  Present inventory was reported as 858ga with a cost of $2.88/ga and an average cost of $2.49/ga.

Adhering to a "first in, first out" stock rotation policy (as is necessary with other, perishable items) my present inventory, 858ga, is 640ga at a cost of $2.88/ga and 218ga at $2.74/ga for a true "average cost" of $2.84/ga.  As 858ga is $2,436.72 at $2.84/ga and $2,136.42 at $2.49/ga it appears that my present inventory is being undervalued by $300.30.

Furthermore, whenever depleted stock is replaced it is immediately devalued unless the cost has not risen, resulting in an ever-increasing de-valuation unless the "average cost" is consistently reset.

I would prefer that the value of my stock was related to the most cost and not the average of what I have paid over the last few years.

"The Avg Cost can be set the Cost using the Tools / Set Avg Cost to Cost function."

Apparently, I shall be doing this often.