Uploading Purchase Order Against the Sales Order through DTW

[Former Member]

Hi Experts,

I searched the forum but could not see anything regarding this.

Can I upload Purchase Orders against the Sales Orders using DTW upload facility? Manually we do it through the Logistics Tab in Sales Order.

Thank you in advance.

Kind Regards,

IC

[Former Member · Accepted solution]

Hi,

You can export the required lines to the file and prepare it for DTW. Because both PO and SO share the same structure, you just need to replace the BP Code.

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks Gordon. But this would not give me the link between SO and PO. I understand we can upload POs and SOs through similar document header and line templates, if that's what you proposed, but I want to upload the linked POs. Are you with me?

Regards,

IC

[Former Member · Accepted solution]

Hi there,

As far as I'm aware, it's not possible in any of the current versions. You can upload documents linked to one another within the same module - i.e. a sales invoice linked to a sales order or a purchase credit note to a purchase invoice, etc. but not between sales and purchase.

I hope this helps.

Regards,

Nat

[Former Member · Accepted solution]

Hi Natalia,

Thanks for your reply.

How can I integrate a sales oreder with its delivery note (second part of your answer)?

Regards,

IC

[Former Member · Accepted solution]

Hi,

You can use the BaseType, BaseEntry and BaseLine columns for this in the row level template (DLN1):

BaseType: it's the Object Type of base document (ORDR.ObjType) which is '17' in case of Sales Order

BaseEntry: it's the Document Entry of the base document (ORDR.DocEntry)

BaseLine: it's the row number of the line in the base document (RDR1.LineNum)

If you import your Delivery Notes with this info, the link to the Sales Order will be updated just as if you used Copy To in SAP.

Regards,

Nat

[Former Member · Accepted solution]

Natalia,

You provided the perfect solution. It's working. Thanks a ton.

Kind Regards,

IC

[Former Member · Accepted solution]

Brilliant, your welcome!

[former_member196081]

I think there is no as such field in dtw sheet ,

You can do one work around : take one udf at header level and add this udf field at DTW sheet.