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
Suddenly, a couple of days ago, Mail started refusing to send mail in my .Mac account. I changed nothing in terms of settings and the way I do stuff. Receiving has been unaffected. I'm at a loss to think what it could be... any ideas? Thanks.Sure you [More]
I have a JSF project where I'm using a table and I would like to populate that table with some custom information without using a database. I'm trying to write my own data provider. I was wondering if anyone knows how to populate a jsf table using an [More]
Hello, I try to install the Grid Infrastructure on a Windows 2008 x64 Server. Everything works fine (the SCAN configuration and Verify) but at the end of the installation process I get the following error message: [INS-20802]: Grid Infrastructure Con [More]
Dear All, I'm having issue on individual purchase order, Using TAB item category. Please understand my issue: Without purchase order +MIGO + MIRO + I am creating outbound delivery number but PGI, but is not allowing. Here my question: without creatin [More]
Im having sync(error 13019) problems with my nano. I've reinstalled itunes but it hasnt fixed it. People say to check "my devices" in itunes but I cant find it. Any ideas?I know about the feeds - The shownotes appear everywhere else - also in Fe [More]
I'm using Enterprise manager to export a table. It wnat a node preferred credential! I have tried all the user ids(sys, system,databse id)and nothing works. What is it looking for and where do I find it. I am desperate.....I've never used enterprise [More]
hi I am unable to find the document for JAVA homogenous system copy for Oracle for NW04 & NW04s kindly find me the link thx regards ShoebHi Here you go...- [JAVA Sytem Copy for ORACLE |https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/libra [More]
My Adobe Acrobat 9 Pro recently stopped working.  After some Internet searching, I found out that I needed to apply the licensing service update.  I was successful in downloading the .zip folder, but when I ran the .exe file, it told me that it could [More]
Opened a presentation in keynote and have obviously tapped something as have locked the slide navigator bar on the left side somehow! It's currently blacked out and I can't access the slides or move it to access the key buttons underneath it so am st [More]
Hello guys, I have a nokia E72 that was working well for almost 2 years 2 days ago after recharging my phone when the battery was empty, I turned my phone on and it took almost 5-8 hours so that my phone starts properly. I tried to reinstall the soft [More]