Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[aufrech lasia moukoko]

Hi All,

I need assistance on how the ”Customer/ Sales Items Report” calculate .

1) How does the profit showing on the report is generated ( What is the source data of the ”Amount column and The profit)

2) Is it possible to have only the profit Showing on the report without its corresponding amount and quantity? ( this is the issue i have currently)

3) What can cause the Profit to show as negative while there is no Amount neither Quantity

4)The calculated direct cost (Amount – Profit) is different from the Direct Cost from the G/L . how is this possible?

Status of the issue:

I am currently working on the issue  and would have to fix this today , your input to assist is very crucial.

Kindly take note of some check i have done: 

1) I dont have any direct posting on my Revenue G/L account

2) The Total Amount (Revenue) of the report is the same as the revenue showing on the Revenue G/L account after check

the issue seems to be complex on my understanding because there is no Amount neither quantity for lines were the report is showing negative profit. So There is no starting point of transaction for me to drill down and check.

Thank you for your assistance.

——————————
aufrech lasia
Infos
——————————

[aufrech lasia moukoko]

Hi All,just an update of my finding may be it will help someone in the futur.

The negative showing on the Sales statistic report is actually an update of Cost of goods sold for items already sold for which the system did not update cost because the adjust cost function went off and the period in which those cost were supposed to be posted have  already been closed so the system will post the cost in the next period. because revenue was reported in the previous period this will show as a negative margin.

Now please if someone can just give me a brief detail on how NAV calculate unit cost of the inventory method FIFO and how does the adjust cost affect the unit cost when it run daly or when it has not been run what is the effect on value entries and G/L.

Thank You!

——————————
aufrech lasia moukoko
Infos
——————————
——————————————-

[Val Gameiro]

With FIFO, NAV goes to the Item Ledger Entries table and uses the cost of the oldest line that has a Remaining Quantity.

The Adjust Item – Cost Entries batch goes in and balances the Item Ledger to the G/L.

For instance, when you receive a product, it records the Expected Cost on the Item Ledger, but not the Actual Cost.

Then, when you invoice, you can change the price/cost, at which point you’d have a difference. The Batch will fix that, also based on the costing type.

That’s my understanding of it. Hope that helps.

——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma
Austin, Texas
——————————
——————————————-