Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

replied

Paul,

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,

Brad Windecker

[Omega Business Solutions|http://www.omegagroup.com]

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question