Goods Received Note Entry cahnge from JIWA6

Discussions relating to plugin development, and the Jiwa API.

Goods Received Note Entry cahnge from JIWA6

Postby Luehman » Tue Mar 17, 2020 4:07 pm

Currently with JIWA6
We enter the Supplier Delivery Docket number into "Slip No" in Receive Ordered Goods and leave the Reference field Blank.
When entering the Purchase Invoice we can then select the "Slip No" to initiate the invoice.

In JIWA 7
If we enter Supplier Delivery Docket number into GRN No. it does not allow duplicates, even across different suppliers?
GRN No. appears to be an auto numbered field if left blank so if we enter the Supplier Delivery Docket number into the Reference field this works however when using Invoice Entry you now select the GRN number and not the "Reference" (delivery docket number). Can the fields be changed to show "Reference" rather than "GRN" which doesn't really relate specifically to the Delivery Docket.

Thank you
Luehman
Occasional Contributor
Occasional Contributor
 
Posts: 30
Joined: Tue Mar 17, 2020 9:48 am

Re: Goods Received Note Entry cahnge from JIWA6

Postby SBarnes » Tue Mar 17, 2020 4:29 pm

You should be able to do similar to your post here viewtopic.php?f=26&t=1274 and create a search that picks up the necessary extra fields the SQL currently used is shown below, so long as you keep RE_Main.PackSlipID as the first hidden field (column width = 0) it will work.


Code: Select all
SELECT RE_Main.PackSlipID, RE_Main.SlipNo, RE_Main.SlipDate, RE_Main.LastSavedDateTime, RE_Main.Freight,  RE_Main.Duty, RE_Main.Insurance, MAX(PO_Main.Reference)  FROM RE_Main  LEFT OUTER JOIN RE_OrdersUsed  ON (RE_Main.PackSlipID = RE_OrdersUsed.PackSlipID)  LEFT OUTER JOIN PO_Main  ON (PO_Main.OrderID = RE_OrdersUsed.OrderID)  LEFT OUTER JOIN PO_Workflows ON (PO_Main.PO_Workflows_RecID = PO_Workflows.RecID)  WHERE RE_Main.CreditorID = '000000001Z00000000QL' AND RE_Main.Status = 0  AND RE_Main.Invoiced = 0  AND RE_Main.IN_LogicalID = 'ZZZZZZZZZZ0000000000' AND  (  (PO_Main.Status > 8 AND 8 IN (SELECT StatusValue FROM PO_WorkFlowLines WHERE PO_Workflows_RecID = PO_Workflows.RecID UNION SELECT NextStatusValue FROM PO_WorkFlowLines WHERE PO_Workflows_RecID = PO_Workflows.RecID))  OR  (8 NOT IN (SELECT StatusValue FROM PO_WorkFlowLines WHERE PO_Workflows_RecID = PO_Workflows.RecID UNION SELECT NextStatusValue FROM PO_WorkFlowLines WHERE PO_Workflows_RecID = PO_Workflows.RecID))  )
 GROUP BY RE_Main.PackSlipID, RE_Main.SlipNo, RE_Main.SlipDate, RE_Main.LastSavedDateTime, RE_Main.Freight,  RE_Main.Duty, RE_Main.Insurance
ORDER BY SlipNo
Regards
Stuart Barnes
stuart@attkey.com.au
SBarnes
Jiwa Sensei
Jiwa Sensei
 
Posts: 816
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 71

Re: Goods Received Note Entry cahnge from JIWA6

Postby Mike.Sheen » Tue Mar 17, 2020 5:05 pm

This is a good candidate for an improvement - added as DEV-8172.

I had a crack at a little plugin to do this, but the problem is the GRN selection from the PI form is filtered by both the Creditor of the PI and the warehouse of the PI.

Using some ugly hackery I could have persisted and got it working, but decided it better to add an improvement and deal with it without ugly hacks.
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
Jiwa Shihan
Jiwa Shihan
 
Posts: 1640
Joined: Tue Feb 12, 2008 11:12 am
Location: North Sydney
Topics Solved: 522

Re: Goods Received Note Entry cahnge from JIWA6

Postby SBarnes » Tue Mar 17, 2020 5:33 pm

Would TSqlParser and grabbing the SQL off one of the existing options help or was that the hack you had in mind?
Regards
Stuart Barnes
stuart@attkey.com.au
SBarnes
Jiwa Sensei
Jiwa Sensei
 
Posts: 816
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 71

Re: Goods Received Note Entry cahnge from JIWA6

Postby Mike.Sheen » Tue Mar 17, 2020 6:23 pm

SBarnes wrote:Would TSqlParser and grabbing the SQL off one of the existing options help or was that the hack you had in mind?


No, but that is another avenue worth exploring... although the TSqlParser is a bit cumbersome to wrangle. It's a 5 minute fix to just add the improvement in the core code and ship it with SR4, more like an hour to do a plugin using the TSqlParser.

The hack I had in mind was to tuck away the PI object into the generic object collection of the Manager and in the Search.Showing handler of Application.Manager, retrieve that and build a new search option - as then we've have access to the creditor and warehouse of the PI.
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
Jiwa Shihan
Jiwa Shihan
 
Posts: 1640
Joined: Tue Feb 12, 2008 11:12 am
Location: North Sydney
Topics Solved: 522

Re: Goods Received Note Entry cahnge from JIWA6

Postby SBarnes » Tue Mar 17, 2020 6:34 pm

Either way suggested, would be a bit of a hack.

Does this highlight something that might be bigger than namely this one example, that in certain instances there are parameters that are needed in where clauses when you want to do a custom search and getting them there could prove to be difficult?
Regards
Stuart Barnes
stuart@attkey.com.au
SBarnes
Jiwa Sensei
Jiwa Sensei
 
Posts: 816
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 71

Re: Goods Received Note Entry cahnge from JIWA6

Postby Mike.Sheen » Tue Mar 17, 2020 6:42 pm

SBarnes wrote:Does this highlight something that might be bigger than namely this one example, that in certain instances there are parameters that are needed in where clauses when you want to do a custom search and getting them there could prove to be difficult?


Yes, Scott and I moan about the limitations and awkward nature of our search all the time.

As you know we've ventured recently into exploring how to re-do the search using SQL 2012's pagination syntax and eliminating cursors - and part of that would be making the search - to use the technical term - not suck :D

Throw the TSqlParser into the mix and a nice query builder could allow users to dynamically create their own queries, drag drop / GUI style like this:

QueryBuilder.PNG
QueryBuilder.PNG (12.78 KiB) Viewed 75 times
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
Jiwa Shihan
Jiwa Shihan
 
Posts: 1640
Joined: Tue Feb 12, 2008 11:12 am
Location: North Sydney
Topics Solved: 522

Re: Goods Received Note Entry cahnge from JIWA6

Postby SBarnes » Tue Mar 17, 2020 6:50 pm

Sweet (means not suck) :D

In the short term would being able to have a property that attached the owning form to the search object , let you get at things?
Regards
Stuart Barnes
stuart@attkey.com.au
SBarnes
Jiwa Sensei
Jiwa Sensei
 
Posts: 816
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 71

Re: Goods Received Note Entry cahnge from JIWA6

Postby Luehman » Wed Mar 18, 2020 8:01 am

So in short, currently we have to use the automatically generated GRN number as the selection to initiate the Purchase Invoice and link the receipt.

Thanks again for the quick response.
Luehman
Occasional Contributor
Occasional Contributor
 
Posts: 30
Joined: Tue Mar 17, 2020 9:48 am

Re: Goods Received Note Entry cahnge from JIWA6

Postby SBarnes » Wed Mar 18, 2020 8:40 am

As Mike stated it will be done in the next Service release so it will come down to when that is going to happen compared to your upgrade go live date otherwise it would be down to one of the two approaches we've mentioned done in a plugin.
Regards
Stuart Barnes
stuart@attkey.com.au
SBarnes
Jiwa Sensei
Jiwa Sensei
 
Posts: 816
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 71


Return to Technical / Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron