You’re offline. This is a read only version of the page.
Hi 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)?
Try PurchaseInvoices as the table instead.
As far as #3 I would say to just pull from Purchase Invoices and Sales Invoices.
Share
Report
All responses (
Answers (
2
