• Registered: 2024-04-27
  • Posts: 34

Topic: How to Approach Invoice/bill - Stock/inventory add it into Database?

Physical to digital

what I am trying to do

I have small computer shop 

I buy Items ---> goes into stock
I sell Items ---> deduction from stock(stock location)/bill the client ---> print, email
I sell Service -->Bill the client.--> print, email
bill clients ---> service or Item (provide discount if possible)
of course add taxes in bills
To track total invested in business
financial tracking
who paid on which date (closing of transection)
if not paid reminder(managing this with Samsung notes)
to whom and how much I owe dealer (open transection)
profit and loss.

I manage these with books.

How to approach invoice/bill and add it into inventory(like one bill no and add multiple entries) 
stock/restock inventory


If one of you have made something into past or some example module all will be helpful.

thanks and best regards

  • Registered: 2014-08-02
  • Posts: 961

Re: How to Approach Invoice/bill - Stock/inventory add it into Database?

Hello kavinacomputers

Welcome to VD !
Go to the Homepage and click on Database example
I see at least 2 examples that you could initially benefit from.
Then come back to us to go further.
Good luck
J.B.

  • Registered: 2024-04-27
  • Posts: 34

Re: How to Approach Invoice/bill - Stock/inventory add it into Database?

I guess

1>Customer Invoice - under database applications
2> ???

thanks

  • Registered: 2014-08-02
  • Posts: 961

Re: How to Approach Invoice/bill - Stock/inventory add it into Database?

Hello kavinacomputers

1 - If your form from which you are going to edit an invoice is complete (purchase cost, VAT, total cost, VAT detail, etc.) you place a button with Action Report; as a Dataset you declare your database and you personalize your invoice as you wish (logo, grid, images, etc.), you test in preview mode and when you are satisfied you save it under the name of your choice with the extension .fr3.
Knowing that you can always come back to it to modify it.
2 - As basic examples you can consult almost all of them, especially Customer Invoice.
Come back to us if you're stuck.
But the old grump in me will always tell you to first plan your project with a paper and a pencil. For a somewhat complex project, I rarely go directly into the computer. Then you transpose in MVD.
And browse the forum, there are surely examples involving invoices.
Good luck
J.B.

  • Registered: 2024-04-27
  • Posts: 34

Re: How to Approach Invoice/bill - Stock/inventory add it into Database?

which method is better

to reduce stock

Inward table (takes inward bill and add to stock)
Outward table(Outward gives bills to client and reduce stock)
Stock Table(have current stock details)
Transection Table(stores all transection ids)

What I can think of

method 1

update stock table using sql when sell/outward happens

task 1 - current stock = old stock - sold stock (sql to update stock table)
task 2 - stop stock value go under negative.(safe guard)

method 2

task 1 - undate sql stock table(calculated field may be) = inward table stock column - outward table stock column
task 2 - stop stock go in negative (how to lock this in database?)

thanks regards