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
We Want to restrict posting of cenvet creadit taken material to specific storage loacation at time of GRN (MVT 105)HI IMaterial master view in mrp-2 view there is option to procurement for EP. here you specify the storage location so while posting th [More]
Hi All, I understand that uploading an email into a Drafts folder is not possible and has never been possible using Exchange ActiveSync. It has always been possible, however, to download emails from the Drafts folder and to sync the Drafts folder lik [More]
Hi, How can I import using DTW for Item remarks with multiple lines?Hi, Check the thread Importing Multiple Lines in a remarks (user_Text) of items using DTW? multiple line import through DTW (user_text for oItems) *Close the thread if issue solved. [More]
hello ni,                for my application as i want to set my main vi as a parent and sub vi as a child. i mean that if child vi opened and user move that vi, it should not bound above from parent vi, i mean that it should be shown as a with in the [More]
Im looking at getting a Yahama P85 digital piano and was wondering since it only has midi if I used a midi to usb I could use it for the learn how to play lessons in GarageBand.If the midi interface works with your computer, you can attach any midi i [More]
Dear All, I am importing bank statement using FF_5, (MT940) but the problem is payment advice is getting generated automatically, due to which i am unable to clear the customer. I dont understand how payment advice is getting generated? Please let me [More]
Does anyone know of problems downloading PDF files that have been uploaded with either Contribute 3 or Dreamweaver 8 to a server. I seem to be able to read these files in FireFox but not IE6 - don't know what I am doing wrong - HELP !!May be that the [More]
hi to all,i am very new to jsp ,my problem is i want client server interaction only through forms,suppose when the user perform some action on a button i am displaying the results according to client request,then user sees the url like this requested [More]
Hello! I am having a problem installing Oracle Database 9i onto my PC. I am a developer and just want it installed on my local machine. When trying to create and start the database using the Database Configuration Assistant I get an "ORA-03113: end-o [More]
Hi i am getting this error when i run my struts application. Do i need to install the xerces parcer and should my local have the ANT. If so how should i confingure ANT /JSP/Login.jsp(12,0) Attribute name invalid for tag form according to TLD org.apac [More]