Question

Sales price worksheet error when processing the field UOM

  • 11 April 2023
  • 3 replies
  • 92 views

Userlevel 2
Badge

We are trying to extract and update the base sales price using either ‘Sales price’ or in the ‘Sales price worksheet’ then using the copy prices option.  When we click on the ‘create worksheet’ or ‘copy prices’ we get the below error:

An error occurred during processing of the field UOM value LENGTH Error: UOM 'LENGTH' cannot be found in the system. Please verify whether you have proper access rights to this object.

We have tried to change the UOM for the rows with Length but we just get the same error but with the UOM we changed it to mentioned.

Any suggestions?


3 replies

Badge +16

Hello,

Is the “Length” Unit of Measure listed in Configuration → Units of Measure screen or on the Inventory Item whose Sales Price is being updated, in the Units of Measure section of the General tab of Stock Items screen?

Are you having trouble with an import of Sales Prices, or with manual entry of Sales Prices, or both, or something different like a custom program? 

  1. If you are importing, then please show the import scenario.
  2. If you are manually entering then please show the screen so we can look at a line or two of data. 
  3. If the screen is customized, do you see the same results with customizations related to Inventory and Sales Prices temporarily unpublished?

The extra details will help us to answer you.  Thank you.

Userlevel 2
Badge

Hi Laura,

Yes Length is set up as a UOM.

We are trying to use the Sales Price Worksheet process.

Steps are:

Create new worksheet.

Click ‘Add Item’ - choose items 

Click ‘Copy Prices’

change Price Type to ‘Base’ on both source and destination:

Click ‘Copy’

We get this error:

 

Userlevel 7
Badge

Hi @steph23 were you able to find a solution? Thank you!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved