Goods Reciepts in XL Reporter

[Former Member]

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?

[Former Member · Accepted solution]

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]

[former_member186095]

Hi,

In XL reporter, you can create G.receipt PO either using advance report builder or using report composer. There are no good receipt report available like what you find in PLD of B1.

Rgds,

[Former Member]

In XL report Goto Stock tab.. There use document type.. U can see all transaction if u sort according to Doctype u can see those goods receipts.

[Former Member]

I go to XLR Report Composer -> Stock Management tab.

Document Type does not exist under Stock Management tab.

It does appear however under Sales-AR tab.

When I drag Document Type down to report view and hit 'refresh' I get 2 results; the letters 'I' and 'S'.

What I need is every goods reciept (goods reciepts only) in one column.

Edited by: Paul Moran on Sep 23, 2008 3:04 PM