Sales Jurnal

e2rd

Hi,

On of my clients wants to have a journal sales for some product groups like this

Dr A/R (acc BS) 80
Cr Sales (acc PL) 80

Dr COGS (acc PL) 100
Cr Inventory (acc BS) 100

And they want to automatically record their 20 lost into their promotion cost like this journal

Dr Promotion Cost 20
Cr Sales 20


How to solved the last journal to record their lost in promotion cost, if any NSC partner in mibuso have solution for this, could you help me to solved ](*,) .

Thanks

Daniel

ara3n

Hello Daniel
The solution would be a simple modification. Add a new field for promocode and promo cost. to the sales header. In CU 80 post a journal with hitting the two gl accounts. Shouldn't take more than 2 hours of development and testing.

The question is are the promo codes, cost of goods sold, if yes, I would rather create a purchase invoice use item charge to increase the cost of inventory, instead of decreasing the Sales

e2rd

Thx for the reply, actually the problem story like this :

This company buy back from their customer the goods that they can't repair because the sparepart not exist anyway. With the price 100, then a technician tries tp repair and succes so the repair items back into the inventory again, and they sell the item lower the cogs 80, and they want to record 20 value difference as the promotion cost.

Ara could you explain what you mean by increased the cost of inventory by using purchase invoiced with item charge.

Thanks

Daniel

e2rd

Hi Ara3n,

May i know which part oof code unit 80, that i must customized to create journal that i need, Thanks


E2rd

ssingla

Dear Friends,

It is not as simple as it looks like. In the scenarion given we are considering a single item sale, return and resale.

The example assumes we know the cost of the item but in actual scenario where lot of transactions are happening and the adjust cost bacth job is run after the transactions have happend.

So what will happen if the COGS is affected due to that.
Will we create a new entry that will transfer the adjusted cost to that sales promotion account ??? :-k :-k :-k

e2rd

Hi Mibuso Community,

How to make the customization if i want to make a journal like this. Which section of code unit 80 i have to customized so the post the journal could create this journal, thx for the reply.


Daniel