Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Stock Inventory ystem with Variable prices


tadpole2frog

Recommended Posts

Hello Everyone, i hope there is someone out there who can help.

i have developed a stock system that is predominantley made up of three databases.

stocksys (the overview), Stocktake and stock entry.

 

my problem is as follows.......

 

if i buy a 10 widgets today at £1.00 each and over the next few days sell five of them i still have 5 in stock at £1.00 each. if i then get another delivery of widgets, 10 at £2.00 each (the price has gone up). when i sell some more,lets say two, i want to deduct them from the first order. so the system will tell me i have three left at £1, and 10 left at £2.

 

in a nutshell i want the system to deduct sales from the first available stock. this could be done by date and quantity available..... i think.

 

please help.

 

Regards

Link to comment
Share on other sites

thanks for the email, thats what i said to the users. but because they work on Gross Profits per month. at £1 they make more profit as they would if they were £2, if the price they charge stays the same.

Link to comment
Share on other sites

abit more info.....

 

a user will enter stock into the stock entry database, they will enter the quantity and cost.

 

when stock is used they enter the details in the stock take database.

 

both databases feed into the stocksys database, the info from both databases is shown via portals.

 

the sale prices are entered into this system

 

regards, and thanks

Link to comment
Share on other sites

I believe this has to be scripted.

 

You will need another file, to break up the sale into individual items, according to which purchase they refer to. And after each item is created, the script needs to update the sold quantity in the original purchase record.

 

Example:Code:


PURCHASES (before sale):

PurchaseID Date Product Qty. CostPer Sold QtyOnHand

001 1/1/05 Widgets 10 1.00 10

002 1/2/05 Widgets 7 2.00 7

 

SALES:

SaleID Product Qty. Price

001 Widgets 12 2.50

 

SALEITEMS:

SaleID PurchaseID Product Qty. CostPer Price Ext.Profit

001 001 Widgets 10 1.00 2.50 15.00

001 002 Widgets 2 2.00 2.50 1.00

 

PURCHASES (after sale):

PurchaseID Date Product Qty. CostPer Sold QtyOnHand

001 1/1/05 Widgets 10 1.00 10 0

002 1/2/05 Widgets 7 2.00 2 5


 

The relationship from SALES to PURCHASES is based on:

SALES::ProductCode = PURCHASES::cProductKey

 

where cProductKey =

Case( cQtyOnHand , ProductCode )

 

and is sorted by Date.

Link to comment
Share on other sites

[ QUOTE ]

i think he means first in first out pricing

 

 

[/ QUOTE ]

 

If anyone pays attention to gas prices

 

it should be price goes up ...raise inventory prices immediatly.

price goes down... leave it alone until you are sure all the higher priced items are sold.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...

Important Information

Terms of Use