• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

P47131 Back Order quantity not correct for Quantity Increase (QI) transaction in A7.3

JohnP

Member
P47131 (EDI Purchase Order Change Edit/Create),
does not take existing order quantity into account when an Order Quantity Change Increase transaction is processed. (See Example below)
QI (Quantity Increase) transaction is in File: F47132* Field:* SZCHGC (Change Code)
As a result the Back Order quantity is not correct.
Note: I know P47131 calls P42997 (Inventory Availability/Commitment) which I believe is used to determine the item availability and changed Sales Order quantities.

Also, I tested Sales Order Quantity increase with P4211 using the same order (as used in P47131)* and the Back Order Quantity is correct.
Not sure why there is a difference (in the Back Order quantity) between P47131 and P4211 when I increase the Order quantity.
Note: P4211 also calls P42997* (Inventory Availability/Commitment)


** EXAMPLE **

A). F4211 Qty fields after Sales Order Created
SDUORG = 2000
SDSOQS = 2000
SDSOBK =* 0
SDSOCN =* 0
Note1a: We display 2 decimals for Qty

B). Available Inventory before I change the Qty on Sales Order = 5.00

C). This is how F47131 & F47132 are populated
SZUORG = 1000
SZSOQS = 0
SZSOBK = 0
SZSOCN = 0
SZCHGC= QI
Note3a: F47131: SYTPUR = 04
Note3b: We display 2 decimals for Qty
Note3c: Value reflects my request to* change Order Qty from 2000 to 3000.
An increase of 1000

D) This is how F4211 is populated After P47131 processing:
SDUORG = 3000
SDSOQS = 500
SDSOBK =2500
SDSOCN =* 0
Note4a: We display 2 decimals for Qty

Note: Available Inventory after P47131 is executed = 5.00-

Problem/Questions:
Why did it only Ship Qty of 500 (SDSOQS)?
I expected the SDSOQS to be 2500 and the SDSOBK to be 500 Since there was still Qty of 5.00 available after the Sales Order was created.
And no other Sales Order activity occurred after the Order was created beside my request to increase the Sales Order by a Qty of 1000 (used in this example).

As previously stated if I do the same change in P4211 results are Qty of 2500 is Shipped
and Qty of 500 is Back Ordered and Available is 5.00-
This is the correct result.

Why the difference when I use P47131?


Anyone using P47131 for Order quantity changes and having this issue?
Any help is appreciated

Thanks
John
 
Top