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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Shipping & Freight charges

(0) ShareShare
ReportReport
Posted on by 5,201

hi,

, please update us on the below 2 scenarios related to loading of Shipping & Freight charges in the Item Master.

 

Scenario # 1.       We have received shipment of 2 containers, and we are expecting more containers from Taiwan during next week. We would like to know if we can generate PO in GP, for the items received physically and make Receipt for it, and later on once we receive the original invoices for Shipping & Freight Charges, can we distribute this cost to these Items that have been already received in GP. (In short, can we allocate Freight charges to the Items for which Receipt is already maintained in GP)

 

Scenario # 2.       I would also like to know, if we can load the Freight charges on the item in the Item Master itself as Surcharge & Freight Charges. So whenever a receipt is maintained for this Item, the surcharge is already included in it, and in this case, we don't have to wait until we receive all the invoices. Though it might not be 100% accurate, but this will not stop our work. Since we have single source of vendor for this Item, we can also Link the Item to 1 particular vendor in GP.

 

Kindly let know your feedback, and the possibility to follow any 1 of the above mentioned options.

*This post is locked for comments

I have the same question (0)
  • Refeesh Ali Profile Picture
    5,201 on at

    please help

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    Hi Refeesh,

    For your first scenario you have received the item and after you receive original invoice you wanted to spread the freight to the item.  If that is the case can you change the item cost on enter/match invoice which will in turn add your freight to your inventory item.  let me know whether my understanding is correct.

  • Refeesh Ali Profile Picture
    5,201 on at

    we want to receive this item also consume it. so when we match the invoice the fright charges will be allocated to inventory onhand or will it include the quantity that is consumed . kindly let me know the steps how can i apply it.

  • babubaskaran@outlook.com Profile Picture
    12 on at

    Refeesh,

    are you saying that you consume the item after receiving it.  And you get original invoice of payable after consuming the inventory.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    Refeesh,

    Just to let you know that once you sold the item you received before book the invoice the cost of sales of the item sold remain same(it wont have any effect of freight addition).  And the price difference between shipment and invoice will be posted to purchase price variance.

  • Refeesh Ali Profile Picture
    5,201 on at

    is there any way to add the fright charge after posting receiving entry?

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    Refeesh,

    As I mentioned earlier when you change the cost of the item while doing the enter/match invoice which will in turn change your inventory cost from original to include the freight cost.  Hope I answered your question.

  • Refeesh Ali Profile Picture
    5,201 on at

    Hi Babu baskaran,

    I dint get it clearly,

    Actually we received a shipment physically in system. But we not added the Customs and Freight in Receiving. Is there any way to add it again on The same Po and spread this cost over the item cost.

    based on your answer i checked in my testing company. i created a PO with multiple item then i received 'shipment/invoice to make my warehouse quantity 'up' then i used 'enter/match' invoice option i cannot able to do any process. am i right or i want to do any other steps.

    Please advise Step by step.

    Thanks in advance and sorry for more questions.

  • Verified answer
    babubaskaran@outlook.com Profile Picture
    12 on at
    Hi Refersh, You have to do shipment (not shipment invoice) when you recive the item physically this will debit inventory and credit purchase accrual. And once you recive invoice you need to do enter match invoice during this time you change your unit cost to include freight. And entry for this will be debit purchase accrual and debit purchase price variance for the price difference and credit payable. Let me know if you have more questions.
  • Refeesh Ali Profile Picture
    5,201 on at

    hi Mr.BABU BASKARAN, the answer is perfect. its working fine in my testing db.

    but i have a doubt that i want to clear from you.

    my item cost i want to pay to the supplier whom i am purchasing goods based on my PO but frieght charge i am paying to another supplier so how can i apply to 2 supplier one is item purchasing supplier another company we are paying fright charge. i hope you understand.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans