Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager an...
Microsoft Dynamics GP (Archived)

Integration Manager and Sales Transactions

(0) ShareShare
ReportReport
Posted on by Rszeto 765

Hi,

 

I'm importing 20 sale invoices to GP through Integration manager. Does anyone know how to map Quantity, Billed Quantity, and Quantity Fulfilled? I've tried mapping all three to the same field, (hours rounded = 1, 1.5, .5, .25, etc.) and I got the following error message:

 

DOC 1 ERROR: Quantity Fulfilled for item CONSULTING-PLATFORM is greater than the line item's remaining quantity. - Quantity Fulfilled for item CONSULTING-PLATFORM is greater than the line item's remaining quantity.

DOC 2 ERROR: Quantity Fulfilled for item CONSULTING-IAAS is greater than the line item's remaining quantity. - Quantity Fulfilled for item CONSULTING-IAAS is greater than the line item's remaining quantity.

DOC 5 ERROR: Quantity Fulfilled for item CONSULTING-ERP is greater than the line item's remaining quantity. - Quantity Fulfilled for item CONSULTING-ERP is greater than the line item's remaining quantity.

 

Next, I mapped Quantity, Billed Quantity, and left Quantity Fulfilled as default which came up with no errors. But when I printed a batch edit list, my quantity fulfill does not match my quantity. Surprisingly all the line items have a Quantity Fulfill of 1.

 

Lastly, I only Mapped Quantity and left the other 2 options as default. I then got the following error:

 

DOC 2 ERROR: Quantities for item CONSULTING-RCM on line 2 are not properly distributed. - Quantities for item CONSULTING-RCM on line 2 are not properly distributed.

DOC 3 ERROR: Quantities for item CONSULTING-ERP on line 2 are not properly distributed. - Quantities for item CONSULTING-ERP on line 2 are not properly distributed.

 

Does anyone know what the issue is for mapping the quantity?

 

Thanks.

*This post is locked for comments

  • Rszeto Profile Picture
    Rszeto 765 on at
    RE: Integration Manager and Sales Transactions

    Hi,

    I'm mapping both Quantity and Billed Quantity to the same field. So ideally IM should be taking the same information for these two fields. Take for example, I have 2 Quantities. I want 2 in Quantity, 2 in Quantity Billed, and 2 in Quantity Fulfilled. But Instead, GP is giving me, 2 Quantity, 2 Quantity Billed, and 1 in Quantity Fulfilled. I think I'm getting a 1 because I left Quantity Fulfilled as "Default". When I map Quantity Fulfilled to the same field, it gives me another error - DOC 1 ERROR: Quantity Fulfilled for item CONSULTING-PLATFORM is greater than the line item's remaining quantity. - Quantity Fulfilled for item CONSULTING-PLATFORM is greater than the line item's remaining quantity.

    When I tested a sales transaction, Quantity Billed and Quantity Fulfilled are auto-populated once Quantity is entered. GP will not let you go any further if the three fields don't match. So I guess my question is how do you map the quantity field? Do you create 3 separate columns with the same information and map it like that?

    Thanks for your reply.

  • soma Profile Picture
    soma 24,410 on at
    RE: Integration Manager and Sales Transactions

    Richard is correct. Try to manually enter a transaction with same data provided in IM import file. If the manual transaction works, then start IM to integrate the transactions.

    Hope this helps!!!

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Integration Manager and Sales Transactions

    SOP has some very specific rules that must be followed when entering data into the line items about quantities.  For example, the quantity fulfilled cannot exceed the invoice quantity nor can it be less than the billed quantity.  If any quantity is in the quantity back ordered field, the quantity that can be fulfilled is reduced by that amount.

    Try taking your data and manually entering a sales transaction.  The combination that works is the one you want to use in IM

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

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans