Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Latest Posts

Re: inventorie "frozzen stock at date"
@Fred Thanks Fred, In fact, it's all good now. In addition, I see that you had already given me this information in the old post. But I hadn't seen her. Everything was drowned in the mass of comments.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
inventorie "frozzen stock at date"

Hello everyone. I only speak French, so this is a translation via GoogleTranslate. I come back to you regarding the creation of an inventory. I recreated a new question because the old one had become…
- Didier_Schoonjans
- 2 yrs ago
- 2replies
- 62
- Get help
- Answered
- Answered
Re: Script for Inventory
@Fred Unfortunately, I will not be available for the next few days. I'll be back this Monday, and look at all that as soon as I get back.
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred Hello Fred, Here I have freed up time to look in detail at the changes you have made. Sorry, but that's not right. In the "Items" table there can only be one "Stock" field, not three.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred Hello Fred, First of all, thank you for your work and your patience. For information, I'm not much available today and I will be away for the next few days. I return on Monday February 20.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred I found a solution that doesn't change anything to my buy and sell tables. Everything works fine, stock corrects without error. I go through an intermediate column "Frozen Stock" that I have to…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred Good morning. Thank you for your intervention, but the stock of items "Articles" does not change once the inventory has been validated
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred good evening, I don't understand exactly what you explained (it's certainly because of google translate) On the other hand, do not hesitate to set up your solution in the SoundProcess(Testing)…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred For the moment, if I create an Inventory on February 12, with for example an article which has 10 pieces in stock. In the "Inventory" table, the "stock" column will display this item with 10…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred GREAT, I put my finger on the problem. In reality, I put the theory to the test and I found a detail that makes all the difference. When carrying out an inventory, things must be done in order.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred To explain everything to you in detail. The stock lives with the movements of purchases and sales, hence the fact that the "Stock" field is necessarily a formula.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred Finally, it is what already exists. I have : - A table for purchases (with a sub-table that stores the data) - A table for sales (with a sub-table that stores the data) - A table for the…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred I don't quite understand what you are explaining? The stock of an item changes, depending on: - purchases - Sales - inventories (compulsory at least once a year) - fabrications (that's for…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred Good morning, I would like the stock to live, keeping the history of all movements. Exactly like purchase orders and sales invoices. So a solution with two different stocks is not suitable.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred yes I understand the theory, but I do not see how to apply this in my case.
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred In my article file I have a box that allows the management of the "stock" (formula). The value of this box depends on the number of purchases and sales.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
In my article file I have a box that allows the management of the "stock" (formula). The value of this box depends on the number of purchases and sales. From this side everything works perfectly.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
Hello Fred, Well, I think I managed to figure it out. Anyway, everything is working fine. Do not hesitate to criticize me if it is possible to make the code simpler I adapted your code to get by.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
Hello Fred, I'll try to manage on my own (it's the only way to learn), if I don't, I'll come back to you. And thank you again for your help. Didier
- Didier_Schoonjans
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Script for Inventory
Thank you very much Fred. What a nice surprise to connect to my DataBase this morning and find a red button in my Inventory table. You did what I originally wanted to do. Thank you so much.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
hello fred I found to replace the "dynamic multiple field" by a "single choice dynamic field" and adapt my formula. However, I still haven't figured out how to fill in the table. it going :)
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
In the "articles" table, I classify the different "article" by families. The purpose of the "Product_Families" table is to allow the use of a filter during inventories to select:…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred NINOX support tells me that I can simply invite you to my database. For this I need your e-mail address which must be linked to a NINOX subscription.…
- Didier_Schoonjans
- 2 yrs ago
- Get help
- Reported - view

1 2 3

Back to top

Overview

View all topics