Description |
Steps:
* You will need customer database.
* Print Open AP clearing details and Open AP Clearing. Print as of today.
Issue:
* This report should only show Receipt detail that has not been vouchered AND Posted.
* Should follow the same timing as GL posting to AP clearing.
* The transaction should be added or removed when the posting of the GL takes place.
* Should only show if the line total has value. If zero, should not show.
* The balance of the report should match as of the date selected to General Ledger, similar to Open Payables Report.
Query:
---I ran the query below to check for any records that should be in Open clearing, but found no records that should be. I think this report should be $0. Please correct me if I am wrong, so I can use the query in the future.
select strReceiptNumber, strBillId, tblICInventoryReceiptItem.dblLineTotal, * from tblICInventoryReceipt
inner join tblICInventoryReceiptItem on tblICInventoryReceipt.intInventoryReceiptId = tblICInventoryReceiptItem.intInventoryReceiptId
left outer join tblAPBillDetail on tblICInventoryReceiptItem.intInventoryReceiptItemId = tblAPBillDetail.intInventoryReceiptItemId
left outer join tblAPBill on tblAPBillDetail.intBillId = tblAPBill.intBillId
where strBillId is Null
and dblLineTotal <>0
and tblICInventoryReceipt.ysnPosted =1
and tblAPBill.ysnPosted = 0
|