Base Ref No. in Print Out

[Former Member]

Dear All,

I am having problem in Printing Base Ref no in Invoice.(Row Wise)

Example:

I am having 5 sales Order and BP Ref No is 1,2,3,4,5,

i am making partial Deliveries of that Sales Order. In Row Level in delivery document the Baseref number will be updated. But when Delivery is copied to Invoice these Baseref is not copied in Invoice .(The Reason is BP Ref Number is empty in Delivery.)

How can i get Base ref no from Delivery to invoice. FMS is one way of doing but i dont know how to write query for FMS

Please suggest how to get Base ref No. in Invoice

Ashish Gupte

[Former Member]

Dear Ashish,

Please clarify which Base Ref number do you need. Sounds like you want to get Base ref for Delivery (Sales Order No) to Invoice directly. That will not be possible because Invoice will only be based on delivery in your case. If that is what you want, you need an UDF for it.

Thanks,

Gordon

[Former Member]

Dear Gordon ,

when we copy sales order to delivery then in a row level of delivery base ref Customer reference (Num At card ) appears but in multiple sales order then all the num at card appears.

I want Num at card of perticular sales Order in delivery then in Invoice

I hope it is very clear for you. whatever is the way either creating UDF in Sales Order then FMS then in delivery and invoice

Ashish

[Former Member]

It is still not quite clear. You want Num at card of perticular sales Order in delivery then in Invoice. What is the rule for it?