Back to back orders  Topic is solved

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

Back to back orders

Postby perry » Fri Aug 27, 2021 1:12 pm

Hi Mike,

Just wondering if Jiwa has any plan on changing the existing b2b logic?

The way b2b works at the moment is you need to have a b2b SO + b2b PO and almost everyone wants to have line level b2b.
Mainly because customers want to combine stock items and b2b items on same PO, and also, having to switch forms to view orders is bit of pain.

I remember J6 (or even earlier version of J7) used to have SalesOrderLineID on PO Line. What was the reason to move that header level?

To do this with current version, I have to make few hacky customisations e.g. updating IN_Onbackorder table, mess with back order release (SP, sales order type in memory and line details events).
Perry Ma
S. Programmer
Lonicera Pty Ltd
http://www.lonicera.com.au
perry
Frequent Contributor
Frequent Contributor
 
Posts: 173
Joined: Mon Oct 27, 2008 2:26 pm
Topics Solved: 15

Re: Back to back orders  Topic is solved

Postby Mike.Sheen » Fri Aug 27, 2021 5:20 pm

perry wrote:Hi Mike,

Just wondering if Jiwa has any plan on changing the existing b2b logic?

The way b2b works at the moment is you need to have a b2b SO + b2b PO and almost everyone wants to have line level b2b.
Mainly because customers want to combine stock items and b2b items on same PO, and also, having to switch forms to view orders is bit of pain.

I remember J6 (or even earlier version of J7) used to have SalesOrderLineID on PO Line. What was the reason to move that header level?

To do this with current version, I have to make few hacky customisations e.g. updating IN_Onbackorder table, mess with back order release (SP, sales order type in memory and line details events).


SalesOrderLineID was introduced to the PO_Lines table in 6.4.19 and removed in 6.5.13 - it wasn't really used, however. It was populated only when a multi back to back Purchase Order had items added via the search window, selecting from the sales order specified on the PO header. I don't recall the intent of adding that fields but it simply wasn't used - backorder processing didn't use it, and only thing I can find in the source code for version 6 is the PO form setting the property of the PO Line object and the PO business logic reading and writing it to the PO_Lines.SalesOrderLineID field - but besides that it was not used.

But we don't have current plans to change the way B2B ordering works - by all means lodge an improvement request... but I know we've done plugins previously to make normal orders behave like b2b ordering - a button to "Create Purchase Orders" on the sales order form, when pressed creates a PO with line custom fields linking SO Line to PO Line and upon GRN activation a plugin pushes the stock to the sales order it was destined for.... no need for b2b forms at all!
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: Back to back orders

Postby perry » Fri Aug 27, 2021 5:37 pm

upon GRN activation a plugin pushes the stock to the sales order it was destined for.... no need for b2b forms at all!

yes! that's right! thanks!!!
Perry Ma
S. Programmer
Lonicera Pty Ltd
http://www.lonicera.com.au
perry
Frequent Contributor
Frequent Contributor
 
Posts: 173
Joined: Mon Oct 27, 2008 2:26 pm
Topics Solved: 15


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 2 guests