How To Link Multiple General Ledger Revenue Accounts to the Sage Import Program

Owned by Gord More (Unlicensed)
Jul 04, 2017

Overview

The following procedure will support linking charges and package/service types in IDS to flow through to multiple general ledger revenue accounts. 

It is assumed that the preferences for both IDS and Sage have already been created and confirmed working in the Sage Import program. 

If the import program is currently used to import with IDS Preferences to be either Package Type – Service Type or Service Type – Package Type then start at point 11. 

Linking multiple general ledger revenue accounts when importing to Sage requires the Inventory Code Structure in IDS Preferences to be either Package Type – Service Type or Service Type – Package Type.  Driver Name selection does not support the facility to link to multiple revenue accounts.

Procedure

  1. Create all required charge in IDS.  Reference type charge fields do not get imported into Sage.
  2. Notify IDS when this is completed.  IDS will block the creation of new charges and will map the created charges to the IDS export program used by the Sage import program.  The blocking can only be changed by contacting IDS to open the creation of new charges or changes to existing charges.
  3. IDS will notify the user when the charges have been mapped in the export program.
  4. In IDS create 1 fictitious trip and enter values for all charges. Verify, Post and Invoice this trip. This trip must be credited in IDS after the import to Sage is completed.
  5. In Sage exit all users and create a backup.
  6. Run the Sage import program for the 1 trip just created.  This import will automatically create the inventory records in Sage. An inventory item will be created for each charge excluding reference type charges.
  7. After the import check the inventory records to make sure all have been created.
  8. In IDS create a negative trip identical to the fictitious trip and repeat steps 4, 5 and 6
  9. In Sage void both of the fictitious trips.
  10. In IDS adjust both fictitious trips.
  11. In Sage assign general ledger revenue accounts for the inventory items (charges )
  12. Run a Sage backup
  13. Test import 1 live invoice and check that the correct revenue accounts are updated.