Sitemap

Amicuk Programming Answers

Scenario for GRPO

-0001-11-30   Views:0

Advertisement

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

Go to See the other 16 answers

Scenario for GRPO

Category:DefaultRelease time:-0001-11-30Views:130

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]

Error while opening GRPO document

Category:DefaultRelease time:2015-10-11Views:130

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]

Report Printing Incorrectly

Category:DefaultRelease time:-0001-11-30Views:130

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]

Unbalanced transaction of LC in JE

Category:DefaultRelease time:-0001-11-30Views:130

Scenario:  A. GRPO                 1. Document:  Total Before Discount 110713.48                                        Tax:      18821.27                                        Total Payment Due    129534.75                 2. JE:    debit-inventory[More]

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

Category:DefaultRelease time:2015-10-11Views:130

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]

Multiple Excise Invoice for Single GRPO

Category:DefaultRelease time:2015-10-11Views:130

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]

GL Account Missing when Posting Up GRPO

Category:DefaultRelease time:2015-10-11Views:130

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]

How to handle this kind of scenario in SBO

Category:DefaultRelease time:2015-10-11Views:130

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]

GRPO not posting to Purchase Variance Account

Category:DefaultRelease time:-0001-11-30Views:130

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]

Create AR Invoice based on GRPO

Category:DefaultRelease time:-0001-11-30Views:130

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

Category:DefaultRelease time:-0001-11-30Views:130

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]

Hot
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 want to delete KwiClick from my computer. I cannot find any way to do it.http://www.uninstallhelp.com/Uninstall-KwiClick-182741.htmlRead other 3 answers [More]
Hi All, This is my code: SELECT    EKKO~EBELN             EKKO~LIFNR             EKKO~BUKRS             EKKO~EKORG             EKPO~EBELP             EKPO~TXZ01             EKPO~MATNR             EKPO~MENGE             EKPO~MEINS             EKPO~UNT [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 , While transferring project stock to sales order stock in MB1B system with movment type 413 Q gives the following error. Valuated project stock not allowed with customer stock. Message no. KI346 Diagnosis The entered WBS element E-00000108 manage [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]