Share
ReportHi Everyone,
1- I would like to know which purchase tables in Business Central are the right one to be query if we want to get the purchase order number, amount purchased, quantity purchased, lot number, location for orders that have been created and orders that have been received.
2- By default I see a table named purchase documents which contains purchase orders and blanket purchase orders and I am wondering if i should use this table and filter out blanket purchase orders
3- In general what is the best practices if we want to display sales/purchase numbers from Business Central data in power bi. Shall we query ledger entries or documents tables and then filter out what is not needed or shall we directly query the targeted sales/purchase table (e.g. posted sales invoice table or receipt purchase order table)?
All responses (
Answers (
2
