web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / ASM Transaction question
Microsoft Dynamics GP (Archived)

ASM Transaction question

(0) ShareShare
ReportReport
Posted on by Community Member

It has been brought to my attention that there is an extra transaction that no one ever researched here.

On ASM transactions, an extra line appears with the quantity of 1 and a random dollar amount.  The purchasing manager has always seen this and just made a manual transaction to fix this.  

Has anyone ever seen this?  

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    To add to this, I've looked at 2 tables:  IV30300 shows EXTDCOST of $33,603.03 and a quantity of 4957

    But, table IV30301 shows two line for this - one with a quantity of 4956 and RCPTEXCT of $33,601.68 and a second line with a quantity of 1 and RCPTEXCT of $1.35

    This happens a lot - and the second line always has different amounts.  Trying to make a screenprint of the report I have but I cannot paste it here.

  • Community Member Profile Picture
    Community Member on at

    Adding more info and hopefully, someone can guide me in the right direction!

    For the situation shown above, I've got the following info:

    1.  BOM is entered with 4957 units at a total of $33,603.03               EXTDCOST

    2.  FIFO is used (FYI)

    3.  Line item detail shows 4956 units at an amount of $33,601.68     RCPTEXCT  (This shows $6.78 as current cost)

    4.  Extra line detail shows 1 unit at an amount of $1.35 which is the difference between $33,603.03 and $33,601.68

    Why does this extra line with 1 unit appear?  We want all the units to go into inventory at one amount and have the difference go into a variance account.  The extra line is messing up inventory dollar amounts (but not quantity) and a manual adjustment has been made every month!  

    Does this make sense?

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans