Decrease stock quantity from item sold when sales completed

[Kishan_Canoo]

Good day,

I have a point of sale solution and i have also a stock module attached to the solution.

Basically the main function will process each item sold from the Point of sale screen whatever the quantity and will reduce the stock quantity on the stock layout after complete the transaction.

Also if ever i want to delete the complete sale i would like a script to re-update the stock quantity and delete the transaction.

I am unable to perform this task and it was much harder than I thought.

I have attached an example of my solution for your touch.

I would also request if it could make it simple as possible.

Thank you for your precious time and help.

 

POS.fmp12

[bcooney]

I think that you'll find Daniel's posts on this topic very useful:

http://www.newleafdata.com/downloads-fmp.html

[Kishan_Canoo]

It's a bit complicated!

[Lee Smith]

Maybe this article and file by Todd Geist will help you https://www.geistinteractive.com/2010/04/21/inventory-transactions/

[Kishan_Canoo]

I finally found a solution but I don't know if It is the correct one..it is too good to be real.
Would it be possible for you to confirm if i made it in a proper way?

I have attached a sample.

Point of Sale.fmp12

[dwdata]

Hi Kishan_Canoo,

I would modify the data structure to allow for adding stock to products and having a record of when it was adjusted.

Attached is your modified file. I added a new table called "Stock" and added a button to EDIT Stock. Click into the last row of the list to add more stock.

Tear it apart to examine it. If you have questions, please post them.

Good luck!

Point of Sale2.fmp12

[Kishan_Canoo]

Thank you very much for your help dwdata.

Much appreciated!

 

[bruceR]

I notice a fairly serious error in the Item table. It has an ID field, defined to auto-enter a serial number.

But this Item record ID is used as the relation key to connect it to the order and it gets overwritten when the order is built.

Thus there really is no Item record ID.

The Item record should have a field IDf_sale, which should not be defined as a serial number, and which should be related to the ID field in Sales.

Point of Sale3.fmp12

Edited September 24, 2015 by BruceR

[Kishan_Canoo]

I have an issue regarding the calculation, actually everything is working well with the solution and the only problem may be happened if more items are added the system will get slower and slower.
If there is a way to avoid the system to become slower by using the actual method of calculation?

Point of Sale.fmp12

Point of Sale.fmp12

[bruceR]

You don't seem to be paying attention.

Design changes were already provided by DW; and I added a small further mod.

Your solution does not contain any of the advice provided. Why are you still asking questions?

[Kishan_Canoo]

OK BruceR.

Understood!

Thank you

[Kishan_Canoo]

The solution provided was very helpful and already added to the Point of sales software solution and it works fine. Thank you all.