Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
QuickBooks IIF interface help
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
QuickBooks IIF interface help
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01627590
Message ID:
01627590
Views:
104
Has anyone tried to interface an app into QuickBooks using an IIF file? I am trying to create an IIF file that will be
imported into QuickBooks Premium edition and create a general journal entry. It keeps saying the file has been
imported but the data is not there. File follows

!TRNS TRANS TRANSTYPE DATE ACCNT CLASS AMOUNT DOCNUM MEMO
!SPL SPLID TRANSTYPE DATE ACCNT CLASS AMOUNT DOCNUM MDMO
!ENDTRN
TRNS GENERAL JOURNAL 10/21/15 ACCOUNTS RECEIVABLE-WATER 226.90
SPL GENERAL JOURNAL 10/21/15 PREMIER BANK -136.90
SPL GENERAL JOURNAL 10/21/15 BAD CHECK CHARGE -90.00
TRNS GENERAL JOURNAL 10/21/15 METERED SALES 23.40
SPL GENERAL JOURNAL 10/21/15 ACCOUNTS RECEIVABLE-WATER -23.40
TRNS GENERAL JOURNAL 10/21/15 ACCOUNTS RECEIVABLE-WATER 150.00
SPL GENERAL JOURNAL 10/21/15 NEW SERVICE/TRANSFER FEES -150.00
ENDTRNS

There is a blank spaced field for the Class field between the Account and the Amount fields. If anyone has any experience in
this I would appreciate any advice.

Thanks in advance,

Brad
Next
Reply
Map
View

Click here to load this message in the networking platform