Dear Experts,
I need a production order wise amount variance report with below mentioned format. please help us to execute the query without duplicate lines.
1. Duplicate not allowed
2. Multiple GI & GR done for single PO
3. My query attached...
Dear Experts,
I have a report for serial / batch created with GRPO and IT to particular warehouse and available stock.
Here i shared my query, please help us to get the exact details.
GRPO date : 12/02/22
IT date : 15/02/22
IT to rejection ...
Dear Experts,
It is possible to integrate SAP B1 R3 to B1?
Currently we are using SAP Business One 9.3 (9.30.150) PL: 05 and need to integrate advance module (improve a single module with existing version) for SCM module.
Please share the refe...
Hi Experts !!!!
I request you to please share the stock analysis report as per the below screenshot.
parameter is ToDate and warehouse 'WH05'
Parameter date 31122021
current stock available in Warehouse 5 Nos. based on parameter stock qty an...
Thanks for your reply.I'm tried as per the below SP.If @object_type = '17' and @transaction_type in ('A', 'U')BEGINIF EXISTS (SELECT distinCt numatcard FROM ORDR WHERE (PATINDEX('%[~,@,#,$,%,&,*,(,),:,|,/]%',numatcard COLLATE Latin1_General_CS_AS)>0...
