Back to connectors… Back to Sage 300...

Sage300 Shipment line number (3 replies)

Mary O'Connor
6 months ago
Mary O'Connor 6 months ago

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

Support
6 months ago
Support 6 months ago

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?

Mary O'Connor
3 months ago
Mary O'Connor 3 months ago
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
Mary O'Connor
3 months ago
Mary O'Connor 3 months ago

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

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close