Hi,
When in Column WarrantyOK i have an invoice number + TG (for example A76541TG) the ledger associated to that invoice is 630000. The 2 other lines have different ledger. I want all lines from the same invoice to have the ledger from column chanumTG
In that case those 3 parts should have 630000 in chanumTG
pnum | pnom1 | WarrantyOK | Parts or Claim | fdglven | chanum | chanumTG | chanumbooleen |
470028 | VALVE A GAZ RESERVOIR 25 LITRES | A76541TG | CLAIM | 300652 | 300652 | VRAI | |
TG-ENRO | RÉPARATION/GARANTIE ENRO | A76541TG | CLAIM | 630000 | 630000 | 630000 | VRAI |
TRANSPORT | À DÉTERMINER | A76541TG | CLAIM | 300752 | 300752 | VRAI |
Thanks
Solved! Go to Solution.
The attached simple workflow could be added to your workflow to get the proper ledger number. The important part is sorting by the Warrant field and then the chanumTG field in Descending order, so nulls are last.
Then use the multi-row formula tool to update ChanumTG. You should Group by Warranty, set it to you the closest valid row and the formula should be [row-1:chanumTG]
Thanks for the fast answer Nick. I have version 11.0.6.28907 and if i do check for updates - no updates available. I cannot open your file it says its been created by a more recent version
thanks
Edit: Nevermind there's 11.5 on the website i will install that one and keep you posted
Works perfectly
thanks