Hi, Is there a way to create A/R register report u...
# administration
n
Hi, Is there a way to create A/R register report using a saved search? I want to create this search to pull transaction line level fields such as invoice, credit memo etc. onto A/R register. Please let me know if there is any solution for this. Your immediate response is greatly appreciated.
m
Criteria Account type : non of AR and ((type = invoice credit memo AND Main line = false ) or ( type = JE and custom checkbox is yes )) For JE what you can do is to create custom checkbox field on header and if the JE contains one account AR , you can set to true To flagged this transactions , use saved search like criteria : type= JE and Account type = AR Result : transaction name The update the JE by csv ( for the new JE use a Wf based on saved search criteria )
s
suite answers: • 74253 • 85341
m
With this SA you can see only the AR account not the counterpart of this AR right ?
s
only the AR acct, since you are defining the accounts in the criteria - so only posted transactions to the account only
m
Yes I answered something more complex lol I thought he wanted to see the counterparties of the AR account
s
šŸ˜‚ yup you did, he wanted just to mimic register type reports/view - which cannot be customized like other reports.
šŸ˜‚ 1
also in reports you cannot have line level data
n
Hi Sam
It is not pulling the data, the same as the A/R Register report. I want to pull the same data into the saved search and some additional transaction line-level custom fields. Could you please tell me the criteria and columns to be added to the custom search? It is a bit urgent. ThanksšŸ™