OK, I read that and on the face of it, it seems to relate to my problem but I am still struggling to 'see' it all.
Let me explain. I have added a bill which has two lines as above:
Line 1 Non-Vatable Food Purchases Z (0.00%) £ 100.00 (Vat = £0.00) Line 2 Vatable Food Purchases S (17.5%) £100.00 (Vat=£17.51)
Note that with VAT set at 17.5% Line to tax total should be £17.50.
The screen shot below show you how I would use the QB UI to enter and modify the tax amounts. It only allows me to change the overall tax amounts for each VAT code, not the tax amounts for each line.
Now, if I do a query on the BillExpenseLine table there are no valules in any of the TAX columns, even the rates:
Dump of BillExpenseLine |
|
|
Column |
1 |
2 |
TxnID |
BCD-1230728130 |
BCD-1230728130 |
TimeCreated |
55:30.0 |
55:30.0 |
TimeModified |
38:31.0 |
38:31.0 |
EditSequence |
1230734311 |
1230734311 |
TxnNumber |
265 |
265 |
VendorListRefID |
8000004C-1230727817 |
8000004C-1230727817 |
VendorRefFullName |
3663 |
3663 |
APAccountRefListID |
80000027-1184631976 |
80000027-1184631976 |
APAccountRefFullName |
Accounts Payable |
Accounts Payable |
TxnDate |
01/01/2009 |
01/01/2009 |
TxnDateMacro |
All |
All |
DueDate |
01/01/2009 |
01/01/2009 |
AmountDue |
1105.01 |
1105.01 |
RefNumber |
mr-12345678 |
mr-12345678 |
TermsRefListID |
80000001-1184631975 |
80000001-1184631975 |
TermsRefFullName |
Net 15 |
Net 15 |
Memo |
|
|
IstaxIncluded |
0 |
0 |
LinkToTxnID1 |
|
|
Is Paid |
0 |
0 |
ExpenseLineClearExpenseLines |
|
|
ExpenseLineSeqNo |
1 |
2 |
ExpenseLineTxnLineID |
BCF-1230728130 |
BD0-1230728130 |
ExpenseLineAccountRefListID |
80000047-1230727992 |
80000048-1230728017 |
ExpenseLineAccountRefFullName |
Cost of Sales:Non Vat Food & Supplies |
Cost of Sales:Vatable Food & Supplies |
ExpenseLineAmount |
400 |
600 |
ExpenseLineMemo |
|
|
ExpenseLineCustomerRefListID |
|
|
ExpenseLineCustomerRefFullName |
|
|
ExpenseLineClassRefListID |
80000006-1230727913 |
80000006-1230727913 |
ExpenseLineClassRefFullName |
meadowhall1 |
meadowhall1 |
ExpenseLineSalesTaxCodeRefListID |
|
|
ExpenseLineTaxCodeRefListID |
|
|
ExpenseLineSalesTaxCodeRefFullName |
|
|
ExpenseLineTaxAmount |
|
|
ExpenseLineTax1Amount |
|
|
Tax1Total |
|
|
Tax2Total |
|
|
ExchangeRate |
|
|
AmountIncludesVAT |
|
|
ExpenseLineBillableStatus |
|
|
FQSaveToCache |
0 |
0 |
FQPrimaryKey |
BCD-1230728130 |
BCD-1230728130 |
So I can't see where the modified tax amounts are stored and therefore cannot see how to create them, enquire on them or modify them.
To be honest, at this stage all I want to do is create them as I want to replace an existing Import routine from a web server which used IIF.
Anyone shed any light for me?
Thanks.
|