Inventory Export Add Supplier  Topic is solved

Discussions relating to Jiwa 7 plugin development, and the Jiwa 7 API.

Inventory Export Add Supplier

Postby Ernst » Tue Apr 13, 2021 9:44 pm

Customer would like to add Supplier Select to Inventory Export, With Supplier and Cost coming out on download.

Have got the Supplier in the Search box, But it has no value in, and the procedure wont pick any supplier.

Think I'm just missing a small link to the CR_Main table. Although my search link looks good. Can anybody see what ive missed?

Plugin and Procedure attached.
Attachments
usp_JIWA_Inventory_ItemList.txt
(7.2 KiB) Downloaded 674 times
Plugin Inventory Export to CSV.xml
(126.4 KiB) Downloaded 830 times
User avatar
Ernst
Kohai
Kohai
 
Posts: 242
Joined: Tue Feb 19, 2008 3:43 pm
Topics Solved: 13

Re: Inventory Export Add Supplier  Topic is solved

Postby Mike.Sheen » Tue Apr 20, 2021 1:18 pm

Check your casing in the rangesJiwaGrid_ButtonClicked method - your "Supplierlookup" case in the switch won't ever get reached because we're comparing with column.Tag.ToString().ToLower() - you need to have "supplierlookup", not "Supplierlookup".

Code: Select all
 switch (column.Tag.ToString().ToLower())
{
    case "partnolookup":
...
case "Supplierlookup":
   if (e.Row == 0)
...


You've modified our standard plugin - that's going to cause problems for you and/or your customer(s) down the track - you should always copy our standard plugins and adapt that!
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: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807

Re: Inventory Export Add Supplier

Postby Ernst » Tue Apr 27, 2021 10:10 pm

Thanks for that Mike. Have tried the lower case. But still no luck. Updated plugin attached.

Its giving a method or operation is not implemented, when trying the search button on supplier.

And does not start with from to values.

Must be missing something else.
Attachments
Plugin Inventory Export to CSV.xml
(126.4 KiB) Downloaded 791 times
User avatar
Ernst
Kohai
Kohai
 
Posts: 242
Joined: Tue Feb 19, 2008 3:43 pm
Topics Solved: 13

Re: Inventory Export Add Supplier

Postby Mike.Sheen » Wed Apr 28, 2021 11:31 am

Ernst wrote:Thanks for that Mike. Have tried the lower case. But still no luck. Updated plugin attached.

Its giving a method or operation is not implemented, when trying the search button on supplier.

And does not start with from to values.

Must be missing something else.


Well, you are getting a different error now that you've fixed the first problem, so I wouldn't call it no luck - it's progress!

The not implemented exception is because you're calling a Search method of the Supplier entity, and our base Supplier entity class has not implemented that.

You'll have to create your own class inheriting from the Supplier entity and override the Search method and implement a search in there, and change your code to use your new inherited class.

I expect all this is beyond your abilities - so perhaps you can engage us to do it for you via the helpdesk as a quote request.
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: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807

Re: Inventory Export Add Supplier

Postby SBarnes » Wed Apr 28, 2021 3:27 pm

If you want an example of what Mike is referring to have a go at it take a look at JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Inventory with a tool like JustDecompile it implements the search functionality for inventory otherwise as Mike suggested ask Jiwa to quote on doing it.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1696
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 191

Re: Inventory Export Add Supplier

Postby Ernst » Wed Apr 28, 2021 5:35 pm

OK thanks for the help. When I have some time in the holidays, I'll try those things.
User avatar
Ernst
Kohai
Kohai
 
Posts: 242
Joined: Tue Feb 19, 2008 3:43 pm
Topics Solved: 13

Re: Inventory Export Add Supplier

Postby pricerc » Tue May 04, 2021 3:28 pm

Ernst wrote:OK thanks for the help. When I have some time in the holidays, I'll try those things.


you get holidays?
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 518
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 21

Re: Inventory Export Add Supplier

Postby Ernst » Thu May 06, 2021 10:41 am

I was being sarcastic. That means, it will never get done.. :D
User avatar
Ernst
Kohai
Kohai
 
Posts: 242
Joined: Tue Feb 19, 2008 3:43 pm
Topics Solved: 13


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 0 guests