SALES DELIVERY BY FIFO METHOD

[Former Member]

Suppose Customer u2018C01u2019 give me sale order first,after that my second customer u2018C02u2019 give me sale order of same Item that u2018C01u2019 give first but my employee give material to second customer first, I want to block the this process ,I want sales process like FIFO

So how it can be happened

Plz reply me

[Former Member]

Hi Jaykumar.......

Welcome to SAP Business One Forum............

Actully you can do the same by Batch Allocation Concept which you have to book batches at the time of Sales Order if your Item is managed by Bar=tches.

Else you can control this by Approval Procedure or SP Transaction Notification........

Regards,

Rahul

[Former Member]

Hello rahul

my item process is already batch wise but how it allocate at the time of Sales order

& If i can't manage item by batch wise so how it can solved by SP

[Former Member]

Hi........

When you Prepare Sales Order on Quantity Field if you press Ctrl+Tab the window for batch allocation will be poped up.

Here you can allocate/Committ the batches for this SO so that while delivery it will take out goods from committed batches. This way you can manage.

Second if you want to manage it by SP then you have to write a SP Transnotification where users will be restricted from delivering the material against second SO rather than First.....

Regards,

Rahul

[Former Member]

First solution is ok but i want to restrict by SP for non batch item so which code i have to written

plz rply me

[Former Member]

Hi,

You can try this one addon.when u select the item in delivery form use this query

(select a.CardCode,b.ItemCode,b.Quantity,d.Quantity from ORDR as a inner join RDR1 as b on a.DocEntry=b.DocEntry

inner join ODLN as c on c.CardCode=a.CardCode

inner join DLN1 as d on d.DocEntry=c.DocEntry and d.ItemCode=b.ItemCode

where a.CardCode='C0001' and b.ItemCode='aaa') and compare d.Quantity+matrix Quantity equal to sales order Quantity.

It will wok,

Regards,

Siva

[Former Member]

Hello Shiva

Where I update this query, i can't understand how to resolve this problem

[Former Member]

Hi,

Sales-A/R--Delivery form matrixItemcode---validate event write the code.

Regards,

siva