Hi, im trying to convert the value of a field to be shown in my ssrs report in %, anyone can provide me the full expression.
THANKS
Hi, im trying to convert the value of a field to be shown in my ssrs report in %, anyone can provide me the full expression.
THANKS
Hi, all my root cause is line disc % field, thats why other fields changed values.
i am actually trying to debug my code but for some reason the debugger is not working on this sales invoice. is that possible u provide me a correct version of the code? ( also note i need to show each line its own line disc % thats why im using taxtrans table ) if u can provide correct version of code, i will be thankful!
Hi, Not just LineDisc but few other fields are also changed. I can't help here much, you need to debug the code and find root cause. Just one suggestion is to review your code where you have created unnecessary table buffers like taxTrans. Please check if you really need it or can use method parameter just like custInvoiceTrans.
Hi mohit, i am now facing the following issue: if i create a sales invoice with multiple packing slips, the Line disc % is being divided by 2. i will share screenshots:
here is the second picture where the line disc % is being divided by 2:
You should comment your select statement for custInvoiceTrans and use _custInvoiceTrans table buffer you have in the parameters of this method.
if i comment the last part of the code, i get 3 lines.
If you comment this code, are you getting 3 lines. If No, then this is not the root cause.
i debugged, the issue is with this part of the code that is responsible of mapping the field sumlinedisc from custinvoicetrans.its only reading 1 line in debugger. i used the same logic i did in the first loop in taxtrans table.
i dont know whats wrong with my code that is showing only 1 line.
You can debug the SalesInvoiceDP class. populateSalesInvoiceTmp and insertIntoSalesInvoiceTmp methods.
Also, try printing report for another sales order to rule out data issue.
i cannot check the table browser since the table is a tmp table, i get this message: You've received multiple errors.
You are not authorized to access table ‘Show invoice’ (SalesInvoiceTmp). Contact your system administrator.
The menu item with name systablebrowser could not be opened.
You can check if 3 records are inserted in tmp table for this report. Either debug it or change the TableType property to Regular, so you can see the records in SQL server or table browser after report is executed.
If 3 records inserted then issue in report design or SSRS service, if 1 record then issue in class level.
André Arnaud de Cal...
292,187
Super User 2025 Season 1
Martin Dráb
230,966
Most Valuable Professional
nmaenpaa
101,156