Project Name Population on Bill Variance Journal Entry
An automated solution to update the Bill Variance Journal Entry with the Project Name based on the originating Purchase Order. A saved search, containing the Bill Variance Journal Entry lines, the Project Name from the Purchase Order, and the value of a custom checkbox is used by a Map/Reduce script to process the record update. Once the record has been updated, the custom checkbox will be marked as true – this flag removes the record from the saved search preventing it from being included in the update. The Map/Reduce script is triggered on demand by users through a suitelet.