Mass Update Gross Profit Calc Via DTW
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.
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.