Explanation of Integration between Chase Production and NAV

1. A Task Scheduler Application manages the scheduling and running of all scripts.
   
   
2. Master Files (Clients, Products and Suppliers) are created in NAV and are exported via scheduled database scripts to a Staging database. These are then imported via scheduled database scripts into Chase Production.
   
   
3. Worktypes in Chase are mapped to Posting Groups (Posting Groups determine which GL accounts a document line entry will post to) in NAV
   
   
4. Cost Estimates CE’s are created within Job Bags in Production and Client and Supplier Documents I.e. Tax Invoices and Credit Notes are generated based off the CE.
   
   
5. The Documents are exported into the Staging Database via Scheduled Database scripts as unprocessed.
   
   
6. The task Scheduler calls a Web Service within NAV which picks up the unprocessed documents and processes them. The document is duplicated in NAV and posted to the relevant Sub-ledger and General Ledger Accounts based on the Posting Group associated with each line on the document.
   
   
7. Below is a summary of the entries in NAV generated by the above.
   
   

Sales

• Entry to Sale Header Table with header information summed amount
• Entry to Sales Lines Table with line information and Sale and Estimated Cost amounts per line
• Entry to Customer Ledger with Amount and sales header information
• Entry to General Ledger per line affecting:
  
  • Debtors - Trade
  • Billing – Production Internal and/or Production External
    
    

If there are costs associated:

• Cost Accounts
• Work In Progress – External/Internal
  
  

If there is VAT included (Majority)

• VAT Output – Debtors
  
  

Purchases

• Entry to Purchase Header Table with information and summed amount
• Entry to Purchase Lines Table with line information and Purchase amount per line
• Entry to Vendor Ledger with amount and Purchase Header information
• Entry to General Ledger Per line affecting:
  • Creditors – Production
  • Work In Progress – External/Internal
    
    

If there is VAT included (Majority)

• VAT Input – Creditors
  
  

8. When a Job in Production is closed off and there is a difference between estimated cost and actual cost a Cost Variance statement is created in Production. This is exported into the Staging Database via Scheduled Database scripts as unprocessed. The task scheduler calls the web service which processes the Cost variances directly into the General Ledger.

9. Below is a summary of the entries in NAV generated by the above. 

Cost Variance

• Entries into the General Ledger per line affecting:
  • Work in Progress – External/Internal
  • Cost Accounts