Hi Nav Masters.
I have a problems. My client want me to create a report with column like this:
Item Code | Qty | Unit Price | Line Disc Amt | Inv Disc Amt | Total Amt | Purch Price (Cost) + Item Charge | GROSS PROFIT
I know i can get this from table : Sales Invoice Header and Value Entry to get the <Purch Price (Cost) + Item Charge>
But then my client want me to explain to them how to get those "Cost Amount (Actual)" and "Cost per Unit" from Value Entry
Because they said the value in my report is not correct.
They want to query the data from SQL Server directly to get the Cost for each item Sold including the item charge for each of those item, so they can see the correct GROSS PROFIT (Total Amt - Purch Price (Cost) + Item Charge)
I already try to find the relation but seems that i'm lost
My client using FIFO but without "Lot No." or "Serial No."
So can someone describe me how to link between Sales and Purchase?
Or how can i get the cost value that is in the Value entry table?
Is it possible?
I already try to see the relation between Sales and Purchase from table 339 Item Application Entry, but it seems that its not just relate the Sales and Purchase, but also relates the Transfer and other things.
I thought at first i can get it with logic from Form 38, then click Application - Applied Entry. I can see the Purchase related to that Sales, if i can find the Purchase, its easy to find the Item Charge for that Purchase.
But then i find that some Sales related to Sales or Transfer. ](*,)
Please help me, because i need to know this in details and Microsoft Nav don't have it in their help document.
Thanks in advance