How to split item quantity into two different items

(0) Share

Report

Posted on by Community Member

HI,

I found an item number in my system that is two different items in physical. Suppose Item no. 15535 has physical 6 quantity. But physically 2 related to same number and 4 pcs are different. Now I want to segregate these 4 pcs to new number.

Please guide to how can segregate 4 pcs to new item number because price is merged.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

OsmanIstanbul 2,818 on at

Like (0)

Report

RE: HOW TO SPLIT ITEM QUANTITY INTO TWO DIFFERENT ITEMS

Hello Muneer,

You can use bills of materials journal. select 15535 as bom line and quantity -4, and select new ıtem as bom and quantity +4.

Best regards,

Osman.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: HOW TO SPLIT ITEM QUANTITY INTO TWO DIFFERENT ITEMS

Mr. Osman

Cost for 2pcs is 3000 and and for 4 pcs is 45000.

Was this reply helpful? Yes No
OsmanIstanbul 2,818 on at

Like (0)

Report

RE: HOW TO SPLIT ITEM QUANTITY INTO TWO DIFFERENT ITEMS

Mr Muneer,

you can use cost price field. -6a bom line> +2a price 1500, +4b price 11250. but if your 6pcs a has different cost then total cost (48000), difference will post to revenue or loss account.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (1)

Report

RE: HOW TO SPLIT ITEM QUANTITY INTO TWO DIFFERENT ITEMS

Hi Muneer,

What inventory costing model are you using? In general, you can use inventory adjustment journals, but the costing might need additional actions due to the costing method.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to split item quantity into two different items

We are average costing method.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to split item quantity into two different items

Hi Muneer,

In this case, you can use the inventory adjustment journals. For the positive quantity, specify the correct cost amount. After posting, you can mark the negative transaction with the old receipt inventory transaction. When you then run an inventory recalculation or closing, it will settle the cost price for marked entries first. When no marked entries exists, it will use the default logic for average costing.

Was this reply helpful? Yes No