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 NAV (Archived) / Item charge assignment...
Microsoft Dynamics NAV (Archived)

Item charge assignment new calculated field

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

We use item charge for haulage costs

The Hauliers we work with charge us by the pallet (Shipment containers)

I want to create a new calculated field of purch rec lines that returns the number of containers (that would be Quantity on Purch line/ Qty per shipment containers on item card)

and add this field to the options on the assignment.

My question:

Does the purch rec line get affected by the item charge assignment?

My undrstanding is that it's not so the mod should anly apply to Purch rec lines, Warehouse rec lines and item charge assignment

Would appreciate any feedback about this mod before start working

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at

    Hello,

    What do you mean by "affected"?

    The original line on which you apply the Item Charge is not amended in any kind.

  • Community Member Profile Picture
    Community Member on at

    Hi Hannes

    I wanted to understand if the line on which the charge is applied is amended

    You confirmed my understanding of the code behing this.

    The Qty on the Purch rec line is just a numeric field used to calculate the amount of the charge that is applied

    Specificaly (Tot charge amount / Sum of "New field" Qty on Purch rec lines)* "New field" Qty on Purch rec lines

    Thanks

  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at

    [quote user="A.Iorio Rondanini UK LTD"]

    I wanted to understand if the line on which the charge is applied is amended

    [/quote]

    Yes, this line will not be amended.

    The relation between Item Charge and applied line is stored in the Tables 5805 "Item Charge Assignment (Purch)" and 5809 "Item Charge Assignment (Sales)". This information is then later used during posting to create the corresponding Value Entries and G/L Entries.

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 NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans