Hello,
I wrote some bespoke software to import customer details and invoices via IIF format.
All seems OK, no warnings and it balances OK.
My issue is whenever I change the Terms on the invoice all the prices go astray as it tries to re-balance. Also whenever I try to edit in any way the prices all go astray and I have to re-enter the whole invoice manually.
Also when I try to apply payments it doubles the owed amount although it applied OK. This is a QB bug and is caused apparently by a negative Tax balance. Again if I re-enter the invoice manually all is good.
I have included below a simple invoice input, Some detaills changed for privacy. I am convinced this is something to do with Tax allocation on the import.
Can anyone spot why this is happening so I can correct it?
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA
!ENDTRNS
TRNS INVOICE 17/03/2017 Accounts Receivable Duck, Donald (16607) 46.62 44989 N N Acme Construction Donald Duck 34 The Arches, Wet Gardens London SW1 3Ua Acme Construction Ben Mitchell 63 Dry Road London Sw1 4px N Credit Card Method no set Thank you for shopping with XXXX. Credit/Debit Card Payment 44989
SPL INVOICE 17/03/2017 Sales -32.9 TechSeal 100FR Duct Sealant Cartridge - 100FRS N -10 3.2900 100FR2 Y
SPL INVOICE 17/03/2017 Shipping and Delivery Income -5.9500 N -1 Shipping Y
SPL INVOICE 17/03/2017 VAT Liability Standard Sales -7.7700 N -1 Standard Sales N AUTOSTAX
ENDTRNS
I wrote some bespoke software to import customer details and invoices via IIF format.
All seems OK, no warnings and it balances OK.
My issue is whenever I change the Terms on the invoice all the prices go astray as it tries to re-balance. Also whenever I try to edit in any way the prices all go astray and I have to re-enter the whole invoice manually.
Also when I try to apply payments it doubles the owed amount although it applied OK. This is a QB bug and is caused apparently by a negative Tax balance. Again if I re-enter the invoice manually all is good.
I have included below a simple invoice input, Some detaills changed for privacy. I am convinced this is something to do with Tax allocation on the import.
Can anyone spot why this is happening so I can correct it?
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA
!ENDTRNS
TRNS INVOICE 17/03/2017 Accounts Receivable Duck, Donald (16607) 46.62 44989 N N Acme Construction Donald Duck 34 The Arches, Wet Gardens London SW1 3Ua Acme Construction Ben Mitchell 63 Dry Road London Sw1 4px N Credit Card Method no set Thank you for shopping with XXXX. Credit/Debit Card Payment 44989
SPL INVOICE 17/03/2017 Sales -32.9 TechSeal 100FR Duct Sealant Cartridge - 100FRS N -10 3.2900 100FR2 Y
SPL INVOICE 17/03/2017 Shipping and Delivery Income -5.9500 N -1 Shipping Y
SPL INVOICE 17/03/2017 VAT Liability Standard Sales -7.7700 N -1 Standard Sales N AUTOSTAX
ENDTRNS
Last edited: