Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Invoicing Process

Posted on by Microsoft Employee

Hi,

When ever we try to invoice an purchase order, there are some charges for freight and packaging is added, Based on these charges, The FOB Price and Unit cost Keeps Varying, Client says that unit cost should always be higher than the FOB, When i checked for the Couple of Purchase orders, i found the difference in the Pricing is Freight and Packaging, What is the standard way to allocate these charges and also to see  the price is always set right, Please help. This is all in AX 2012.

Thanks,

Abhy.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoicing Process

    sure thing will do.....

  • Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: Invoicing Process

    One more thing as this thread has many questions so please put a suitable title for it.

    Regards,

    Prashant Kumar.

  • Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: Invoicing Process

    Dear Abhy,

    1. You can cancel the effect of closing.

    Click Inventory management > Periodic > Closing and adjustment.

    Select the record of the inventory closing that you want to reverse, and then click Cancellation.

    2. If you want to track the creator you can enable record created by on table level and bring it in form design. But this is not applicable on exiting records.

    Regards,

    Prashant Kumar

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoicing Process

    Thank you prashanth ... For Patiently answering my Questions, So there is no way we can back track it , how about the last part of my question about the inventory if somebody by mistake run it , is there a way we can find who ran it .

    Thanks,

    Abhy.

  • Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: Invoicing Process

    Dear Abhy,

    If a purchase order has some charges like vendor fee, freight and nature of these charges are Dr. Item and Cr. Any payable account. In this case once you allocate the charges into the line these charges are allocated on PO line based on your selection during allocation. And you can see these charges in the line >> Financials >> Charges. But when you do partial invoice it these charges are allocated to the 1st invoice. Like you have an item and qty 10 unit price is 200 and charges 200. Your 1st invoice is for 5 item. You will find your inventory receipt is posted with 1200. And second will be 1000.  But when you will sale this item you will get COGS 220 if you are not using marking. So system maintain this automatically.

    If system finds some difference at the time of closing it post in GL. You can find some adjustment entry there.

    Please let me know if you need further assistance to understand this.  

    Regards,

    Prashant Kumar

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoicing Process

    Hi Prashanth,

    Thanks for the Quick reply, I'm Fairly new to AX 2012, there can be price difference I understand that , but let me give you an example a pen cost $10 for us from the vendor this is the FOB and When it comes to Cost It will include freight and packaging and any other misc charges if it says $11 , this is what I assume is right.But lets say if its a bulk order of 100 , I want to know if the freight and Packaging are applied to the Qty or the line item , Because one purchase order can have multiple invoices, I'm also aware of that these charges once posted, I cannot see it , so if we can go back to the tables to see allocated charges  is it by qty or Line item , because every single time it keeps changing,

    Because of this issue the inventory recalculation is not right, Also an other quick Question, Inventory close Report is which we use on a  month end close, but somebody actually ran the Report , we don't see any postings on the Ledger side, can we identify who ran the report

    Thanks,

    Abhilasha.

  • Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: Invoicing Process

    Dear Abhy,

    It is not mandatory that FOB and cost price are different. It depends if you are allocating any additional charges or not. If yes, definitely there will be a difference. 

    Also if charges differs for multiple receipt your running average cost will be changing. Also it depends your costing method. You can find the difference in inventory cost(COGS) between costing methods. You can use inventory recalculation if you have any issues in costing. 

    I think you cannot track back the charges in AX like how much charges allocated to particular item in a year or till date and its breakdown. 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoicing Process

    Thanks Vinod for the Reply.

    Sometimes the unit cost on the Product keeps changing, Our Team Says that unit price should be greater than the FOB Price, But it is not consistent after adding the Freight , packaging and other charges, I want to know why does it keep fluctuating and also is there way where we can identify if the charges are allocated to quantity or line item  , Can we back track it so ,we can say it is going against the line items , anywhere in the table or in the application itself.

    Thanks,

    Abhy.

  • VinodhK7 Profile Picture
    VinodhK7 285 on at
    RE: Invoicing Process

    Hi Abhy,

    Freight or other charges can be added to invoice header using Maintain charges form and it can allocated to lines with allocated charges by net amount, quantity or by lines. This the standard way. So final item unit cost will be line amount + allocated charges divided by line quantity

    Could you explain bit in detail where exactly you facing difference and what is your concern?

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans