@lubos please have a look on these transaction. Same item description is either repeated twice or thrice resulting in wrong report and also I can’t get the meaning of 0 amount in black colour.
My last attempt - you have not shown the top half
Is it because our are using the inventory modules and the items are being delivered from different locations ?
If you want more help, you will have to provide more details of the reports and transactions you are using.
Remember, we can not see what you have in your accounts only the partial infomation you are providing using screen shots - for example show the edit screen for the report, show the report, show the drill down view, show the full edit screen of the transactions involved
Otherwise we are just making a guess as to what has happened and why the data is not what you expect
Your subject line says the Sales Invoice Totals by Custom Field report is showing the wrong calculation. But you have not shown either the Edit screen or View of such a report. Instead, you started with a screen shot of a drill-down on something unidentified. So we have no idea what calculation you are referring to. Nor do we know what your screen shot shows.
You marked up your first screen shot, but did not explain what the markings were.
You then asked for a contact column, which has nothing to do with calculations. This is apparently a diversion from your topic to request something you already requested in another topic.
You asked why some amounts were in black. That is because they are not negative. Negative values are in red on the screen you are looking at, whatever it is.
You did not tell us what edition or version number of Manager you are using.
sorry!
You are saying absolutely correct that was a complete diversion from the topic. because I’m more centric for the contact/customer column.
the topic I created that it shows a wrong calculation later i found that in below screenshot first two arrows are GST rates 18%( 9 + 9 ) and third arrow is pre GST value .
so basically my topic is a feature request that was previously available but in latest release it’s not available . so why this is needed i’m going to write a justification for it.
if let Say N20086 is billed to = “customer A”
N20085 is billed to = “customer B”
N20084 is billed to = “customer G”
N20083 is billed to = “customer A”
N20082 is billed to = “customer X”
N20081 is billed to = “customer A”
N20080 is billed to = “customer Y”
N20079 is billed to = “customer G”
N20078 is billed to = “customer B”
and so on…
and you want to know for the specific period how much Penta modular did customer A
purchased.
what previously manager answers was simply typed in “Customer A” in search bar and the results came in.
but now because no Contact column is present i’m unable to run such search reports .
so @lubos & @tut please help to see contact column again in drill down reports