To see what's happening when you create a bill, you need to track the RefNumber. For example for this Bill line item:
SELECT TxnDate, TxnNumber, VendorRefFullName, ItemLineDesc, ItemLineAmount FROM BillItemLine where RefNumber='1111'
you would look at the Transaction Details By Account report, filtering by Bills for the RefNumber like this:
sp_report TxnDetailByAccount show Account, Date, TxnNumber, Name, Memo, RunningBalance, SplitAccount, Debit, Credit parameters TxnFilterTypes='Bill' where RowType='DataRow' and RefNumber='1111'
By looking at the report result below you can see the $750 4m Steel Ladder was posted as:
- $750 against the Stock Asset account,
- $75 against the Tax Account
- With the reverse entry of $825 applied against the Accounts Payable account.
|