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.

Sign up for GitHub

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

Jump to bottom

Import Subscriptions / Flatrate Terms #2224

Closed
metasnw opened this issue Aug 23, 2017 · 9 comments
Closed

Import Subscriptions / Flatrate Terms #2224

metasnw opened this issue Aug 23, 2017 · 9 comments
Assignees
@cristinamghita
Labels
branch:release bug_please_use_type:bug_instead priority:high type:enhancement
Milestone
2017-36

Comments

@metasnw
Copy link
Member

metasnw commented Aug 23, 2017 •
edited
Loading

Is this a bug or feature request?

feature request

What is the current behavior?

it needs know how to to import subscriptions

Which are the steps to reproduce?

NA

What is the expected or desired behavior?

find a procedure / tool / best practice to import subscriptions

example:

Value firstname lastname condition price startdate enddate
12345 Jack Taylor 1 year auto 100 02.06.2013 NULL
@metas-mk metas-mk added this to the 2017-36 milestone Sep 5, 2017
@teosarca teosarca self-assigned this Sep 5, 2017
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
minor
b147319 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
OrderCreateNewFromProposal: fix class cast issues
125e7fc 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
minor
f793fec 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
X_ImportTableTemplate
b7bc408 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
ImpFormat: improve error message reporting
0d20d3a 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
fix launcher
81152ab 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
generate de.metas.contracts models
b7afb12 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
I_Flatrate_Term
1c8c3fa 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
I_Flatrate_Term: import format
54d2a3d 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
I_Flatrate_Term window & menu item
4e936f9 
#2224
@teosarca
Copy link
Member

teosarca commented Sep 5, 2017 •
edited
Loading

Test file i've used for first iteration:

G0001,Lagerkonferenz (Karotten),2017-01-02,2017-07-09,Topinambour,3.45
G0002,Lagerkonferenz (Karotten),2017-01-02,2017-07-09,Topinambour,3.45
1233,flatrate_conditions3,2017-01-02,2017-07-09,Topinambour,3.45
1234,flatrate_conditions4,2017-01-02,2017-07-09,Topinambour,3.45
1235,flatrate_conditions5,2017-01-02,2017-07-09,NoProduct,3.45

Edits:

  • added Product (Value or Name) and Price

@metasnw
Copy link
Member Author

metasnw commented Sep 5, 2017

@teosarca is the first column the product or the partner?

@metasnw metasnw mentioned this issue Sep 5, 2017
Closed
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
fix X_ImportTableTemplate.I_IsImported
d5759fb 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
fix I_FlatrateTerm.I_IsImported
d490227 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
FlatrateTermImportProcess prototype
efed8c9 
#2224
@teosarca
Copy link
Member

teosarca commented Sep 5, 2017

@teosarca is the first column the product or the partner?

partner

teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
add I_Flatrate_Term product and price fields
bf3e5db 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
import flatrate product
e0d6c3f 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
import flatrate term price
9051ff2 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
C_Flatrate_Term_Import process
ed2fab9 
#2224
teosarca added a commit that referenced this issue Sep 5, 2017
@teosarca
FlatrateTermImportProcess: record not marked as imported bugfix
6bbf341 
#2224
metas-ts pushed a commit that referenced this issue Sep 6, 2017
@teosarca @metas-ts
minor
627ef82 
#2224
(cherry picked from commit b147319)
metas-ts pushed a commit that referenced this issue Sep 6, 2017
@teosarca @metas-ts
OrderCreateNewFromProposal: fix class cast issues
7e2374e 
#2224
(cherry picked from commit 125e7fc)
@metasnw
Copy link
Member Author

metasnw commented Sep 6, 2017 •
edited
Loading

I tested and got this result:

Error Processing Document document: Pauschale - Vertragsperiode 1000000 Belegverarbeitung: CO Cause: Erforderliche Felder ausfüllen: Preissystem, Lieferadresse, Produkt (FillMandatoryException),

test data:
G0001,abo,2017-01-01,2017-03-03,P002737,3.45

condition:
image

transition:
image

teosarca added a commit that referenced this issue Sep 6, 2017
@teosarca
FlatrateTermImportProcess: hotfix - product was not set in flatrate term
04c7b0c 
#2224
teosarca added a commit that referenced this issue Sep 6, 2017
@teosarca
flatrate term: import drop ship bpartner
393a8b9 
#2224 (comment)
@metasnw
Copy link
Member Author

metasnw commented Sep 7, 2017

I tested again and found this problem:
Error Processing Document document: Pauschale - Vertragsperiode 1000001 Belegverarbeitung: CO Cause: Zum angegebenen Preissystem "Divers" konnte keine Verkaufspreisliste gefunden werden. (PriceListNotFoundException),

although this "Testpreisliste Kunden" is set in flatrate condition.

image

@teosarca
Copy link
Member

teosarca commented Sep 7, 2017

that's a config issue, for sure... will debug it a bit later

@metasnw
Copy link
Member Author

metasnw commented Sep 7, 2017

I put a price system here:
image

@teosarca teosarca mentioned this issue Sep 8, 2017
Closed
@metasnw
Copy link
Member Author

metasnw commented Sep 8, 2017

after unticking "AB mit neuer Vertragslaufzeit" the flatrate term was imported

@metasnw metasnw mentioned this issue Sep 8, 2017
Closed
@teosarca
Copy link
Member

teosarca commented Sep 8, 2017

@metasnw pls close the task is everything was delivered.

@metasnw metasnw mentioned this issue Sep 9, 2017
Closed
@metasnw metasnw closed this as completed Sep 9, 2017
metas-ts added a commit that referenced this issue Sep 9, 2017
@metas-ts
Update ReleaseNotes.md
98b5253 
[#2398](#2398) Reverse
Correct of Disposal takes too long
[#2303](#2303) Auto
Product No when new
[#2224](#2224) Import
Subscriptions / Flatrate Terms
[#578](metasfresh/metasfresh-webui-api-legacy#578)
storage error on disposal
[#573](metasfresh/metasfresh-webui-api-legacy#573)
MoveToDirectWarehouse shall support multiple HUs
[#2342](#2342) Make
Material Disposal Lines and their Movements respect all the details from
the HUs
[#2389](#2389) edi
problem for customer returns
[#577](metasfresh/metasfresh-webui-api-legacy#577)
API for Edit Fields in Main Grid View
[#1178](metasfresh/metasfresh-webui-frontend-legacy#1178)
[ctrl]+u sometimes opens chrome sourceview instead of trigger main
quickaction
[#1179](metasfresh/metasfresh-webui-frontend-legacy#1179)
[ctrl]+enter does not save changes before
[#1164](metasfresh/metasfresh-webui-frontend-legacy#1164)
frontend: document cloning
[#563](metasfresh/metasfresh-webui-api-legacy#563)
Handling Unit Editor - remove hardcoded filter for active HUs
[#2343](#2343) Add code
coverage metrics to our builds
[#2358](#2358) translate
process quotation to sales order to en_US
[#567](metasfresh/metasfresh-webui-api-legacy#567)
Shipped HUs are not displayed correctly
[#2305](#2305) Create GL
Journal No. automatically when new
[#575](metasfresh/metasfresh-webui-api-legacy#575) HU
does not disappear after Correction Quick-action.
[#1161](metasfresh/metasfresh-webui-frontend-legacy#1161)
tab tries to update a readonly field
[#2367](#2367) error on
creating receipt
[#2349](#2349) Fix
AD_Column of C_BPartner.AD_OrgBP_ID
[#2354](#2354) LU has
HU_Status Active after picking
[#1172](metasfresh/metasfresh-webui-frontend-legacy#1172)
filtering is not working in picking
[#1159](metasfresh/metasfresh-webui-frontend-legacy#1159)
batch entry: scrollbar not moving when using keyboard
[#2303](#2302) Order
validation rule for packing instruction needs to look at DatePromised
[#572](metasfresh/metasfresh-webui-api-legacy#572)
qty doubled on vendor/customer return and destroyed HUs
[#532](metasfresh/metasfresh-webui-api-legacy#532)
Unable to see list of document's attachments
[#1165](metasfresh/metasfresh-webui-frontend-legacy#1165)
frontend cache for dropdown value not invalidated on lookupValuesStale
is true
[#2141](#2141) Year-End
P&L Process w/ multiple Organisations error

me-45
@metasnw metasnw mentioned this issue Sep 13, 2017
Closed
metas-ts added a commit that referenced this issue Apr 1, 2019
@metas-ts
update ReleaseNotes.md
0b6f287 
  * [#4895](#4895) Support Automatic Numbering on Purchase Requisition
  * [#4951](#4951) Phonecall Planning and Execution
  * [#5040](#5040) Accounting for Payment Allocation and Vendor Credit Memo wrong
  * [#5072](#5072) Support forum-datenaustausch.ch XML invoice cancelation-response
  * [#5081](#5081) Product prices window: don't sort it because on huge amount of data this is a performance issue
  * [#5089](#5089) XML import/export for Kanton
  * [#1178](metasfresh/metasfresh-webui-api-legacy#1178) view: kick out a row if is no longer matching the filters
  * [#2221](metasfresh/metasfresh-webui-frontend-legacy#2221) Display time fields with no seconds in gridview
  * [#2224](metasfresh/metasfresh-webui-frontend-legacy#2224) View: after calling getByIds, frontend shall remove the rows which are no longer in the result
  * [#1](metasfresh/metasfresh-edi-legacy#1) Modernize and update EDI ESB camel
  * [#5079](#5079) Error while posting purchase invoices because of charge even though charge is not used
  * [#5084](#5084) Error while posting cost collector
  * [#5086](#5086) Error logging in to webui when there is no default warehouse
  * [#5092](#5092) Fix wrong avg PO cost on material receipt and match invoice in case we have a different price UOM
  * [#5093](#5053) Log related NPE on metasfresh startup
  * [#1180](metasfresh/metasfresh-webui-api-legacy#1180) Webui server shall start even if something in picking terminal code fails
  * [#2230](metasfresh/metasfresh-webui-frontend-legacy#2230) Refresh filtered list
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@cristinamghita cristinamghita

Labels
branch:release bug_please_use_type:bug_instead priority:high type:enhancement
Projects
None yet
Milestone
2017-36
Development

No branches or pull requests
5 participants
@teosarca @metas-ts @metas-mk @cristinamghita @metasnw