Mass Update Gross Profit Calc Via DTW

[Former Member]

Anyone know how to mass update gross profit calculations via DTW?

We seem to have found a bug whereby the base price is 0, despite stock always having a price. We need to update 4000 docs where this is the case and get it to use calculated price.

We are on release 8.81 pl04.

[Former Member · Accepted solution]

Hi Ricky,

Yes it is possible: the Gross Profit Base Price field is in the row level table (RDR1) so you need to update the RDR1 - Document_Lines template. For updating you need the ParentKey (which is the order number), LineNum and GrossBuyPrice columns where you can define the base price for Gross Profit calculation.

I hope this helps.

Regards,

Nat