Page 1 of 1

Back to back orders

PostPosted: Fri Aug 27, 2021 1:12 pm
by perry
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).

Re: Back to back orders  Topic is solved

PostPosted: Fri Aug 27, 2021 5:20 pm
by Mike.Sheen
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!

Re: Back to back orders

PostPosted: Fri Aug 27, 2021 5:37 pm
by perry
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!!!