×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Intermediate tables?
Roy Casella
New Member
Posts: 7
4 år 5 måneder dager siden #9756
av Roy Casella
Intermediate tables? opprettet av Roy Casella
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
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
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Carl Fuentes
Moderator
Posts: 23
4 år 5 måneder dager siden #9764
av Carl Fuentes
Besvart av Carl Fuentes i emne Intermediate tables?
CC is not supporting this feature at the moment.
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Søren Beck Jensen
Administrator
Posts: 73
4 år 5 måneder dager siden #9765
av Søren Beck Jensen
Søren Beck Jensen
Founder, Component-Creator.com
Besvart av Søren Beck Jensen i emne 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
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Roy Casella
New Member
Posts: 7
4 år 5 måneder dager siden #9768
av Roy Casella
Besvart av Roy Casella i emne 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
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
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Søren Beck Jensen
Administrator
Posts: 73
4 år 5 måneder dager siden #9770
av Søren Beck Jensen
Søren Beck Jensen
Founder, Component-Creator.com
Besvart av Søren Beck Jensen i emne Intermediate tables?
Yeah, that does sound like it needs some custom development.
Søren Beck Jensen
Founder, Component-Creator.com
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Tid til å lage siden: 0.057 sekunder