Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

how to assign prepaid freight to Items to be received or already received

Posted on by Microsoft Employee

We have to prepay freight and duties before the items are delivered to us. How do I now assign the freight and to the items that I am receiving? If we already posted the receiving without the freight/duty assignment - is there a way to correct the landed cost for this item?

*This post is locked for comments

  • Verified answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: how to assign prepaid freight to Items to be received or already received

    Hi Ernie,

    there is no standard way of doing this. As you said, if the invoice for freight and duty is posted  before goods are received, then you have nothing to create Item Charge for.

    What I usually recommend to my clients is follow this routine:

    1. When posting prepaid duty / freight, it has to go to the Accruals Account. That is where you'd normally expect it to be.

    2. When goods are received, create the invoice for the 'dummy' vendor with Item Charge and assign the value to the received goods.

    Now, the trick here is to have the 'dummy' vendor with the specific Vendor Posting Group, that would put the Credit into the Accruals Amount. This will clear the Accruals Account from step No.1, and debit the received stock with additional cost.

    You can also set up Vendor with specific payment method to clear the balance automatically (when Payment Method has Balancing Account specified).

    It usually does the job, at least from the finance perspective.

    Hope that helps.

    Robertas

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to assign prepaid freight to Items to be received or already received

    Thanks - but the problem I have is that I already Prepaid the Freight and duty.  Now I'm receiving the merchandise.  How do I now assign the freight and duty charges without adding a charge item on the PO as this would overstate the PO amount. I can do a credit memo to the freight and duty invoice.  Do the PO receiving for the merchandise  and then re-enter the freight & duty invoice as a charge item and assign it to the PO receipt lines. This is a round about way but I was hoping there would be a more direct way when dealing with Prepaid freight and Duty invoice.

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: how to assign prepaid freight to Items to be received or already received

    The best is to use allocation - item charges.

    Please refer here: msdn.microsoft.com/.../hh168616(v=nav.90).aspx

  • mmv Profile Picture
    mmv 11,465 on at
    RE: how to assign prepaid freight to Items to be received or already received

    Your actual cost may vary from exp. cost.  So, while invoicing, you have an option to apply the Item charge (if you are using Freight as the "Charge Item" ).

    You may refer the below link for "Charge (Item)".

    https://msdn.microsoft.com/en-us/library/hh168616(v=nav.90).aspx

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans