We have a somewhat complicated scenario involving AR files from our Corporate office. In short, they send us AR files which dummy account numbers (we've asked repeatedly to change his process, but probably wont happen!). Then our accounting department has to manually change the dummy account numbers to the correct ones depending on if there is a specific PO number in the AR file.
Essentially what we are looking to do is whenever we receive an AR file, search the beginning of the "Purchase_Order_Number" field in the file, if it starts with 1 of 5 different identifiers, change the existing account number to a different one.
Mapping would be like this-
PO field starts with:
DEN --> change account number to 10276
KCY --> change account number to 10278
MIN --> change account number to 38675
SLC --> change account number to 10274
STL --> change account number to 10279
I presume this would take some custom code and we are light on that skillset, so any help is greatly appreciated!
Please sign in to leave a comment.