Hi

[Former Member]

Please help me out  in SAP BusinessOne, what are the tables to select for generating crystal report,

The pick list and the packing slip will be combined into one layout, but it will be divide in 2 parts.

1. Pick List (to collect the items from the warehouse)

The pick list will be grouped by item and a summary by quantity in order that the worker will just see that he have to bring to the packing area an x amount of an item, and the pick list will not have any order detail.

2. Packing Slip (to put in the box)

The packing slip will be a separate page for each order, and it with have all the order details.

Now when the warehouse manager will produce and print a pick list the pick list and the packing slip will be combined into one report.

The report should have 2 parts the main report and a sub report.

The main report will contain the pick list and the sub report will contain the packing slip, or vice versa

[edy_simon · Accepted solution]

Hi,

The easiest way to know the tables involved will be through the SBO Client.

Under the View Menu, Check the 'System Information' menu.

or Short cut is Ctrl+Shift+I.

Then open your Pick List form, now if you hover to any of the item in the header you will find something like

at the status bar below you will see the table name OPKL.

following SAP naming conventions, the child tables will be PKL1 and PKL2.

Regards
Edy

[Former Member · Accepted solution]

please add me as a friend, so that i will send private msg to you,

I have many queries in SAP Business One, please help me out

[edy_simon · Accepted solution]

Hi sap b1,

You can ask any question re. SAP in this forum.

I am not by any means experts in all the area of B1, we are all learning together here.

If you post your questions here, it might help others also in their learning curve.

Private messages will not help others.

I am sure many other experts will gladly help you with any of your queries.

Merry Christmas!

Regards
Edy

[Former Member · Accepted solution]

Hi,

I have tables ORDR, RDR1

I wanted to get the fields from both the tables those are Item code,Quantity,delivery date and doc number

but both the tables not having common fields

when i am displaying delivery date, doc number from ORDR table its a blank value.

blank value when i created Delivery Date from pick list form

pls guide me what is the actual process to get.

[ANKIT_CHAUHAN · Accepted solution]

Hi,

The common field between ORDR and RDR1 table is DocEntry.

So you need to join between DocEntry.

Hope it Helps.

Thanks & Regards

Ankit Chauhan

[edy_simon · Accepted solution]

Hi,

Please use SQL server management studio to query both table.

The SAP Query generator will hide some columns.

The easiest way to get a link between two tables is to add the tables in the query generator wizard and see the result query given by the SAP.

Note that not all table can be link via the wizard.

Regards
Edy

[Former Member · Accepted solution]

Thank you