Share
Report.
*This post is locked for comments
You’re offline. This is a read only version of the page.
135
.
*This post is locked for comments
Hi Rain,
Note that my name is not Andrea. It is André, but that's forgiven.
When using display methods, you don't have the need for a new field. Then you can do the calculation in the display method on existing fields. It is just like the other examples on the on-hand form.
Hi Rain,
If the manager needs another view, then probably a display method as discussed before would be the best option. The on-hand form already contains a lot of display fields. You can review them to see what you need to do to achieve a new display method based on your calculation.
Hi AX2012,
As mentioned above by others and me, changing records in the InventSum table is a tricky one. Can you explain the need for the field AvailStore? If you can explain the business requirement, we can try to help you.
If you are trying this just for practice don't do it with inventsum table . Try to play with some other table. The way data gets inserted in inventsum is very different.
Ok, now I see what you're trying to do.
My code will work perfectly. The error you're getting now is for a different reason.
The error you're getting there is a duplicate record error, which means you're trying to create a record that already exists.
You can't and mustn't create InventSum records like that.
Not sure what you're trying to do with this mod, but you probably want to add code like this.Field3 = this.field2 - this.field1; on the insert() method of the inventSum table, before the super().
Someone who knows the whole inventory framework and inventSum table will be able to make a better suggestion.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (