Hello all,
We want to be able to amend a shipped or receipted quantity by a POD adjustment. It is not desirable to reverse the original posting as we want to track the adjusted amount. Also we want to keep it simple and not add new lines
I have amended this code on Qty to receive on Validate.
In testing it seems to work in that we can do a negative receipt, and I would like to add to sales line as well. Does anyone see any problems with costing etc?
From
{
IF ("Qty. to Receive" * Quantity < 0) OR
(ABS("Qty. to Receive") > ABS("Outstanding Quantity")) OR
(Quantity * "Outstanding Quantity" < 0)
THEN
ERROR(
Text008,
"Outstanding Quantity");
IF ("Qty. to Receive (Base)" * "Quantity (Base)" < 0) OR
(ABS("Qty. to Receive (Base)") > ABS("Outstanding Qty. (Base)")) OR
("Quantity (Base)" * "Outstanding Qty. (Base)" < 0)
THEN
ERROR(
Text009,
"Outstanding Qty. (Base)");
}
To
IF ("Qty. to Receive" + "Quantity Received" - "Quantity Invoiced" < 0) OR
(("Qty. to Receive") > ("Outstanding Quantity"))
THEN
ERROR(
Text008,
"Outstanding Quantity");
IF ("Qty. to Receive (Base)" + "Qty. Received (Base)" < 0) OR
(("Qty. to Receive (Base)") > ("Outstanding Qty. (Base)"))
THEN
ERROR(
Text009,
"Outstanding Qty. (Base)");
0
Comments
IF ("Qty. to Receive" + "Quantity Received" -"Quantity Invoiced"< 0) OR