[development-axapta] Dynamic x++ query problem

Hi folks,   I have done some customization in which doing dynamic query generation. Now i am getting the following error message. Stack trace: The operation that you are performing generates a SQL statement that contains too many nested statements. Break the operation into multiple parts, and t

[development-axapta] Create Production Picklist lines from a job

Hi I have a requirement to generate production picklist lines from a job. I have created a dummy production order and also have created a blank Picklist journal. I have to populate the lines of this Picklist journal from a job, base on some criteria I select few items in my code and try to