@DavidEichner , Thank you for this solution. It is working for me & the client.
@patrick53 ,I think that should work still. Each Invoice would have an APTran line that would tie to a the PO. So different invoices could reference the same PO.
@lauraj46 , Here is the xml of the GI. We are trying to create a filtered tab to the GI. The sorting of the column is working. Thank you for the assist. Bill
@lauraj46 ,Thank you very much!Setting the schema worked great!
@bclark ,Assuming that 3790 is an employee, on the employee record, is the AP Subaccount entered on the Financial Settings Tab?
I was wondering if anyone had a chance to review this. It is very strange!
@Chris Hackett ,There has been no replies and I have not been able to figure this out yet.
The solution turned out to be using ARInvoice.DocType.Raw instead of ARInvoice.DocType. I am not sure why the latter worked for Invoices & not Credit Memos.
I’d like to join this session.
@Harshita , I have also found that if any field used in the value is blank, then the entire field does not print. from your example, =’Binding’ + [CSAnswers.AtrributeID]+[CSAnswers.Value] will not show the word Binding if either field is null. You have to conditionalize the fields if you want the word Binding to print. like this:=’Binding’ + iif( [CSAnswers.AtrributeID]<>null,[CSAnswers.AtrributeID] ,’’)+iif ( [CSAnswers.Value] <>null, [CSAnswers.Value],‘’)
@Harshita , When I want to force data onto multiple lines, I use the ‘{br}’ to force a new line. This is what the address fields do on forms like the Sales Order, SO641010.rpx.Like this: +IIf([CompanyAddress.AddressLine1]<> null, [CompanyAddress.AddressLine1] + '{br}', '')+IIf([CompanyAddress.AddressLine2]<>null,[CompanyAddress.AddressLine2] + '{br}','')
@BenjaminCrisman , I thought that it wasn’t possible but thought I’d verify in case I was missing something. I did do a screengrab of the logo needed & was able to embed it into the form. Thanks for the suggestion!
I am interested in attending.
@bryanb39 ,Thank you for the response.I had considered using the warehouse in the filters. I rejected that approach because the client currently has 31 warehouses. & would end up with 60-90 tabs. I will review with the client to see if we can narrow the criteria or get them to filter on the column headers as needed.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.