Announcements
Hi all.
I want to get MainAccountID in Main Account table from CustTrans table, but I don't find relationship of them or using method to get it. help me. thank you so much.
*This post is locked for comments
Your question does not make much sense.
Each CustTrans record will have a Voucher, but each voucher in the general ledger will typically debit/credit multiple and sometimes many main accounts. For example, if the CustTrans record represents a customer invoice from a sales orders, the voucher will hit your A/R Trade main account for customer balance, one or more Revenue main account, one or more Inventory balance main accounts, as well as Cost of goods (Sales consumption) main accounts, and potentially more.
So, which main account is it you want?
Hi Brandon Wiese
thank you for your attention to my question. But I mean, I want to get MainAccountId in Main Account table from Custtrans table by code, because I want to select all customer in Custtrans table where MainAccountID equals parameter MainAccountID.
My English is bad. So If you don't understand, please tell me.
Hi!
Look for example query CustBalance_CN
You can create a query for your condition use it
You can get main account from CustTrans Posting Profile join with CustLedgerAccounts
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 21
dekion 4
Virginia99 4
