This topic contains 4 replies, has 0 voices, and was last updated by MBrewer2 8 years, 4 months ago.
-
AuthorPosts
-
July 5, 2016 at 10:28 am #5217
MBrewer2When viewing an Invoice, we have one line item. Sample detail below:
Qty = 10
Price Level = Custom
Rate = 17.00
Amount = 170.00
Currency = USD
Exchange Rate = 1.00
The header-level Amount on the Invoice shows 170.00.
When running a search on the fields ‘Item Rate’ and ‘Amount’, I see:
Qty = 10
Item Rate = 24.346834
Amount = 243.47
Currency = USD
The Customer record has none of the following defined within the Financial tab’s sub-tabs:
Group Pricing
Item Pricing
Time Tracking
Any ideas as to why my search detail does not match my actual invoice detail?
Thanks in advance.
This is a cached copy. Click here to see the original post. -
July 6, 2016 at 7:59 am #5218
tgrimmCan you provide the details from the search? Search type, filters, columns etc?
-
July 6, 2016 at 9:08 am #5219
MBrewer2Search Type = Transaction
Criteria:
Type = Invoice
Main Line = False (Tried w/ main line & without, the amount still does not reflect the actual amount displayed when viewing the transaction)
Date Created = Within 01/01/2016 – 07/06/2016
Results:
Internal ID
Date Created
Currency (each line shows USD)
Exchange Rate (each line shows 1.00)
Item
Item Rate (this does not match the rate shown on the Invoice, or any price present on the item record/customer record)
Amount (this does not match the amount shown on the invoice and is calculated by the weird Item Rate)
No additional filters/drilldown/summary.
-
July 6, 2016 at 10:09 am #5220
tgrimmPM Sent
-
July 6, 2016 at 11:44 am #5221
MBrewer2tgrimm,
I think I’ve found the issue while putting together content for our PM. The subsidiary in use for the transaction/customer uses currency USD, though my user & the account is of another currency. Looking at the historic exchange rate; that would explain the reporting – as it appears reporting is consistently in my user’s preference.
-
AuthorPosts
You must be logged in to reply to this topic.