27 replies to this topic

[LaRetta]

This only helps if someone has Access?  I no longer have Access, sorry.   Can you just answer my questions that I have asked over and over?  Otherwise someone else will need to assist.

[moj6054]

I create order table for, That product's qty less than order Item lines, I mean, I have a product (A) with 10 qty,
When a sell man choose this product for invoice line Item, for example 11, a new order create according with this invoice ID and Date for clear, so I need a script for check this  qty, and create automatic order, and when I buy this product, add to qty product,
I send access sample,because that create this sample very nice.
I hope ,I answer to your question

[LaRetta]

Hi Moj,

Just because you place a restock order for a product does not mean it is instantly back in stock and available for resell, does it?  So you should not count it in your cQtyInHand calculation as 'available' just because it exists on a reorder Order form.  Your product quantity should not increase until the product is physically received and a human checks it off of the packing slip as it is unpacked.  Only then is that quantity available for resell.

In the same light, you normally would not create a reorder for a product every time someone buys it.  Instead, each product should contain a field called LowStock (number) which means that when your balance on hand for that product hits this number, it is time to reorder.  If Customer Smith orders 5 Widgets and Customer Brown orders 3 Widgets, you do not want to create two orders (one with 5 widgets and one with 3), do you?  Ideally you should create ONE reorder with 8 widgets.  And if that manufacturer (or jobber or whomever you get your products from) also supplies you with other products, you should check their quantities and add those other products to the same reorder form, shouldn't you?

How you get your products and do you have multiple vendors?  Also, it appears that you allow backorders on your invoices so it will help if you explain your business policy on backorders.  Now, this is business as usual ... but I still lack understanding of your business situation so it might not fit. You had also asked for an example of how I would structure an Inventory process.  I would be more than happy to provide an example but I am currently swamped and that is not a simple thing to put together (it is liken to asking for example on payroll) ... maybe I can git er done this weekend.

In meantime, please answer the questions I have asked here and explain more about your business and how your products are handled.  I believe we are also dealing with a bit of language barrier, also suggested by your Price field in Boards, so please take your time and tell me about your products and why you want to place individual reorders every time someone buys a product from you. :^)

[moj6054]

Thank you,
according with your suggestion, My real problem is this.
how i can design my table for this problem? I saw in access sample, a "transaction table", between order and product design, and when , enter a date for buy the product, then qty  add to stock.
I want to know how can design this table for my problem,

[LaRetta]

If you will be creating one order for every single time a single Invoice then why not just duplicate your Invoice and call it an Order?

[moj6054]

Hi,
If you can see the access sample, every thing will clear for you.

[LaRetta]

I can't.  I guess someone else will have to assist, sorry.

[moj6054]

hi,
How I can create a script for add qty (order) to product qty?