Page 1 of 1

selling price categories

PostPosted: Tue Dec 12, 2023 4:30 pm
by JuiceyBrucey
Hi, sorry if this is in the wrong place but I could not find a "new topic" button in the other topics. I have also looked online for an answer to this question in the tutorials and could find nothing that explains it.
7.2.1 SR 16
I currently have inputs in the inventory prices form for P1, P2, P3, so I can put in the prices. For testing purposes, I need to have P1, P2, P3, P4, P5, P6, P7, P8, P9 displaying (if that is possible) so that I can input test data and extract it for another program.
How do I make these other inputs visible and functional?
Thank you
Cheers

Re: selling price categories

PostPosted: Tue Dec 12, 2023 4:46 pm
by Scott.Pearce
Can you provide a screen shot of this "inventory prices form" of which you speak?

As far as the desktop client is concerned, there are 10 price columns on the grid at Inventory->Maintenance->Prices->Selling Prices. Unless explicit permissions have been set for the user you have logged in as, all should be visible and editable.

As far as the database is concerned, there is a table called IN_SellingPrices which contains 1 row for each inventory item with P1 through to P10 columns holding the values.

Re: selling price categories

PostPosted: Tue Dec 12, 2023 5:05 pm
by JuiceyBrucey
That was quick.
Please see attached screenshot with explanation of what I am trying to achieve.

I was not able to follow this trail.
"Inventory->Maintenance->Prices->Selling Prices"

Did you mean:
Inventory->Maintenance->(Inventory Item)->Prices->Selling Prices

Thank you.
Cheers

Re: selling price categories  Topic is solved

PostPosted: Tue Dec 12, 2023 6:56 pm
by Mike.Sheen
JuiceyBrucey wrote:Hi, sorry if this is in the wrong place but I could not find a "new topic" button in the other topics. I have also looked online for an answer to this question in the tutorials and could find nothing that explains it.
7.2.1 SR 16
I currently have inputs in the inventory prices form for P1, P2, P3, so I can put in the prices. For testing purposes, I need to have P1, P2, P3, P4, P5, P6, P7, P8, P9 displaying (if that is possible) so that I can input test data and extract it for another program.
How do I make these other inputs visible and functional?
Thank you
Cheers


The prices you want to see are not being shown because they are either hidden or sized to 0 width.

Right click on the column header and choose "Manage Grid" from the context menu, and from there you can make the columns visible again.

Re: selling price categories

PostPosted: Wed Dec 13, 2023 7:43 am
by JuiceyBrucey
Excellent.
That worked.
Much easier to work with now.
Thank you.
CHeers