I am generating scheduled report of 'Item Listing' using Quickbooks desktop. But there is no Product Id or any other primary key found in generated report. I want to sync generated reports with my system but for that i need a primary key. Is there any option available for this?
Secondly, The Pdf report received from scheduled report has an issue that, if any entry in the list is long, then it is getting cropped using '...' at the end. This is very bad as I am not able to get full name of my products. Needed solution for this too.
Thirdly, is there any specific method available by which i can get Excel/Csv in scheduled reports?
So the Primary key or Product Id--- you can use part number (customise the report and it appears in the Display section). The pdf getting cropped, is there a specific column that its doing it on? Description column? Can you provide us with a screenshot so we can see what your seeing please. Also with it being on a pdf then it may be an issue or limitation with adobe?