I need to have a formated search on the BP Project combo box so that when we open AR Invoice, it automatically links with BP project number 1, for example.
Then I would use another FS to do the same on AP Invoice, so it would always associate AP Invoice with BP Project number 2 for example. The same would be done with incoming and outgoing payments.
Can anyone help me with this?
Yes it is possible
What is your project code for AR and AP
The formatted search would be as simple as
SELECT '3' ............. for AR Invoice
SELECT '4' .............for AP Invoice
Assign this to the row level Project column..Auto Refresh...on Item Code............Refresh regularly