cancel
Showing results for 
Search instead for 
Did you mean: 

Display Sales Order Number in A/R Invoice

former_member203816
Active Contributor

Hi Expert,

can you help me.

I want to Display the Sales Order Number in A/R Invoice Form.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Tushar...............

Create an UDF on header level of the document in sales order itself.

Apply a FMS on SO level so that it will fetch the SO docnum into your SO level UDF.

Now when you copy that SO to the target document the SO number also also be copied to the delivery or AR invoice......

I guess it will solve your problem...........

Regards,

Rahul

former_member203816
Active Contributor
0 Kudos

Thank You very much Rahul.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

When you copy the document from sales order to sales invoice. the sales order number gets displayed in the remarks field of sales invoice.

If you want to display the sales order no. on sales invoice document print or PLD. follow thjis:-

->> Open the A/R Invoice PLD.

->> Create 2 Database Fields in Repetetive Area and Assign the Base Document No. & Date fields.

Base Document No. (SO. or Delivery No.)

Table -> INV1 - A/R Invoice - Rows.

Column -> BaseRef - Base Document No.

Hope it helps

Regards.

ShriX.

msundararaja_perumal
Active Contributor
0 Kudos

Hi,

By default the Base document number will appear on the remarks field, if the document is being raised using the document generation wizard or using the Copy to functionality

former_member203816
Active Contributor
0 Kudos

Hello Dear,

Thank you for your Co-operation.

But i want to display the Sales order no in User Defined Field.

I think we use the FMS for this.

So please give me the guidance for this.

Former Member
0 Kudos

Hi,

you generated the invoice directly from the order? or there is a Delivery?

Paolo

Former Member
0 Kudos

Hi,

If you copy Sales Order directly to Invoice, try this FMS query:

SELECT Distinct T0.DocNum From dbo.ORDR T0

INNER JOIN dbo.INV1 T1.ON T1.BaseEntry = T0.DocEntry

INNER JOIN dbo.OINV T2 ON T2.DocEntry = T1.DocENtry

WHERE T2.DocNum = $[OINV.DocNum\]

Thanks,

Gordon

Former Member
0 Kudos

Hi

If you follow the complete sales cycle through Copy to button then in remarks field of A/R invoice you will get the corresponding sales order no.

Otherwise you can make a query corresponding to that customer and select the record from ordr.

regards