Skip to Content
0

Extract All Item details From SAP Business One

Dec 21, 2016 at 07:28 PM

41

avatar image

Hi All,

I would like to create an external excel stock card for my inventory, so I need to export all item details from SAP Business One system.

I had export all the item info from Inventory > Inventory Report > Item List, but I found that UoM showed in this report are Inventory UoM only, does other report can show Purchase & Sales UoM?

Thanks In Advanced,

Raymen

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Dec 22, 2016 at 07:09 AM
0

Hi Raymen,

Please check out the Query Generator. With this tool you can create a report that will show exactly the information that you need.

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded
Honey Lyn Toyorada Dec 22, 2016 at 07:18 AM
0

Hi Raymen,

In the Item Master Data, find * to generate the Item List. From there click on Form Settings and specify fields names you would like to be reflected. Export the list to excel.

Share
10 |10000 characters needed characters left characters exceeded