1,145
Hi all,
I have some pressing questions as regards reporting in GP 10
1. How do i see my report for a foreign currency Vendor/Customer in their respectives foreign currencies alone. Report such as customer ledger, Aged Trial Balance and Aged Receivables
2. How do i get a report of my Customer or Vendor in a Debit, Credit and Balance column format in GP 10
*This post is locked for comments
Hi,
Yes you are right the multicurrency report will show the data side by side in both currencies, no single report is available.
However you can modify a report for your needs (though it is not simple), moreover you can build a smart list for this information.
For your concern on viewing format of Debit credit and balance, no such format anywhere runs in GP. You need to modify your reports viewing habbits. what can be close to your requirement is run the historical aged trial balance with unmarking exclude fully paid documents, it will show all the invoices and payments made there against (applied) date wise.
hope this may help a little.
Ahsan
I have checked the first option but it does not solve the problem..What i want exactly is to see if GP can give my report with the report totals in another currence alone other than the functional currency. The multicurrency option gives the the currency in which the transaction was done and the functional currency amount side by side. But the Totals shown in the Functional currency alone.
Is this a Limitation of the application?.
2. Can i change my Date format from the American format to the British format?.
Pls, help as usual
Hi,
in addition....
2. the nearest report that will provide what you wanted:
try to visit Inquiry>Sales>debtor/customer summary. but whats is shown there is net change. go to file>print and modify the report to show Balance instead.
Hi Saheed,
Please find my feedback below:
1. How do i see my report for a foreign currency Vendor/Customer in their respectives foreign currencies alone. Report such as customer ledger, Aged Trial Balance and Aged Receivables.
[Dencio]
For trial balances, use the TB with Options. This will allow you to include multicurreny information. For posting journals, configure your posting setup to include Multicurrency info.
2. How do i get a report of my Customer or Vendor in a Debit, Credit and Balance column format in GP 10
[Dencio]
You can identify the reports that fit 80% of the details you want and modify it instead.
Hope this helps!
Cheers,
Dencio
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (