I need to create one report and the outcome for this report come from " Customer Transaction & Vendor Transaction",
did we have a relation between vendTrans and custTrans.
I have the same Customer Account ID and Vendor Account ID
Any advise Please
*This post is locked for comments
Hi Ali,
It is possible to get such report, but it requires development effort for a custom report.
Hello Ali Hayajneh,
In GL we have a transaction origin report that includes multiple subledgers, such as AP and AR in one single report.
The report mentioned, is, however, an 'accounting' report.
I am not sure what kind of customer/vendor report you look out for but you might want to look at the transaction origin report to see whether it fits and if it does not whether you can borrow some concepts from this report design.
Best regards,
Ludwig
Its the first time I ask Question
thank you for this kind support
we have customized on the system once we create Vendor the system auto-create a customer with the same ID.
IF I need to have a report contain the for Customer and vendor transaction on the same report, It's Possible?
Hi Ali,
Note that the tags on this forum should not start with a '#' and they should be separated with a comma ','. I have corrected it for you.
There is no database related between custTrans and vendTrans. Also on account numbers there is no relation. It is possible to setup a vendor account number on the customer details for creating a link. If the customer and vendor both share the same global address book party ID, then you also have a link. Then you can use this as starting point to get customer and vendor transactions for the same organization.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (