[!]-----
This code will generate a file that can be imported from QuickBooks.
The file name will be "import_qb.iif" by default, or whatever you type in on initial page.
This will contain both customers and sales records.
QuickBooks requires Account # on every transaction record. This template uses
"Accounts Receivables" for ACCNT; you would want to replace that with the account
of your choice that already exists in QuickBooks.
-----[/!]
[Text]blank=[/Text]
[!]=====================================================================[/!]
[!] Show form [/!]
[!]=====================================================================[/!]
[showif [action]!Generate]
[/showif]
[!]---------------------------------------------------------------------[/!]
[!] Generate import file for QuickBook [/!]
[!]---------------------------------------------------------------------[/!]
[showif [action]=Generate]
[!]-------------------------------[/!]
[!] Headers [/!]
[!]-------------------------------[/!]
[WriteFile [writeTo]][!]
[/!]!CUST [!]
[/!]NAME [!]
[/!]REFNUM [!]
[/!]TIMESTAMP [!]
[/!]BADDR1 [!]
[/!]BADDR2 [!]
[/!]BADDR3 [!]
[/!]BADDR4 [!]
[/!]BADDR5 [!]
[/!]SADDR1 [!]
[/!]SADDR2 [!]
[/!]SADDR3 [!]
[/!]SADDR4 [!]
[/!]SADDR5 [!]
[/!]PHONE1 [!]
[/!]PHONE2 [!]
[/!]COMPANYNAME [!]
[/!]FIRSTNAME [!]
[/!]MIDINIT [!]
[/!]LASTNAME
[/WriteFile]
[AppendFile [writeTo]][!]
[/!]!TRNS [!]
[/!]TRNSID [!]
[/!]TRNSTYPE [!]
[/!]DATE [!]
[/!]ACCNT [!]
[/!]AMOUNT [!]
[/!]NAME
[/AppendFile]
[AppendFile [writeTo]][!]
[/!]!SPL [!]
[/!]SPLID [!]
[/!]TRNSTYPE [!]
[/!]DATE [!]
[/!]NAME [!]
[/!]AMOUNT [!]
[/!]QNTY [!]
[/!]PRICE [!]
[/!]ACCNT [!]
[/!]TAXABLE
[/AppendFile]
[AppendFile [writeTo]][!]
[/!]!ENDTRNS
[/AppendFile]
[!]-------------------------------[/!]
[!] Contents [/!]
[!]-------------------------------[/!]
[orderfile [readFrom]]
[AppendFile [writeTo]][!]
[/!]CUST [!]
[/!][Name] [!]
[/!][blank] [!]
[/!][date] [!]
[/!][Address1] [!]
[/!][Address2] [!]
[/!][City] [!]
[/!][State] [!]
[/!][Zip] [!]
[/!][ShipToAddress1] [!]
[/!][ShipToAddress2] [!]
[/!][ShipToCity] [!]
[/!][ShipToState] [!]
[/!][ShipToZip] [!]
[/!][Phone] [!]
[/!][ShipToPhone] [!]
[/!][Company] [!]
[/!][blank] [!]
[/!][blank]
[/AppendFile]
[AppendFile [writeTo]][!]
[/!]TRNS [!]
[/!][cart] [!]
[/!]ONLINE SALE [!]
[/!][date] [!]
[/!]Accounts Receivable [!]
[/!][taxableTotal] [!]
[/!][name]
[/AppendFile]
[lineitems]
[AppendFile [writeTo]][!]
[/!]SPL [!]
[/!][lineIndex] [!]
[/!]ONLINE SALE [!]
[/!][date] [!]
[/!][sku] [!]
[/!][math][quantity]*[price][/math] [!]
[/!][quantity] [!]
[/!][price] [!]
[/!]Accounts Receivable [!]
[/!][taxable]
[/AppendFile]
[/lineitems]
[AppendFile [writeTo]][!]
[/!]ENDTRNS[!]
[/!][/AppendFile]
[/orderfile]
Written to [writeto] on [date] [time].
[/showif]