| aptrdennis |
| Newbie |
|
| Canada |
|
|
| None Specified |
|
| Wednesday, June 18, 2008 |
| Thursday, July 25, 2013 4:03:41 PM |
8
[0.04% of all post / 0.00 posts per day] |
|
Thank you, I do have a couple of questions. Please forgive my ignorance. Also, I am using Mapforce 2010 Enterprise Edition.
1. Where do I connect the output node Groups?
2. Where do I connect the output node key?
Thanks
|
I am processing an inbound EDI 850 document and the outbound, or target, is a CSV File structured as such:
SH....(Sales Order 2 Header)
SD....(Sales Order 1, Line 1)
SD....(Sales Order 1, Line 2)
SH....(Sales Order 2 Header)
SD....(Sales Order 2, Line 1)
What I would like to do is add a Sales Order Line for a Drop Ship Fee if the incoming PO meets a certain criteria. Right now, if the BEG02 segment = DS then I want to add a line called Drop Ship Fee to the corresponding Sales Order.
Any help is greatly appreciated.
|
I have a situation where I need to split a single EDI 850 (Purchase Order) into 1 or more Sales Orders based on the items listed on the PO.
The mapping uses a single ANSI X.12 4010 850 EDI PO for the input, and a single CSV for the output.
The CSV file is structured as follows
SH....(Sales Order Header for order 1)
SD....(Sales Order Line for order 1)
SD....(Sales Order Line for order 1)
SH....(Sales Order Header for order 2)
and so on
What I would like to do is, split the incoming PO into multiple outbound Sales Orders based on the Item Keys.
For example, all Items that Start with A* should be grouped together in one Sales Order and all Items that Start with B* should be grouped toghether in a second Sales Order.
This is because we create a separate Sales Order for each warehouse location and all A* items are in one warehouse, and all B* items are in another warehouse.
The incoming PO's may have 5 lines for example, in a random order, so
Line 1 A*
Line 2 A*
Line 3 B*
Line 4 A*
Line 5 B*
and so on...
I would like to group all the all A*'s from the single PO into one Sales Order, and all the B* items into another Sales Order.
Any help to point me in the right direction would be greatly appreciated.
|
I would like to compare 2 values and use the greater of the two values in my map.
For example, I have an inbound EDI 850 with a Requested Ship Date Field.
I would like to compare this field vs our standard lead time, let's five days from date of order.
I would like to map in my outgoing 855 the greater of the incoming Requested Ship Date or Today + Five Days.
My question is how can I compare these two values and use the greater of them?
any help or insight is greatly appreciated.
|
I found a great Case Study for doing control numbers using a flat file
https://www.altova.com/documents/nff_case_study.pdf
go to page 8 of 12 in the pdf for details.
I used the same premise to do so using a SQL DB Table. I created a master table in SQL for holding my control numbers. I then add this as an additional data source twice. (I will be posting back the incremented number into the second instance)
I used a stored procedure to get the last number already issued from this master table, then add 1 to it using auto increment and post the result as the ISA and GS control numbers in my map, as well as posting back to the SQL table using the second SQL connection in my map.
The only "gotcha" that I have experienced so far, is that when you compile the map using C#, edit the console file before compiling in Visual Studio to ensure that the Mapping instructions for the EDI file appear before the Auto Increment / Post to SQL in the Second SQL Connection otherwise your numbering system will be off by one everytime you run the map. (the EDI file will have number 0002 and the master sql table will show the last number used as 0001)
I tried to post a screen shot of the SQL connection portion on my map, but was unable to.
|
I have found out some more on this:
If you uncheck "Auto-complete missing fields" on the X12 v4010 Component Settings, then the FI12 field populates properly when the FI10 field is populated.
However, if you leave this checked, populating the FI10 field causes Mapforce to ignore any value mapped to the FI12 field in the ISA Segment.
This behavior only started to occur when we updated to 2009 SP1.
this did not happen with 2009.
Any help would be appreciated as I do not want to have to change every map to include the data that is 'auto completed'
|
Just upgraded to Mapforce 2009 SP1 Enterprise Edition.
My maps, which worked in 2009 pre SP1 are now failing based on the FI12 field, or ISA Control Number. My maps are x12 version 4010.
I have a table in MS SQL that has a list of used ISA Control Numbers. I have a query that I pull into my maps that gives me the last used Control Number. I add 1 to that number.
My map then links the value to the FI12 field in the ISA Segment and the FI12 field in the IEA Segment.
Prior to the upgrade the same value would populate both fields.
After the upgrade the FI12 field in the ISA Segment is always 000000000.
I have even tried creating a Constant and linking the constant to the FI12 field in the ISA Segment and it still only shows 000000000.
Help! I do not know what to do to get this value populated with a valid control number.
Thanks
|
Scenario
Source ANSI X12 v4010 850 (Purchase Order)
Target ANSI X12 v4010 997 (Functional Acknowledgement)
Problem: In the target document (997) I need to populate, in the IEA Segment, the Number of Included Functional Groups contained within the Target (997)
I can not seem to use the count function to do so as it creates a circular reference as both inputs, "In Context" and "Nodes/rows" come from the target, and the output, "Result", goes to the target.
How can I count the number of Functional Groups, (as well as Transaction Sets and Segments) in the Target in order to populate these fields in that same target?
Thanks
|
|
