Temp Projects

Rijas P wrote:

Dear Suhail,

Kindly provide all our customers & vendors details with their Receivable or Payable account respectively.

Rijas P wrote:

Reminder..

PFAs

Query used for reference

euro=# copy (select cbp.value Customercode,bpgroup.name BPGroup,cbp.name CustomerName,cbp.name2 Customername2,elementvalue.name AccountReceivable,elementvalue2.name Prepayment from c_bpartner cbp join c_bp_group bpgroup on cbp.c_bp_group_id=bpgroup.c_bp_group_id join c_bp_customer_acct customeracct on cbp.c_bpartner_id=customeracct.c_bpartner_id join c_validcombination cvc on customeracct.c_receivable_acct=cvc.c_validcombination_id join c_validcombination cvc1 on customeracct.c_prepayment_acct=cvc1.c_validcombination_id join c_elementvalue elementvalue on cvc.account_id = elementvalue.c_elementvalue_id join c_elementvalue elementvalue2 on cvc1.account_id=elementvalue2.c_elementvalue_id where cbp.ad_client_id=1000000 and iscustomer='Y' order by bpgroup.name) to '/tmp/cust_acc.csv' with delimiter ',' csv header;
COPY 1689

euro=# copy (select cbp.value vendorcode,bpgroup.name BPGroup,cbp.name vendorName,cbp.name2 vendorname2,elementvalue.name AccountPayable,elementvalue2.name Prepayment from c_bpartner cbp join c_bp_group bpgroup on cbp.c_bp_group_id=bpgroup.c_bp_group_id join c_bp_vendor_acct vendoracct on cbp.c_bpartner_id=vendoracct.c_bpartner_id join c_validcombination cvc on vendoracct.v_liability_acct=cvc.c_validcombination_id join c_validcombination cvc1 on vendoracct.v_prepayment_acct=cvc1.c_validcombination_id join c_elementvalue elementvalue on cvc.account_id = elementvalue.c_elementvalue_id join c_elementvalue elementvalue2 on cvc1.account_id=elementvalue2.c_elementvalue_id where cbp.ad_client_id=1000000 and isvendor='Y' order by bpgroup.name) to '/tmp/vend_acct.csv' with delimiter ',' csv header;
COPY 167

Savad, Please add option to add these 2 accounts details in Vendor and Customer export csv file

https://bugzilla.posibolt.com/show_bug.cgi?id=9240

Thank you for the report and hope these details will be added to the Customer/Vendor export details shortly.