Short question (if you don't have time to read the description): What all tables are updated when a customer transaction is marked for settlement other than a SpecTrans table?
Hi,
I'm working on an integration project. The design is such that initially all sales invoices are debited to a dummy customer account (DCA001) which are created in CAR journal. After that the data is credited from dummy customer account (DCA001) and debited to real customer accounts (for eg. RCA001,RCA002,etc.) which are created in U2C journal.
1. I have posted the dummy customer sales data (CAR journal).
2. I have created JVs which moves Dummy Customer Account Data (DCA001) to real customers (RCA001, RCA002, etc.).
3. When lines of step2 are created in U2C journal, they are marked for settlement against DCA001 invoices. I have created the Vouchers of U2C journal.
4. Now when I'm trying to post the vouchers in U2C journal, I'm getting this error:
Posting results for journal batch number XXX-00005029XXX Voucher U2C-001095XXX Transactions have been selected for settlement, although Settlement type: none was selected for customer DCA001, voucher U2C-001095XXX.
The dummy customer account has around 1 million open transaction records. It takes hell lot of time to open "open transactions" of dummy customer account DCA001. So unmarking the settlements from UI is not viable. I will have to do it via X++.
Solutions I have tried:
If I delete the corresponding line of Voucher U2C-001095XXX from SpecTrans table through SQL Serve Management Studio, then I don't get the error and it successfully posts the journal. But this would render the DCA001 transactions OPEN and won't settle it.
Also I'm not sure if this is a correct solution.
How can I resolve this issue with X++ since resolving it from UI is not possible? Which tables are updated when a transaction is marked for settlement other than SpecTrans table?
