I am trying to add Order Nbr.(ARTran-SOOrderNbr) to Prepayment and Application-Documents to Apply, the title shows up, but it did not bring the related Order Nbr to its invoice.
What kind of update do I need to write for this attribute (ARtran_SOOrderNbr)
Best answer by darylbowman
‘Order Nbr’ is part of the ARTran table and ARTran is only joined into that Data View if ‘Pay By Line’ is specified on the Invoice.
Since one Invoice can contain billing lines from multiple Orders, there’s is no great way to get Order Nbr to the Invoice level. If your Invoices usually only contain a single Order’s lines, you could add a custom field to ARInvoice and write code to populate the Order Nbr appropriately. This would then be available to add to this screen.
+15‘Order Nbr’ is part of the ARTran table and ARTran is only joined into that Data View if ‘Pay By Line’ is specified on the Invoice.
Since one Invoice can contain billing lines from multiple Orders, there’s is no great way to get Order Nbr to the Invoice level. If your Invoices usually only contain a single Order’s lines, you could add a custom field to ARInvoice and write code to populate the Order Nbr appropriately. This would then be available to add to this screen.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
