Share
Report
2Hello All,
I am currently working on a solution that entails changing the OOB /Line Amount/ field to adjust based off of commission %. This amount is modified correctly on the sales lines, however when I preview the sales order posting, or post the sales order - the adjusting line value /Line Amount/ Changes back to what it was prior to the modification.
I have been looking through the sales-post code unit trying to use integration events to no-avail , has anyone worked with anything of this nature before that could offer solutions on how to take the current values from the sales lines to the G/L Entries and Posted Sales invoice lines. Rather than them recalculating the base values?
TIA!
Here are the values I'm modifying on the sales line when commission % is modified -
I want these changed values to carry over to the Posted Sales Invoice Lines.
modify(/GCB Commission %/)
{
Trigger OnAfterValidate()
begin
if /GCB Commission %/ = 0 then begin
/Rep Order Amount/ := 0;
/Line Amount/ := /Unit Price/ * /Quantity/;
/Amount Including VAT/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
/Amount/ := /Unit Price/ * /Quantity/;
/VAT Base Amount/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
/Outstanding Amount/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
/Outstanding Amount (LCY)/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
// /Amount Including VAT/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
end
else begin
/Rep Order Amount/ := /Quantity/ * /Unit Price/;
/Line Amount/ := (/Unit Price/ * /Quantity/) * (/GCB Commission %/ / 100);
/Amount Including VAT/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
/Amount/ := (/Unit Price/ * /Quantity/) * (/GCB Commission %/ / 100);
/VAT Base Amount/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
/Outstanding Amount/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
/Outstanding Amount (LCY)/ := /Line Amount/ + (/Line Amount/ * /VAT %/ / 100);
end;
end;
}
All responses (
Answers (
