Skip to Content
0
Nov 29, 2016 at 01:46 PM

Issue in the calculation of Backorder

66 Views

Hi All,

I am facing an issue in the calculation of open sales order quantity in BI. I am using 2lis_11_v_ssl data source.

Scenario:

One particular sales order is open i.e. it has order qty = 200, confirmed qty = 200 and deliver qty = 200 but there is no goods issued against the delivery so we should have 200 open quantity.

2 lines are appearing in 2lis_11_v_ssl data source,

I am removing all the closed items from the data source i.e. code is written in start routine to pass Reverse image ('R') to all those records which have Lowest GI status = 'C'.

So, in this case as Lowest GI status is blank or 'A', record mode is not changed here.

In my target DSO, required and confirmed qty is getting to 400 rather as per function rule it should be 200 only. Please help me here, how to get the correct quantities.

Attachments

capture.png (4.0 kB)
capture.png (2.5 kB)