The Currency/Price Level/U of M combination is not included in the price list for this item.

(0) Share

Report

Posted on by Community Member

Hello,

I am trying to import a sales order in Olympic Project cost. I Import the excel file in PC Transaction Import without any issues. After I go to Create SOP Transactions to process my import but I run into an issue. I got the error message

Transaction Error

49,758 Missing SOP_ID_SETP record for: PG

49,758 The Currency/Price Level/U of M combination is not included in the price list for this item.

I am not sure what this mean. I tried to do a search and what other have suggested but nothing seems to work. I was told to try a noninventory item but I am not sure how to set that up.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (24)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report
To handle this, you will have to consider one of the following options:

Define a price list for this item, which in turn include a price level, currency and unit of measurement. Once a price list is defined, the item will automatically pick the associated price as derived from the quantity range. To define a price list, Go to (Cards > Inventory > Price List)

Another option is to pass the price, and tell the system that there is no need to pick a price from the price list, the option is (prices not required in price list)
Microsoft Dynamics GP > Tools > Setup > Sales > Sales Order Processing (uncheck the highlighted option)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

Option one would not work because the price changes every time. I already have the "Price not required in Price List" checked but still get the error.

Thank You

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (1)

Report

Allow me to understand the problem more clearly then,

If you go to Dynamics GP and manually enter the same transaction, would you have such errors ? Or you can proceed and enter all the details and save the document without any issues ?

Now, what is the integration method that you consider which retrieve this error ? eConnect ? If so, please share the XML parameters for further assistance,

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

And your SOP ID 'PG' for which you are getting error is setup in GP or not?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sorry for being unclear. I do not get any error when manually entering it in GP. I am able to enter the full order without any issues.

The integration method I am using is Olympic Project Cost Transaction Import

These are the XML parameters.

Billing Quantity 2000

Cost Account Number default from system

cost category Material

Item Description Shirt

Item Number ARMRG01

Date 4/2/2014

Doc # G102072

Project ID MAD 15730

Sale account number default from system

Sub Cost Category None

Task ID ARMRG01

Transaction Date 4/2/2014

Unit of Measure Units

Unit Price 1.00

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am not sure what that mean. I added the XML parameters above and I do not have any field that has "PG" in it.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at

Like (0)

Report

Your source file must have a SOP ID value of 'PG' in it. This message is telling you that SOP ID does not exist in GP. Look in Sales>>Setup>>Sales Order Processing>>Sales Document Setup and review the Sales Order Document ID's that are set up. Either you need to use an existing SOP ID or change the SOP ID value in your source file.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much Frank! The missing SOP_ID_SETP error was fixed but I am still getting the 2nd error (The Currency/Price Level/U of M combination is not included in the price list for this item.)

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at

Like (0)

Report

I would call Olympic. Not sure why you're getting the second error when you don't require prices in the price list. It may be something specific to their code.

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

and your newly created sop id is correctly setup for item price?

i thought you also say thanks to me but anyway ;) just kidding..

mmmmmmmmmmmm

Was this reply helpful? Yes No