SAP B1 9.3 has special inventory costing report?

[former_member20262]

One client creates 3 Goods receipt PO with different cost and batch number (1,2,3) and this item is using FIFO.

Then user deliver the second stock with batch (2) to their client.

GRPO 1, item cost $100, batch 20190116-1

GRPO 2, item cost $105, batch 20190116-2

GRPO 3, item cost $110, batch 20190116-3

Delivery 20190116-2 to their client

They would like to show the inventory audit report that according the batch number not FIFO one.

They would like to show 105, not 100.

Since other SAP B1 partner told them that after upgrade to SAP 9.3, it can show the result that they want.

I would like to know, do you hear about that? or it really have this function, that I don't know.

[former_member20262]

Dear All

Is it Batches and Serial Inventory Audit Report?

I try to run it, but it cannot show the item that I input on the above.

If I choose the run one, please let me know the correct report or document.

Regards

Edmund

[Abdul]

Try valuation method according to batch number, further SAP does not make any changes with out proper documentation ask your partner to share such document or search by yourself on support portal and check whats new document in SAP B1's setup folders

[former_member225732]

Hi,

In your case system will take price FIFO basis only regardless what batch you are selling.

If you want you can set valuation method as "batch/serial" to overlook the issue.

Hope this will helpful to you.

Best Regards,

Sandesh

[kothandaraman_nagarajan]

Hi,

Using FIFO methods, it not possible show to according to batch number.

SAP has introduced Batch valuation method. Please find revalent document from SCN or SAP help files.

Regards,

Nagarajan