Skip to main content
Solved

Alternate ID updated from Vendor Price Worksheet


Forum|alt.badge.img+1
  • Jr Varsity II
  • 23 replies

When releasing a Vendor Price Worksheet why does the Alternate ID not copy across to the vendor price?

Best answer by Irina

AlternateID column on Vendor Prices form is only for the manual entering on this screen, and its value doesn’t flow to Vendor Price Worksheet because it simply not supposed to, there is no such functionality described in the documentation. This value only has logic described in the article from my previous comment, so I suggest to create import scenario for Price Worksheet, not to Prices form.

I suggest submitting additional functionality you need as a product idea on the https://community.acumatica.com/ideas

View original
Did this topic help you find an answer to your question?

7 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 504 replies
  • February 17, 2021

Hello @jon95, sorry for the long reply.

Please advise, which version do you use?


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 504 replies
  • February 17, 2021

Actually, I found what could cause the issue.

In order for the Vendor Price Worksheet to recognize Alternate ID's, on the AP Preferences (AP101000) form, make sure that the Load Vendor Prices by Alternate ID checkbox is enabled. For more info, refer to the Item Cross-References help article, Uploading Prices with Alternate IDs and Creating Alternate IDs from Price Worksheets section.


Forum|alt.badge.img+1
  • Author
  • Jr Varsity II
  • 23 replies
  • February 17, 2021

Hi Irina

 

We are using 2020R2 Build 20.201.0051.  We do have the system set to load vendor prices by alternate ID, my question was related to when the pricesheet is released.  The alternate ID does not populate in the Vendor Prices form.  See below vendor prices form, all these items were loaded by a vendor price worksheet using the Alternate ID.  The alternate ID column is blank.

 


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 504 replies
  • February 17, 2021

Thank you, I was able to see the same on SalesDemo.

So looks like the Vendor Prices form doesn’t show Alternate IDs, when they actually are presented on the Cross Reference tab of the inventory item.

I will check with the development.


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 504 replies
  • March 12, 2021

Hello @jon95, please refer to the following help article for the Alternate ID field functionality on price worksheets forms:

Uploading Prices with Alternate IDs and Creating Alternate IDs from Price Worksheets

 


Forum|alt.badge.img+1
  • Author
  • Jr Varsity II
  • 23 replies
  • March 12, 2021

Thanks Irina.  Did you find out why the alternate ID’s don’t show in vendor prices after the worksheet has been released?  In our case there is a vendor cross reference already setup in the stock items screen, these are not new cross references.  It seems the only way I can get those alternate ID’s in the vendor prices is by using an import scenario (or manually enter them).  Even if I import them through a scenario the next time they are updated using the worksheet method they disappear again.  Below is an example of an item loaded into a worksheet by alternate ID, then released.  In the vendor prices afterwards the alternate ID is not listed.

 


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 504 replies
  • Answer
  • March 13, 2021

AlternateID column on Vendor Prices form is only for the manual entering on this screen, and its value doesn’t flow to Vendor Price Worksheet because it simply not supposed to, there is no such functionality described in the documentation. This value only has logic described in the article from my previous comment, so I suggest to create import scenario for Price Worksheet, not to Prices form.

I suggest submitting additional functionality you need as a product idea on the https://community.acumatica.com/ideas


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings