Invoicing Process

(0) Share

Report

Posted on by Community Member 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

All responses (9)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Invoicing Process

sure thing will do.....
Prashant Singh 8,797 on at

Like (0)

Report

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 8,797 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 8,797 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 8,797 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 285 on at

Like (0)

Report

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?