My client want us to create credit limit for all their customers where they can load a product and we monitor the credit limit.
The scenario they want is this, example:
Customer ABC LTD has a credit limit of $10,000 but due to is business operation he want to take products from other region where we have depot.
Region A : we gave him $5000 as credit limit of a product he can lift
Region B: we gave him $3000 as credit limit of a product he can lift
Region C: we gave him $2000 as credit limit of a product he can lift
What we have done is that we created
ABC LTD as Sold to Party (Main account) and as a Payer in Region A, Bill to Party in Region B, and Ship to Party in Region C.
What my Client want is that all activities or transactions in all regions should roll up to ABC ltd in sold to party when reporting.
I.e ABC LTD - Sold to Party (Main account)
ABC LTD - Payer
ABC LTD - Sold to Party
ABC LTD - Ship to Party
Presently i can only run report on regions only were activities as taking place not in ABC LTD - Sold to Party
Kindly assist me on how i can run a report that all transactions in regions will roll up to main account in ABC LTD - Sold to Party