[MBrewer2 Contributions: 0Level 1☆]

When 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.

[tgrimm Contributions: 0Level 1☆]

Can you provide the details from the search? Search type, filters, columns etc?

[MBrewer2 Contributions: 0Level 1☆]

Search 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.

[tgrimm Contributions: 0Level 1☆]

PM Sent

[MBrewer2 Contributions: 0Level 1☆]

tgrimm,

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.

[Author]

Posts