unit price - Cost price with condition (date, price, and stock)

1. unit price - Cost price with condition (date, price, and stock)

Hii everyone,

in attach file, i already figure out which several table
which is sales table, purchase table, and inventory table (knowing stock items)

in sales table i have profit column where (unit price - Cost price)

anyone can help ?

Regards,
Ferry L.

Book1.xlsx

2. Re: unit price - Cost price with condition (date, price, and stock)

Deleted post.

3. Re: unit price - Cost price with condition (date, price, and stock)

Welcom to the forum,
The Inventory, what is the date taken? before purchasing, or after sales?
what kind of cost of your inventory? average cost or other?
for instance, 10-Jan, you sale 3 tables, the cost will be taken from 3 tables purchased in 1-Jan (10000) or from average cost (11000)?

Note: Sorry I found the notice just after replying has been sent

4. Re: unit price - Cost price with condition (date, price, and stock)

hallo bebo,,

thanks for help

inventory is taken after purchasing and also after sales
if any purchase so the stock inventory will increase depend on quantity in purchase
and vice versa

for instance,
10 Jan, i sale 3 tables so the cost price is using old stock which is purchase date 1-Jan (10.000)
and 11 Jan, I sale 1 table, so the cost price is using new stock which is purchase date 2-Jan (12.000)

so the sales table like this
Date Item Qty Unit Price Profit
10-Jan Table 3 20000 20000 - 10000 = 10000
11-Jan Table 1 20000 20000 - 12000 = 8000

again Really Thanks..

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1