Hello All,
I have an invoice tracking system in my site. One of my users requested being able to add the purchase order reference to the product line item so I added a new field in the invoice_items table to hold the Po_id. The invoice_items grid is a linked grid under my invoices grid. I've got a calculated field called PO_Number on the invoice_items grid which does a lookup based on the hidden Po_id field. This PO_Number field is *unbound and also acts as the grid lookup during data entry which then fills in the Po_id field which is stored. This all works well.
The grid lookup is dynamically filtered on two criteria: 1) the company_id (so only PO's which belong to that company show up) and 2) the product_id (so only PO's which have that product on them show up). This just makes it easier for data entry and ensures accuracy. In the working preview this works perfectly...I can do the grid lookup on any one of the line items of the invoice either during data entry or after the fact.
When I publish the grids and try to do it on the live site, the first lookup with dynamic filter works perfectly. The next lookup icon I click results in the 403 Forbidden error. If I click on the same top level row, it refreshes the grid and the resulting linked grid and it works again but only ever the once. If I turn off the dynamic filter in the lookup grid it works fine but then I get all the PO's listed which is useless.
My developer and server builds are both 3381. Any advice would be appreciated.
workingpreview1.jpgworkingpreview2.jpgFullscreen capture 24022015 85903 AM.bmp.jpgVetta Tools - Internet Explorer 24022015 85941 AM.bmp.jpg
I have an invoice tracking system in my site. One of my users requested being able to add the purchase order reference to the product line item so I added a new field in the invoice_items table to hold the Po_id. The invoice_items grid is a linked grid under my invoices grid. I've got a calculated field called PO_Number on the invoice_items grid which does a lookup based on the hidden Po_id field. This PO_Number field is *unbound and also acts as the grid lookup during data entry which then fills in the Po_id field which is stored. This all works well.
The grid lookup is dynamically filtered on two criteria: 1) the company_id (so only PO's which belong to that company show up) and 2) the product_id (so only PO's which have that product on them show up). This just makes it easier for data entry and ensures accuracy. In the working preview this works perfectly...I can do the grid lookup on any one of the line items of the invoice either during data entry or after the fact.
When I publish the grids and try to do it on the live site, the first lookup with dynamic filter works perfectly. The next lookup icon I click results in the 403 Forbidden error. If I click on the same top level row, it refreshes the grid and the resulting linked grid and it works again but only ever the once. If I turn off the dynamic filter in the lookup grid it works fine but then I get all the PO's listed which is useless.
My developer and server builds are both 3381. Any advice would be appreciated.
workingpreview1.jpgworkingpreview2.jpgFullscreen capture 24022015 85903 AM.bmp.jpgVetta Tools - Internet Explorer 24022015 85941 AM.bmp.jpg
Comment