Sage 100

Importing to Purchase Order Receipt of Goods - Is there any way to import the quantity received and have the receipt of goods bring the quantity ordered from the original purchase order? I've included the line key but that doesn't seem to make any difference. Am I missing something or is this WAD?

You're include L.LineKey, or you're including L.OrderLineKey?

@BethBowers I was missing L.OrderLineKey. Yay! Thanks for your help!

Out of curiosity, are you importing for Landed cost reasons?

@AndrewHagenbachCPA I'm not importing for landed cost reasons. The client has a different system that does the actual receipt in the warehouse and they wanted to import it instead of re-entering manually.

OK, thanks. I was looking for others who are being asked to calculate the landed cost outside the system like I have to learn how others are doing it. At times, I second-guess my approach on these matters. :)

I know this was one is dated but I wanted to ask. I have the line index number as well. Do you have to assign the item number and other information or does that pull in from the PO?

You at least still need the item and the Qty Rcvd.