POD adjustments

rsfairbanksrsfairbanks Member Posts: 107
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)");

Comments

  • rsfairbanksrsfairbanks Member Posts: 107
    Sorry - should be

    IF ("Qty. to Receive" + "Quantity Received" -"Quantity Invoiced"< 0) OR
Sign In or Register to comment.