Importing Sales Credit Note Transactions into Reckon Accounts

Luke_8074360

I am having difficulty importing sales credit notes transactions into Reckon accounts. Though, I can import sales invoices into it as below format, I'm entire lost how to import credits. Can anyone share some ideas please? Thank you!

!TRNS NAME ADDR1 DATE DOCNUM TRNSTYPE PRICE AMOUNT ACCNT REP MEMO TOPRINT TERMS DUEDATE !SPL NAME DATE DOCNUM TRNSTYPE PRICE TAXAMOUNT AMOUNT ACCNT REP MEMO TAXCODE TAXABLE INVITEM TERMS DUEDATE !ENDTRNS TRNS ABC COMPANY ABC COMPANY 01/21/2016 1257587 INVOICE 100.98 Accounts Receivable AGENT ONE Y 30 days from date of invoice 02/20/2016 SPL ABC COMPANY 01/21/2016 1257587 INVOICE 91.80 -9.18 -91.80 Sales - Footwear AGENT ONE Footwear GST Y Footwear 30 days from date of invoice 02/20/2016 ENDTRNS

John G

Hi Luke,

Welcome to the Reckon Community.

Check out the In-Product Help Index for information on IIF files.

The TranType for a Sales Credit Note is CREDIT MEMO.  I have not used that type in an IIF, but I assume that it is just the negative of the Tax Invoice.


Hope this helps.


regards,
John

Graham Boast

Hi Luke

Just to add to Johns comments

• For a CREDIT MEMO, the TRNS line should show -100.98 and the SPL line -9.18 and -91.80 respectively.  The PRICE value in the SPL line is always positive for TAX INVOICE or CREDIT MEMO
• PRICE in the !TRNS line and its value in the TRNS line can be removed.
• TERMS and DUEDATE are not required in !SPL line or their values in SPL line.

Good Luck

Graham Boast 0409317366
Reckon Accredited Partner
graham@reckonhelp.com.au