Scenario for GRPO

Hi All, I am facing a problem here while handling a scenario in GRPO. Any suggestions would be greatly appreciated. Scenario : GRPO is copied from Purchase order. PO can have upto 200 line items. If the qty of any item is recieved less than

Hi All, I am facing a problem here while handling a scenario in GRPO. Any suggestions would be greatly appreciated. Scenario : GRPO is copied from Purchase order. PO can have upto 200 line items. If the qty of any item is recieved less than the qty in the po, then we have following udf's in the GRPO at row level to update the qty;"Accepted qty, Short/Excess qty, Rejected Qty". The problem arises when accepted qty is zero, coz if the qty field of GRPO is 10 and accepeted is zero, the system still counts 10 in stock as it is system behaviour. NOw we want the stock to be updated by the accepted qty. How can this be handled?? I thought of using dropship whse in case where item is not received, but the problem arises as this can still be copied to A/P Invoice. It solves the issue at inventory level but the accounting gets affected as the material is not recieved physically.How can we handle this scenario??? Thanks in advance, Joseph

The replay answer

Advertisement

Hi Thanga Raj,
Also to clear this scenario a bit more, I'll try to explain it again in brief; Billed Qty of Purchase Order would be the Qty in GRPO. Now the following cases arise;
a. The qty in the GRPO i.e. the receieved qty can be zero, meanin the item didnt arrive in the consignment.
b. The qty in GRPO can be recieved partially.
c. The clients wants to capture the details of "Accepted Qty, Short/Excess qty, Rejected Qty" on PLD and also the stock should be updated accordingly.
Any suggestions??
Thanks,
Joseph

Hi All, I am facing a problem here while handling a scenario in GRPO. Any suggestions would be greatly appreciated. Scenario : GRPO is copied from Purchase order. PO can have upto 200 line items. If the qty of any item is recieved less than[More]

Dear Experts, I am using SAP B1 8.8 and SQL Server 2008 in Server and SAP B1 and SQL Server 2005 in Test System. I have tested one scenario, In GRPO Document, Total amount should be calculated based on Unit price * 0.2812 * Net weight. In Test system[More]

Hello Experts !!! We created report for Goods Receipt Purchase Order through Crystal reports .And report is generated only when customised Add-On is started. Scenario : A grpo is created with 1 item. Now while viewing report , the same item appears[More]

Hi, G/L Account mentioned on line level does not get hit in Journal entry on GRPO and AP Invoice in SAP B1 9.0 PL - 11 I am creating an independent AP Invoice, there are two issues: 1. On line level G/L Account field is not open for selection 2. I ha[More]

Hello All How do we create multiple excise invoices from a single GRPO document. Thanks Santhosh.KHi As per the scenario you mentioned. You can't create multiple Excise Invoice against Single GRPO. And as per the law of excise also there is no way to[More]

The scenario happen like this: 1) Customer creating a PO with 3 items. 2) One of the item that my client created needed to change warehouse, so they make an amendment through clicking into the Item master data, and change the warehouse from WSE 01 to[More]

Hello, I am new to SAP Business One. I would like to know how to handle Transporation Company scenario below in SBO. QUESTION 1: A transportation company has 30 truck. The company receives orders from the customer and use the trucks to deliver the go[More]

SBO Version: 8.82 PL05 Forum, I have the following scenario: The Goods Return was not created from a Goods Receipt PO, however its value was €249.83 and this is the value shown on the open item list. The journal posting relating to this return detai[More]

My client has the following scenario: They sell stock to specific customers at cost(they sell it for the same price as what they get charged by their supplier). In SAP they create the following documents : On the Purchasing side: Purchase Order --- G[More]

Hi,, Can anyone Briefly expalin Import Scenario of material with what r all accounting keys will hitted. Regards Raghav.K HHi Raghav, Follow these steps 1. First you create Import PO and input all the Import duties in PO in ME21N. Here specify Import[More]

Hello, hope someone can help me with this issue. I have a query like this: select c_id ,dat_tim,glo,utr from ce_pro where c_id IN ('X1200', 'X1210') and glo not like 'null' or utr not like 'null' group by c_id, dat_tim,glo, utr having dat_tim between[More]

Hi, I'm having problems installing the commerce and personalization engine 3.1 on solaris 2.6, with weblogic 5.1 sp6. Everything seems to run fine until I try to create a group or user or any useful link on the exampleportal when I get: Tue Oct 03 16[More]

In Photoshop CS3 and earlier, weighted optimization of JPEGs could be achieved by using the "Use channel to modify quality setting" button just to the right of the Quality setting in the Save for Web and Devices dialog box. This option no longer[More]

I just got an update note by my software update option, but there is noting in the list. Is this an apple error?Hi AndreasvanHaren- Odd then. I have received that error when my internet connection was down. Have you repaired permissions lately? Perha[More]

Hi to all, Can any one help me out with the pdf documents on cproject , cfolders. Can any one even pls let me know what is the difference between cprojects and project system.From where should i start with to understand cprojects and cfolders[More]

I'm converting my 11g database for my 12.1.3 eBS environment from standard INTERPRETED to NATIVE, but I'm facing the following problem: The procedure (Metalink doc) runs fine, but initially he does not show the content of the plsql directory as a par[More]

Hi Experts, With regards to my requirment is there any time char avaliable in business content similar to 0CALMONTH Calendar Year/Month 0CALMONTH2 Calendar month is there any time char avaliable on Calendar week 0CALWEEK Calendar Year/We[More]