selling price categories  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

selling price categories

Postby JuiceyBrucey » Tue Dec 12, 2023 4:30 pm

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
JuiceyBrucey
Frequent Contributor
Frequent Contributor
 
Posts: 142
Joined: Tue Aug 18, 2020 7:19 pm
Topics Solved: 1

Re: selling price categories

Postby Scott.Pearce » Tue Dec 12, 2023 4:46 pm

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.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 748
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 225

Re: selling price categories

Postby JuiceyBrucey » Tue Dec 12, 2023 5:05 pm

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
Attachments
FORUM_QUESTION_SCREENSHOT_1.png
JuiceyBrucey
Frequent Contributor
Frequent Contributor
 
Posts: 142
Joined: Tue Aug 18, 2020 7:19 pm
Topics Solved: 1

Re: selling price categories  Topic is solved

Postby Mike.Sheen » Tue Dec 12, 2023 6:56 pm

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.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2488
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 770

Re: selling price categories

Postby JuiceyBrucey » Wed Dec 13, 2023 7:43 am

Excellent.
That worked.
Much easier to work with now.
Thank you.
CHeers
JuiceyBrucey
Frequent Contributor
Frequent Contributor
 
Posts: 142
Joined: Tue Aug 18, 2020 7:19 pm
Topics Solved: 1


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 2 guests