Fix for Error: Field ‘Company’ and ‘Lot ID’ must be filled in”

When editing a PO line for procurement category you receive Field ‘Company’ and ‘Lot ID’ must be filled in” error. This usually happens when you have brought in the PO line through some form of integration either AIF, excel plugin etc.

This error has also been seen on salesLine and there is a hotfix(KB 2756645) for when it happens on salesline.

Error

Reason:

There is no record in PurchLineForeignTradeCategory table related to PO line added.

 

Solution:

Create a record against the PO line causing this error in the PurchLineFroeignTradeCategory table in your integration and you will see the error disappear.

4 thoughts on “Fix for Error: Field ‘Company’ and ‘Lot ID’ must be filled in”

  1. Hi Mohsin,

    I am facing this issue while updating the Unit price on the PO line.
    I have manually created a PO line without ItemId (Only given the Procurement Category), the line created successfully, but when try to update the Unit price on PO line, this error is coming.
    I found that the “PurchLineDataAreaId” & “PurchLineInventTransId” value from table “PurchLineForeignTradeCategory” is missing while updating the unitPrice.
    I am unable to find at what point these values are getting deleted from “PurchLineForeignTradeCategory” table.

    Can you please guide on this?

    Like

  2. Hi,
    I’m having this error when creating POs through AIF, using a custom services, I have been trying to add the PurchLineForeignTradeCategory table to the query so it gets exposed on the web service, but can’t get it to work.

    Any ideas on how should I be doing what’s recomended on this post??

    Thanks so much

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s