Hi,
I have created an AOT query where i added 4 to 5 tables. then created a view by this query.
Now i created a form by this view. In this form all company data is coming . Means if i am in Cmpny B cmpny A sales order is also coming in this form.
How to run these query or form for current compnay.
Hi,
Check the Table property SaveDataPerCompany should be yes for your requirement.
SalesTable is company specific. Is you query cross company? Tell us about your query.
As per requierment we need to collect data from “Purchase Requisition” & “Purchase Order”.
We need to track all Requisition weather it’s PO is there or not and all the purch line .
About query it’s a simple query have multi Data source. (PurchreqTab,PurchReqLine, PurchLine) . rest fields we are getting from Display Method like Vend name , Vend Account , Site , Ware house ETC
These all are Standard tables
So do you see data from all companies for all these tables? Check the allowCrossCompany property on the Query…
It’s non editable on query … I am getting data for physical fields but for display fields values are blank. Also we are assuming for current company data only
What is value of it?