AP510 Vendor Conversion

AP510 cannot be used to update existing vendor records. When you run AP510 it interfaces APCVENMAST records into the APVENMAST table. Once the records are interfaced to APVENMAST they need to be maintained on AP10.

You could use addins to make name changes.

The update flag allows you to run the AP510 in report mode before interfacing the records into the APVENMAST table. You could then use the AP51 screen to make any changes that might be necessary before running AP510 in update.

So, what are the options available for us to update particular fields in the APVENMAST table? OR insert new vendors as needed.  This is an automation that our accounting department is inquiring about.      If an employee is created in Employee Table, then I want to take fields from that new Employee Record (SSN, Name, etc) and create a new Vendor record in APVENMAST.  (This would only be done for new employees). Any good ideas on how someone would do this?  I thought I could populate the APCVENMAST table and SUBMIT the job AP510 job using a WebRun in Process flow.  I thought I could do this for  changes also (to existing vendors that are in our EMPLOYEE table).   Thanks for any ideas you may have.

Wanda

 

Do you have MicroSoft Addins? You could use this tool to upload vendor changes from a spreadsheet.

You can use APCVENMAST / AP510 to add new vendors, but once the vendors exist in Lawson you'd need to use AP10 to make changes. Addins can be used to automate AP10 changes.

Brad

Thank you for the answers! It helps alot.