Small and medium business | Business Central, N...

Reporting from Value Entries - connecting sales and purchases

(0) Share

Report

Posted on by Sunilkumar

104

I do reporting in Excel via Odata connections to Business Central. We buy stuff and then sell it, but we do not use Drop Shipments.

If I look at Value Entries and filter by Source Type = Customer, I can see all sales with their costs (costs expected + costs actual). This is nice. The problem is: I want a breakdown of the costs. I want to know, for example, how much Item Charges (e.g. transport) on the purchase side affect costs reporting. I can see this if I filter Source Type = Vendor, but I cannot connect the lines to the respective sales. Or, even if I could (via Item Application Entries), the costs are already added to sales via adjustments.

Can I detect the exact source of an Adjustment in Value Entries? I've spent hours trying to figure this out.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

MahGah 15,613 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

This is the hard one. I believe the table that can help the most is Item Application Entry which is Table 339 . I do not know if any page is available for this table to publish as ODATA. In that table you have inbound and outbound info (like PO and SO). Then for each outbound you can get inbound item ledger entry. Then in Value Entry find that Item Ledger Entry and find related costs.

I am not sure what is Item Charge No in Value Entry does but maybe you can have a better idea than me.

Was this reply helpful? Yes No
Sunilkumar 104 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the answer. Item Application Entry is available for publishing as odata and I've tried to work with it. Item Charge No. shows the Charge No., e.g. FREIGHT, meaning that it is easy to find out FREIGHT costs for sales and purchases, but connecting these...

The problem I have with this approach is:

- For purchases, the costs are recorded in Value Entries as Cost Amount (Expected) and Cost Amount (Actual)

- For sales, the sales are recorded in Value Entries as Sales Amount (Actual)

- But also, for sales, the costs are recorded as Cost Amount (Actual), but the source of the cost adjustments cannot(?, this was my original question) be tracked

Was this reply helpful? Yes No
Suggested answer

MahGah 15,613 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Can you please tell me which page you published for Application Entry (Table 339) I could not find any method to do that.

Maybe I am missing something. In Item Ledger Entry if I filter for Entry Type = Sales then I can see all sales and as you mentioned I can see Cost Amount (Actual). Here I can click on Cost Amount (Actual) then I can see all transactions that contributed to that cost (sorry my example is not a good one since I could not find a better one).

Is this what you were looking for?

Was this reply helpful? Yes No
Sunilkumar 104 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, I see the answer exists. I will do some testing.

There's a page for Item Application Entries, 506, and I was able to publish it as ODATA.

Was this reply helpful? Yes No
MahGah 15,613 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for Page 506. I did not know that.

Was this reply helpful? Yes No