Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Process for BPartner Products as Excel List #5908

Closed
metas-rc opened this issue Dec 11, 2019 · 1 comment
Closed

SQL Process for BPartner Products as Excel List #5908

metas-rc opened this issue Dec 11, 2019 · 1 comment

Comments

@metas-rc
Copy link
Member

@metas-rc metas-rc commented Dec 11, 2019

Is this a bug or feature request?

What is the current behavior?

Which are the steps to reproduce?

What is the expected or desired behavior?

ToDo:

  • Menu entry for SQL Process (Excel Download) for "Businesspartner Products"
    • Parm: Businesspartner (optional). If BP selected then only for Business Partner Products with that Businesspartner. If not selected then all Businesspartner product entries
  • Information in List:
    • Product Value (M_Product)
    • Product Name (M_Product)
    • Businesspartner Value (C_BPartner)
    • Businesspartner Name (C_BPartner)
    • All Fields from Product BPartner
metas-rc added a commit that referenced this issue Dec 11, 2019
@metas-rc

This comment has been minimized.

Copy link
Member Author

@metas-rc metas-rc commented Dec 11, 2019

Docu on local

  • Process in menu:

image

  • 2 optional parameters: M_Product_ID, C_Bpartner_ID. It's ok to have them both. I confirmed with Mark

image

  • leave them empty, start the process

  • => And excel pops up

image

image

image

image

  • OK: THe process works correctly if the parameters are set

  • Note: If by any chance there is a partner or product opened in the background, the process parameters will have that partner/product as default value. They can be changed any time
    e.g.

image

@metas-ts metas-ts changed the title SQL Process for BPartner Products as Excel List #3496 SQL Process for BPartner Products as Excel List Dec 16, 2019
@metas-ts metas-ts closed this Dec 16, 2019
metas-ts added a commit that referenced this issue Dec 16, 2019
  * [#5800](#5800) Add Payment Type, Shipper, Sales Partner to order candidate endpoint
  * [#5856](#5856) Add payment rest endpoint
  * [#5865](#5865) Picklist not working: "Type not supported: UNALLOCABLE"
  * [#5887](#5887) Additional Invoice Information
  * [#5888](#5888) Picklist ordered by locator name + dimensions
  * [#5895](#5895) Create Window for managing Manufactoring Workflow
  * [#5900](#5900) product proposals: Copy product price from other price list shall set IsInvalidPrice=N
  * [#5901](#5901) Automatically create C_ValidCombination(s) when a new C_ElementValue is created
  * [#5906](#5906) Add poreference field in the sql function to get data for sales order report
  * [#5908](#5908) SQL Process for BPartner Products as Excel List
  * [#5912](#5912) Read documentno field in the report for customer invoice with credit memo
  * [#5917](#5917) Product price not found if ASI was added to order line
  * [#1330](metasfresh/metasfresh-webui-api#1330) Reduce the number of websocket events we are sending to frontend
  * [#2469](metasfresh/metasfresh-webui-frontend#2469) Re-fetch tab's actions when the document status changes
  * [#2436](metasfresh/metasfresh-webui-frontend#2436) Follow-Up: Customer Proposal List navigation with arrow keys (qty arrows out)
  * [#5903](#5903) Fix country code from de_metas_endcustomer_fresh_reports.Docs_Sales_Invoice_Root
  * [#2471](metasfresh/metasfresh-webui-frontend#2471) Attributes cannot be set in orderline grid view
  * [#2477](metasfresh/metasfresh-webui-frontend#2477) Location name seems to get lost when editing the location
  * [#2488](metasfresh/metasfresh-webui-frontend#2488) Add new button doesn't work anymore
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.