Skip to main content

Notifications

Announcements

No record found.

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

  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Item charge assignment new calculated field

    [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.

  • Community Member Profile Picture
    Community Member on at
    RE: Item charge assignment new calculated field

    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
    RE: Item charge assignment new calculated field

    Hello,

    What do you mean by "affected"?

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

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June 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 NAV (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
EH-09052238-0 Profile Picture

EH-09052238-0 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans