Goods Reciepts in XL Reporter
In Business One -> Stock Management -> Stock Transactions -> Goods Reciept.
I add 3 Goods Reciepts.
My question is how do I view these Goods Reciepts in XL Reporter?
Brad Windecker replied
To do this, the easiest way is to use the Get Other Data function in Report Designer
Launch Report Designer
Click in cell A8
Click the formula builder on the XLR Toolbar
Go to the Functions Tab
Click Get Other Data
The user ID and Password are the B1 login you use
The table should be IGN1
Fields type: DocEntry, DocDate, ItemCode, Quantity
Generate the report
You may need to add at least one expansions or summary. You can put an expansion for BPs in a column and then hide it. This is because XLR needs at least one expansion or summary to run a report.
This will give you a list in XLR of all Goods Receipts, their data, items and quantities.
It's effectively the same as writing a query, but it can be run automatically on an interval as can any other XLR report.
Hope that helps,
[Omega Business Solutions|http://www.omegagroup.com]