× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Intermediate tables?

pred 4 rokmi 4 mesiacmi #9756 od R
Intermediate tables? bolo vytvorené R
Hi,

Can CC create intermediate tables so that the cascading effect of changes does not come through?

Classic example.

You sell your product which is an Orange at £0.75 per unit this week.
Next Orange increases to £0.80 per unit.
I want my order to retain the £0.75.
So this would normally require an Intermediate table to preserve the data at that point in time?

Many thanks in advance

R

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 4 rokmi 4 mesiacmi #9764 od Carl Fuentes
Odpoveď od Carl Fuentes na tému Intermediate tables?
CC is not supporting this feature at the moment.

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 4 rokmi 4 mesiacmi #9765 od Søren Beck Jensen
Odpoveď od Søren Beck Jensen na tému Intermediate tables?
This also sounds like the wrong solution for me. At least for the example provided. Instead simply add a "price" field to your orders table and store the actual price with the order when it is created. No need for any extra tables.

Søren Beck Jensen
Founder, Component-Creator.com

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 4 rokmi 4 mesiacmi #9768 od R
Odpoveď od R na tému Intermediate tables?
That is fine if that is your setup.

My requirement is not a sales order setup.. but that is the best way to describe as you have many sales lines per sales order.. each sales line can have many products either per sales line or several per sales line etc...

Thanks for replying so I know I need to do my own dev here.

Thanks

R

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 4 rokmi 4 mesiacmi #9770 od Søren Beck Jensen
Odpoveď od Søren Beck Jensen na tému Intermediate tables?
Yeah, that does sound like it needs some custom development.

Søren Beck Jensen
Founder, Component-Creator.com

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

Čas vytvorenia stránky: 0.053 sekúnd
Funguje na Kunena fórum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.