Hi,
Basically I would just like to have a Net sales and Cost of goods sold report in an Excel table that shows exactly the same Net sales and Cost of goods sold amount in total that is in the Income Statement for a particular period. It needs to include at least the following parameters:
Type (item, G/L account)
Item no (or G/L account nr if not an item)
Item description (or G/L account description)
Order nr
Invoice nr
Customer name
Posting date (actual transaction posting date)
Dimension1
Dimension2
Country name
Sales amount (LCY)
Cost amount (LCY)
Quantity
I have browsed through Web Services but I am a bit overwhelmed. Today I use the Item ledger entry as source (Odata to Excel), however for net sales I would like to use posted sales invoices data instead of outbound deliveries which seems to be the source for Item ledger entry. If I use the item ledger entry data then it show as sales as soon as we have shipped the goods from stock. I would also like to include surcharges invoicing like freight, which is booked against a G/L cost account. Also, any inventory adjustments (that are not related to a sale) needs to be displayed (otherwise it will not match the cost of goods sold in the Income Statement).
It seems like page Sales Invoice Statistics (397, ListPlus) and table Sales Invoice header (112) have useful information stored regarding the sales amounts and costs but this is only on invoice header level.
Is this possible to do?
Many thanks for the help.
