Stock subtraction (1 Viewer)

G

Gismo

Registered User.

Local time

Today, 16:31

Joined

Jun 12, 2017

Messages

1,298

• Jul 14, 2017

• #1

Hi All, does anyone know where I could download as sample DB to see how to handle stock level in purchases and in sales. not sure how to go about it

 

MarkK

bit cruncher

Local time

Today, 06:31

Joined

Mar 17, 2004

Messages

8,180

• Jul 14, 2017

• #2

Typically this number is calculated from stock transactions like a bank balance. Your bank balance is...

Code:Copy to clipboard

Balance = Deposits - Withdrawals

QuantityOnHand is...

Code:Copy to clipboard

Quantity = Purchases - Sales

The theory here is that this number is never stored, but is in fact always calculated for a particular point in time from other data.
hth
Mark

 

G

Gismo

Registered User.

Local time

Today, 16:31

Joined

Jun 12, 2017

Messages

1,298

• Jul 14, 2017

• #3

so you will log all received, all sales then calculate the balance? should stock received and stock issued qty be in the same field with sales as a negative or 2 different fields for quantity?

 

MarkK

bit cruncher

Local time

Today, 06:31

Joined

Mar 17, 2004

Messages

8,180

• Jul 14, 2017

• #4

Gismo said:

should stock received and stock issued qty be in the same field with sales as a negative or 2 different fields for quantity?

Click to expand...

If I did it in the same table I would use the same field and then + or -. But some people will implement sales and purchases in different tables too. This is probably largely determined by the specific purpose of your system. Maybe only a sales system, or purchasing system, etc...
hth
Mark

 

G

Gismo

Registered User.

Local time

Today, 16:31

Joined

Jun 12, 2017

Messages

1,298

• Jul 14, 2017

• #5

Thank you so much, do you know where I could download such a sample db?

 

MarkK

bit cruncher

Local time

Today, 06:31

Joined

Mar 17, 2004

Messages

8,180

• Jul 14, 2017

• #6

Solving this problem is a significant hurdle in any business. Business rules are so customized, and people that can do that customization are unlikely to give it away.

Cheers,
Mark

 

jdraw

Super Moderator

Staff member

Local time

Today, 09:31

Joined

Jan 23, 2006

Messages

15,378

• Jul 14, 2017

• #7

Further to Markk's comments, you may find this Inventory article by Allen Browne helpful.

Good luck.

 

MarkK

bit cruncher

Local time

Today, 06:31

Joined

Mar 17, 2004

Messages

8,180

• Jul 14, 2017

• #8

Good link!!!

 

G

Gismo

Registered User.

Local time

Today, 16:31

Joined

Jun 12, 2017

Messages

1,298

• Jul 15, 2017

• #9

Thank you will have a look at the link