select TAX1099BOX, RECID, * from TAX1099FIELDS where DATAAREAID = 'USMF'
select ACCOUNTNUM, TAX1099FIELDS, * from VENDTABLE where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF'
Create Purchase order and Invoice (after confirm, Tax1099Amount = 0)
select VENDACCOUNT, LINEAMOUNT,TAX1099FIELDS, TAX1099AMOUNT, * from PURCHLINE where PURCHID = '00000125' and DATAAREAID ='USMF'
select ORDERACCOUNT, LINEAMOUNT, TAX1099FIELDS, TAX1099AMOUNT,* from VENDINVOICEINFOLINE where ORIGPURCHID = '00000125' and DATAAREAID ='USMF'
select PURCHID, LINEAMOUNT, TAX1099FIELDS, TAX1099AMOUNT, * from VENDINVOICETRANS where ORIGPURCHID = '00000125' and DATAAREAID ='USMF'
Create Vendor Invoice and Post
select RECID, ACCOUNTNUM, AMOUNTCUR, TAX1099FIELDS,TAX1099AMOUNT,SETTLEAMOUNTCUR, SETTLETAX1099AMOUNT, *
from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF' and INVOICE = 'INV0118002'
select AMOUNTCURCREDIT, AMOUNTCURDEBIT, TAX1099FIELDS, TAX1099AMOUNT, VENDTRANSID, * from LEDGERJOURNALTRANS
where VENDTRANSID in (select RECID from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF' and INVOICE = 'INV0118002')
Create Vendor Invoice Journal and Post
select ACCOUNTNUM, AMOUNTCUR, TAX1099FIELDS,TAX1099AMOUNT,SETTLEAMOUNTCUR, SETTLETAX1099AMOUNT, *
from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF'
---LedgerjournalTrans.VendTransID = VendTrans.RECID---
select AMOUNTCURCREDIT, TAX1099FIELDS, TAX1099AMOUNT, *
from LEDGERJOURNALTRANS where VENDTRANSID in (select RECID from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF')
Settle with a Payment journal
select RECID, ACCOUNTNUM, AMOUNTCUR, TAX1099FIELDS,TAX1099AMOUNT,SETTLEAMOUNTCUR, SETTLETAX1099AMOUNT, *
from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF'
select AMOUNTCURCREDIT, AMOUNTCURDEBIT, TAX1099FIELDS, TAX1099AMOUNT, VENDTRANSID, *
from LEDGERJOURNALTRANS where VENDTRANSID in (select RECID from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF')
select ACCOUNTNUM, AMOUNTCUR, TAX1099FIELDS,TAX1099AMOUNT,SETTLEAMOUNTCUR, SETTLETAX1099AMOUNT, *
from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF'
---LedgerjournalTrans.VendTransID = VendTrans.RECID---
select AMOUNTCURCREDIT, TAX1099FIELDS, TAX1099AMOUNT, *
from LEDGERJOURNALTRANS where VENDTRANSID in (select RECID from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF')
have a value in the SettleTax1099Amount due to the fact the original invoice now has a payment against it
select RECID, ACCOUNTNUM, AMOUNTCUR, TAX1099FIELDS,TAX1099AMOUNT,SETTLEAMOUNTCUR, SETTLETAX1099AMOUNT, *
from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF'
---VendSettlementTax1099.ExternalRECID = VendTrans.RECID (PaymentJournal)---
select * from VENDSETTLEMENTTAX1099
where EXTERNALRECID in (select RECID from VENDTRANS where ACCOUNTNUM ='Dummy1099' and DATAAREAID = 'USMF')
