Skip to main content

Ninox-Documentation

Didier Schoonjans

Didier_Schoonjans

54
3
0

Joined: Mon Jan 23 12:36:45 UTC 2023

My Posts

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
- 1 yr 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
- 1 yr ago
- 2replies
- 53
- 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred
- Didier_Schoonjans
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Script for Inventory
@Fred
- Didier_Schoonjans
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 2 3

Back to top

Ninox-Documentation

Overview

View all topics