Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Product No. must have a value in Price Asset

Posted on by 25

Hello,

i have exposed new API for the source table "Price list lines" and on trying to insert new records to the table via API i am getting an error:

 "message""Product No. must have a value in Price Asset: Entry No.=0. It cannot be zero or empty. ..."
my request json:
{
            "priceListCode""J00004",
            "amountType""Price & Discount",
            "assetID""b364eb79-b861-ed11-8c36-000d3a667925",
            "assetNo""KATHERINE",
            "assetType""Resource",
            "description""Mindaugas Jasiulis",
            "priceIncludesVAT"false,
            "priceType""Sale",
            "productNo""KATHERINE",
            "sourceType""Job",
            "unitOfMeasureCode""VAL",
            "unitOfMeasureCodeLookup""VAL"
 
        }
not able to figure out what has to be changed...
Categories:
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Product No. must have a value in Price Asset

    Then you could raise a support ticket with Microsoft through your CSP partner.

  • Fisher A Profile Picture
    Fisher A 25 on at
    RE: Product No. must have a value in Price Asset

    its online...but still get this error :)

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Product No. must have a value in Price Asset

    Are you running Business Central online or on-prem?

    If you are online then you should already have this fix in your system.

  • Fisher A Profile Picture
    Fisher A 25 on at
    RE: Product No. must have a value in Price Asset

    I first Request Get Api request, and receive data, that were inserted via BC Web UI. Then i try to import one more simillar record to Lines table, and get this error.

    i found that there were some bug fixes regarding this error but no details about it.

    support.microsoft.com/.../update-17-6-for-microsoft-dynamics-365-business-central-2020-release-wave-2-application-build-17-6-23727-platform-build-17-0-23708-5204bd69-9c14-44ca-b1bc-aaee9aaef94b

    "Product No. must have a value in Price Asset" error message displays when you enable the new pricing feature.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Product No. must have a value in Price Asset

    Are you sure that the productNo you use actually are present in Business Central?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans