AR invoice layout to have Lot Number from Serial Number table

[too_muihwee]

Hi All,

I have some items that are managed by serial numbers. I have make use of 'Lot Number' column inside OSCN to keep some infor. So when i issue invoice with Serial Number items, i wanted to display this Lot Number info together with serial numbers, is it possible?

E.g.

Item A - Item A Description     1pcs      $10.00

S/N: 123

Lot Number: 8274 ( i need this to display)

Anyone can help? Thanks in advance.

[julie_jamieson2]

There is a system layout that displays the batch & serial numbers with the invoice, but may not have the lot number detail.

I haven't used lot numbers, so cannot validate that.

You can try holding down the ALT key while you selet the database table, which will display all the available tables, but you will need to work on the joins after adding the field (link to & relate to)

[KennedyT21]

HI Too Mui Hwee,

Try to add a UDF from the in the Invoice and by fms try to save the Lot number in the inv1 and from that pull the data required.

Regards

Kennedy

[too_muihwee]

Hi Kennedy,

If the item has few qty, it is impossible to create multiple UDF just for each pcs. What if the invoice involved 20 pcs together for same item? Unfortunately, this option is out.

[too_muihwee]

Anyone have other solutions?

[Former Member]

Hi......

Try with Crystal that will definitely work for you..........

Regards,

Rahul

[former_member186095]

Hi Too,

I've seen that you use OSCN but OSCN is the BP catalog no. table.

You can use the table OINV, INV1 and OSRN. There is a lot number field in the OSRN. I see the field in the OSRN table of SAP B1 8.82 PL07. You can upgrade to the version first.

You can use query print layout designer instead of print layout or crystal report.

JM

[too_muihwee]

Hi Jimmy,

You mean use Query Print Layout for all my invoice print out? Will that work?

I think it will be very difficult as Layout designer has it own logic built in, if i am going to create layout base on query only, it might not be able to cater for all scenarios.

Upgrade option is out as well as this customer has lots of customization and they are just being installed with 8.81 PL11. So it is unlikely for upgrade at this moment.

[former_member186095]

Hi Too,

You are correct. You just can create query and then create a report based on the query.

You have to assign the lot no field in the repetitive area footer.

I think query PLD is one of the report that you can use to solve the problem

Regrs,

JM

[Former Member]

Hi.........

Are you making Delivery Document before AR Invoice?

If yes then I guess you have to include DLN1 with OSRN table and OINV and INV1.........

Regards,

Rahul

[too_muihwee]

Hi,

I don't create DO before AR Invoice, so the serial number is selected at AR Invoice screen.

[Former Member]

Then Its possible to use OINV, INV1, OSRN and OSCN tables in joins.

Regards,

Rahul

[too_muihwee]

Hi Rahul,

Are you talking about Crystal Report? I would prefer Layout Designer, any solution using Layout Designer?

[Former Member]

Very Hard luck with Layout Designer. Because it has limited functionality.......

So you are suggested to go for Crystal Report.......

Regards,

Rahul

[former_member184718]

Hi,

You can check this in PLD. Add a new database field, in its Properties window in content tab, select the table 'OSRN' and select the field LotNumber.

Thanks.

Hari

[too_muihwee]

Hi Hari,

I couldn't find OSRN in the table list. I tried using OSRI but if i have 2 pc, it will list out twice as in it appear duplicate on my Invoice layout although my invoice only have one item.