AX Integration

From PSO to AX

Debtors and Creditors
Accounts marked debtor or creditor can be transferred from PSO to AX. The account has only to be recorded in PSO once, identified as both debtor and creditor. The account will then appear twice in AX, namely once in the Creditors database and once in the Debtors database. Information that is edited in PSO will be automatically edited in AX.

Projects and Items
Projects and items recorded in PSO are transferred automatically to AX. This information is created and maintained in Assistance PSO. Only those items that are defined as ‘cost items’ will be transferred to AX. These project details and item details are made available in AX so entries in AX are also recorded at project and item level

The cost items of the project are recorded in a specially generated table. This information is then used in AX to make cost entries. These project costs are transferred as costs to Assistance PSO projects by the connector.

Sales invoices
Sales invoices created in PSO are recorded as sales entries in AX. These entries are immediately given the status ‘booked’ and can no longer be edited in either PSO or AX.

With the procedure Transfer invoices from Assistance PSO, all as yet un-transferred invoices are placed in the Microsoft Dynamics AX intermediate table. The program then starts a procedure in Microsoft Dynamics AX that retrieves the unrecorded records from this intermediate table and carries out the actual recording.

From AX to PSO

General Ledger Accounts
General ledger accounts are created and maintained in AX and will be transferred to PSO. These general ledgers in Assistance PSO are used in the Assistance PSO invoice module and as information for the transferred project costs. The connected general ledger is entered per invoice line. The general ledger maintenance of Microsoft Dynamics AX features a checkbox per general ledger for indicating whether or not it should be synchronised with Assistance PSO.

Project Costs
Costs entries made in AX that are set to be charged to a project with corresponding item are transferred to PSO by means of this procedure. They will then be visible on the costs tab in PSO. The project costs in AX can be entered both in the ‘standard’ journal and in the approval journal.

Payment of Sale Invoices
Paying debtors, and hence sales invoices, is done in AX. As the invoice is also present in PSO, the Update payments procedure will change the status of the invoices in PSO to ‘paid’, as well. These will then be visible in various places, including on the Invoices tab in the account file and in the projects file within PSO.

Downloads

In Partnership with: