Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / DOC ERROR: Value &...
Microsoft Dynamics GP (Archived)

DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I am setting up Integration Manager to integrate inventory transactions.

I receive the above message for all transactions where the quantity exceeds 9,999,999 units. The integration works for all transactions where quantity is less than 9,999,999 units.

I've tried amending the formatting of the quantity column in the source file to no avail.

Does anyone have any ideas how to fix this?

The inventory quantity field in GP does allow for 14 characters, so it can't be the length (i.e.: 13,000,000 units is less than 14 characters).

Thanks, Robert

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

    Hi sk411, have you read the solution above on 15 Sep 2010 (wow 5 years ago) which allows quantities to be integrated up to 12 characters in length i.e.: 999,999,999,999 items. If you have quantities above this amount, then I'm afraid I don't think there is a solution currently.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

    I am having the same issue.  Is there a resolution or just the work around of bringing in less quantity?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

    Sorry I meant max is 12 characters i.e.: 999,999,999,999 OR -99,999,999,999

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

    Hi All,

    So I solved the problem.

    Integration Manager recognises the Inventory quantity field of your source file as having 5 decimal places (even if your source file quantity field is set to 0 decimal places).

    To fix the problem:

    1. In the Destination Mapping Settings, do not select "Use Source Field" for Items.Quantity field, instead set the rule for the Items.Quantity field to "Use Script".
    2. In the Rule Properties, click the lookup button for the Script Text rule to open the Script Editor window.
    3. Type the following Script: DestinationFields("Items.quantity")=Round(Sourcefields("Quantity"),0)
    4. Save and close.

    Your integration should now work for all quantities up to a max of 14 characters i.e.: 99,999,999,999,999 units or

    -9,999,999,999,999 units. Hopefully you don't need to integrate more inventory units than this. :-)

    Thanks,

     Robert

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

    Hi Everyone,

    Does anyone have any suggestions regarding this error.

    I have further checked that for each inventory item card, the quantity decimals field is set to 0.

    I am able to manually enter an inventory transaction entry purchasing 13,000,000 units. It is only when I try to integrate, the integration fails.

    Kind regards,

    Robert

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

    Hi Richard,

    Thanks for your swift response.

    In my Inventory Control setup window the Default Decimal Places for Quantities = 0.

    In my Integration source file, I do not have decimal places in the quantities column.

    Is there somewhere else in GP / IM that affects the decimal places for transaction quantities?

    Kind regards, Robert

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: DOC ERROR: Value '13000000' is not valid per destination field 'Items.Quantity' numeric format.

    And how many decimal places are you using?  8 to the left and 5 to the right of the decimal account for 13 characters.  Save one for the sign and there you are. 

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans