Customer Name 


  • Ajax Turner 

Customer Contacts 


  • Parrott, Lori – Accounts Payable Manager (Project Lead) - lparrott@ajaxturner.com 
  • Strickland, Melanie – Director of Accounting - melanie.strickland@ajaxturner.com 
  • Lorady, Steven - CFO - Steven.Lorady@ajaxturner.com 

Server Access  


  • Frevvo dbconnector Servers:  
  • ATCO-SQL-AP 
  • forms.vitalecm.com 
  • Frevvo App: forms.vitalecm.com 

frevvo 


Version/Tenant Information 


  •  11.0.12 

URL 


  • URL for frevvo forms: https://forms.vitalecm.com/frevvo 
  • URL for Space: https://forms.vitalecm.com/frevvo/web/tn/ajaxturner.com/u/8dcb291f-b280-4cd1-b4f0-6c5202a7d3cd/portal/AjaxTurner 

Database Connector 


  • ATCO-SQL-AP: E:\PIF Files\APP\database-connector-2.7.1 
  • Used for Vendor and Supplier searching on requisition form 
  • Data pulled from VIP using VIP DataSync service: C:\Program Files (x86)\PiF Technolgies\VIP DataSync 
  • Forms.vitalecm.com 
  • D:\frevvo\config --> Queryset: AjaxTurner 
  • Used to write back and retrieve all the following form data 

 


 


Forms 


  • Non-Inventory Requisition Flow 
  • Up to 3 Approval Steps based on requester/approver amount limits.  
  • If requisition_total > Limits 
  • Requester and Approver information pulled from Approvers and Requester Staging Form 
  • Write back to DB requisition, requisition_lines, requisition_gl and requisition_billback 
  • If requisition is not cancelled DocStarEmailImport = frevvo@ajaxturner.com for DocStar Import 
  • Email to requester copy of requisition and link to receiving form for the requisition 
  • Non-Inventory Requisition Receiving 
  • Receive against previously entered requisition by requisition_number 
  • Emailed to frevvo@ajaxturner.com for DocStar Import 
  • Write back to DB requisition and requisition_lines 
  • Departments – Staging for Departments  
  • Used for dropdowns in Gl Departments and Requesters and Approvers staging form 
  • Write back to DB department 
  • GL Accounts – Staging for GL Accounts 
  • Used for requisition GLs 
  • Write back to Db gl_account 
  • Approvers and Requester – Staging for Approver and Requesters 
  • Used in requisition for Requester dropdown 
  • Links user to their department, approval limits, and approvers 
  • Write back to DB approver_requester 
  • GL Departments – Staging for GL Accounts by Department 
  • Used to link departments to GL codes to filter GL codes shown on requisition 
  • Write back to DB gl_department