Issue: The technician completes a job in FieldAware and it generates an FSO in NetSuite but the job cannot be converted to a Sales Order because of the error in the title.
Cause: This error indicates that an asset that was on the FSO in reference no longer exists in the current location thus causing an INVALID_KEY_OR_REF error. This happens when a technician processes two jobs for the same customer referencing the same assets but using different locations on those jobs. For example, a technician is scheduled for Job1 to go service PAK1 at Valley FD Location1. He performs a flow test and determines that PAK1 needs service. He then creates a new Job2 in FieldAware so that he can perform a warranty task on PAK1. When creating the new Job2 for warranty work, he chooses Valley FD Location2; PAK1 will be assigned to Location2. This means that Job1 and Job2 are now referencing PAK1 and the latter most job will take precedence. Thus, the FSO generated by Job1 will have the error because it cannot find PAK1 at Location1.
Resolution: The error message will reference the Netsuite Internal ID of the asset that is not assigned correctly. The italic numbers in this string represent the Internal ID of the asset. The underlined numbers represent the location Internal ID: Invalid custrecord_fajobitem_faasset reference key 12345678 for custrecord_fajobitem_falocation 1234
Open the customer account in NetSuite for which the FSO references and go to the Field Service tab. In this tab, select the Field Asset option and find the asset with the referenced Internal ID. Edit the asset and change it to the address referenced in the FSO. Go back to the FSO and click Update From Field. You should now be able to process the FSO into a Sales Order.
0 Comments