Skip to Content

SAP B1 9.3 has special inventory costing report?

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.

untitled01.png (69.8 kB)
untitled02.png (19.0 kB)
untitled03.png (26.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 17 at 05:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 05:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23 at 06:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 24 at 04:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded