HELLO EXPERTS,
IN THE BELOW QUERY I HAVE SOME PROBLEM LIKE IN MY ITEM MASTER I HAVE SELECT TWO ITEM PROPERTY IN IT. BUT IN THIS QUERY ITS NOT SHOWING THE SECOND ITEM PROPERTY.
PLEASE RESOLVE THIS.
Select T0.[DocNum], T0.[DocDate], Case when T0....
HI EXPERTS,
PLEASE HELP ME WITH THE QUERY,
I NEED SALES AMOUNT FROM A/R AMOUNT WITH ITEM PROPERTY AND SALES EMPLOYEE
IT SHOULD HAVE DATE RANGE OPTION. PLEASE HELP WITH THIS
I NEED A QUERY TO GET THE SALES FIGURE FROM AND TO DATE OF SALESMAN PROPERTIES WITH ITEM PROPERTIES SEGMENT SHOULD BE APPEAR IN IT.
FOR REFERENCE SEE BELOW
ITEM PROPERTIES I HAVE 60 ITEM PROPERTIES
SALESMAN PROPERTIES OR CUSTOMER PROPERITES...
HELLO GUYS,
I NEED THE CUSTOMER REFERNCE NO. IN LIST OF SALES QUOTATION OR LIST OF SALES ORDER, WHEN IM FINDING THE SALES ORDER I NEED CUSTOMER REFERENCE NO. TO NOT GET CONFUSE.
PLEASE HELP ME WITH THAT.
DEAR EXPERTS,
I NEED A QUERY WHERE I CAN GET THE OUTPUT OF ITEM QUANITITY OF
PURCHASE ORDER MINUS GOODS RECEIPT PO DRAFT LIST = THE REMAINING QUANITITY.
PO - GRPO DRAFT LIST = REMAINING QUANITITY
HELLO JITIN CHAWALA,THANKS A LOT FOR YOU HELP THIS QUERY WORKS FINE FOR ME...BUT COULD YOU HELP TO ADD THE TOTAL SALE OF THE ITEM PROPERTY WITH DATE RANGE OPTION, OCRD CARDCODE, OCRD CARDNAME AND OCQG GROUPNAMETHANKSselect src.ItemCode,src.ItemName,s...
