Sage300 Shipment line number (3 replies)
Mary, to answer...
Order Line Number - Yes, this is the line number of the order to be shipped. In your example this would be lines (32, 96, 128).
Line Number - Yes, this is the Line Number of the shipment. If three lines were shipped I would expect the values to be 32, 64, 96 (since Sage increments by 32 on each line).
Does this answer your question correctly?
Hi,<br /><br />You have confirmed which field is which in the connector but I believe the writeback line number is wrong. <br /><br />The shipment created by Sage has 4 lines. The second line (64) has quantity shipped =0 but none-the-less uses<br />line number 64. So the item from line 96 of the order occurs on line number 96 of the shipment (in Sage300), <br />but IMan has returned it as Line 64.<br /><br />Shipment Line number 32 in Sage300 has returned 32 in Iman. <br />Shipment Line number 64 in Sage300 has returned nothing in Iman, understandably. <br />Shipment Line number 96 in Sage300 has returned 64 in Iman. <br />Shipment Line number 128in Sage300 has returned 96 in Iman. <br />- I think this means the writeback field linenum is incorrect. <br /><br />I was wanting to follow the Shipment connector with a dbupdate of each line, but therefore can’t use the line <br />number writeback value to read the shipment lines. <br /><br />Regards,<br />Mary
Hi,<br /><br />You have confirmed which field is which in the connector but I believe the writeback line number is wrong. <br /><br />The shipment created by Sage has 4 lines. The second line (64) has quantity shipped =0 but none-the-less uses<br />line number 64. So the item from line 96 of the order occurs on line number 96 of the shipment (in Sage300), <br />but IMan has returned it as Line 64.<br /><br />Shipment Line number 32 in Sage300 has returned 32 in Iman. <br />Shipment Line number 64 in Sage300 has returned nothing in Iman, understandably. <br />Shipment Line number 96 in Sage300 has returned 64 in Iman. <br />Shipment Line number 128in Sage300 has returned 96 in Iman. <br />- I think this means the writeback field linenum is incorrect. <br /><br />I was wanting to follow the Shipment connector with a dbupdate of each line, but therefore can’t use the line <br />number writeback value to read the shipment lines. <br /><br />Regards,<br />Mary
Sorry - I don't understand how to format information in replies correctly - I can't get it to start a new line without inserting a blank line. I'll try again.
Hi,
You have confirmed which field is which in the connector but I believe the writeback line number is wrong.
The shipment created by Sage has 4 lines. The second line (64) has quantity shipped =0 but none-the-less uses line number 64. So the item from line 96 of the order occurs on line number 96 of the shipment (in Sage300), but IMan has returned it as Line 64.
Shipment Line number 32 in Sage300 has returned 32 in Iman.
Shipment Line number 64 in Sage300 has returned nothing in Iman, understandably.
Shipment Line number 96 in Sage300 has returned 64 in Iman.
Shipment Line number 128in Sage300 has returned 96 in Iman.
- I think this means the writeback field linenum is incorrect.
I was wanting to follow the Shipment connector with a dbupdate of each line, but therefore can’t use the line number writeback value to read the shipment lines.
Regards, Mary
Hi
I am using the Shipment connector to ship and invoice an order.
- Sage300 version 2017, PU5
- IMan version: “Realisable IManWebUI.DLL 3.2.0.0, PU1, Config version 321, DB version 3.12”
For each line shipped and invoiced, I want to get the shipment line number to be used for subsequent processing. I am having trouble getting the writeback field.
In the shipment connector dropdown list of fields, the line number fields available are “Line Number”, “Order Line Number”, “Detail Number”:
- I assume “Order Line Number” is the LINENUM field on the order that is to be shipped.
- Is “Line Number” the writeback field for the Shipment line number OE0691.LINENUM? If not, where is OE0691.LINENUM in the Shipment connector?
- Is “Detail Number” a writeback field?
In IMan in the Map just before the shipment, I have OrderLineNum = 32, 96 and 128 (ie I am shipping lines 1, 3 and 4 of the order).
I have created ShipmentLineNumber field=”” and assigned it to “Line Number” on the shipment for the writeback.
On exit from the shipment connector OE0691.LINENUM =32,64,96.
In Accpac/SQL, the order number has LINENUM 32,64,96,128
In SQL the shipment created has 4 lines, LINENUM 32,64,96,128 corresponding to the order lines. Line number 64 in the shipment has qty shipped = 0, as expected. Lines 32,96 and 129 are the shipped lines.
I therefore expected that the writeback field OE0691.LINENUM would be 32,96,128, not 32,64,96
SQL order before shipment
Map transform
Output from Shipment connector
SQL Shipment after processingl
LINENUM
QTYORDERED
OrderLineNumber
Qty
ORDLINENUM
QTYSHIPPED
LINENUM
SHIUNIQ
SHIUNIQ
LINENUM
QTYORDERED
QTYSHIPPED
32
72
32
72
32
72
32
504001
504001
32
72
72
64
60
(not present not to be shipped)
504001
64
60
0
96
75
96
75
96
75
64
504001
504001
96
75
75
128
80
128
80
128
80
96
504001
504001
128
80
80
Is this a bug or am I wrong in my expectations, or am I doing something wrong?
Mary