Hi all,
Referring to customer invoice processes, especially from Sales Order, may I now what is table SpecTrans for ? and when exactly the record inserted ?
Is when invoice created, by means CustInvoiceJour inserted, this table SpecTrans also inserted ?
Thanks,
Hi VoltesDev,
The SpecTrans table is used to mark customer or vendor transactions for settlement. When creating a journal or when settling transactions from the customer or vendor form, you can mark transactions for settlement. The specifications are stored in this table and deleted once the journal or settlement gets posted.
Hi Andre,
So this SpecTran will only be inserted at time when Customer Payment Journal created ? to be exact it is when LedgerJournalTrans inserted where user create new journal line during time to settle, the new record in SpecTrans will be inserted as well, am I right to say that ?
The SpecTrans is not limited to a customer payment journal. It is used for marking all settlements for customer and vendor transactions.
It is not inserted at moment of inserting a LedgerJournalTrans record, but at the time a customer/vendor transactions will be marked with a journal line or another customer/vendor transaction.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 696 Super User 2025 Season 2
CA Neeraj Kumar 569
Martin Dráb 551 Most Valuable Professional
