Wouldn't you want to use the SO_PackageTrackingbyItem_bus instead?

Yes, that is what we use to process packaging.

We work with that object outside of the invoice edit context. Sage logic already took part by then and we cannot alter packaging at that point, like we used to.

I am trying to adjust package quantities in UI - it is not saving the changes, even though the totals match those in the invoice.

Looks like package editing is disabled completely in the business logic?

We probably could resolve this by creating a new package before committing invoice change.

We could also work with invoice quantities and expect package quantities to be adjusted.

I see (a bug?) though, with editing shipment quantities when there are at least two packages. An edit operation cares only about the quantities in the last package, not accounting for previously shipped.

Guys, I hope somebody advises what to do next. I would say there is a bug in MAS packaging logic, unless this is a kind of simplification but this one hurts.

Thanks

I believe that through UI adjusting package information is disabled through Invoice Data Entry but is Available through shipping data entry UI

I believe that through UI adjusting package information is disabled through Invoice Data Entry but is Available through shipping data entry UI

That is correct, I was talking too about the shipping data entry dialog.

When starship writes the invoice information into Sage do you write the quantity shipped to the SO_InvoiceDetail and then write the data into the package table?

No, we write to SO_Shipping and its oLines collection.

postnik706,

We corrected a discrepancy between the UI and the BUS objects in the PU.  Shipping Data Entry automatically puts all items in package 1 without the user doing anything.  However, when the shipping invoice was created using BOI or VI, no package record was created.

Let's see if I understand your process correctly. You use the SO_Shipping_bus object to write the invoice and lines.  After the invoice is written, you use SO_PackingTackingByItem_bus to put items into packages.  Then you update NumberOfPackages in SO_InvoiceHeader, I suppose.

I don't know if this idea will work for you.  When you add lines, put eveything in a package number that you normally won't use (eg. 9999).  After the invoice is written, you check if there are items in package 9999.  Then you move them to the correct package.

Or if you know what package an item is going into while you update the lines, you can set the PackageNo$ property.

Note the 2 lines that set PackageNo$ in the example below.

oHeader = NEW("SO_Shipping_bus",%sys_ss)

oHeader'Lines'PackageNo$ = "" ! so that CopyLinesFromSalesOrder won't put them in package 1

SalesOrderNo$ = "0000174"

r = oHeader'GetNextInvoiceNo(nextInvNo$)

r = oHeader'SetKeyValue("InvoiceNo$",nextInvNo$)

r = oHeader'SetKey()

r = oHeader'SetValue("ShipperID$", "1")

r = oHeader'SetValue("SalesOrderNo$", SalesOrderNo$)

r = oHeader'Lines'CopyLinesFromSalesOrder(SalesOrderNo$)

r = oHeader'Lines'MoveFirst()

WHILE NOT(oHeader'Lines'EOF)

r = oHeader'Lines'GetValue("ItemCode$", item$); msgbox "shipping " +item$

r = oHeader'Lines'GetValue("QuantityOrdered", qty)

r = oHeader'Lines'SetValue("QuantityShipped", qty)

oHeader'Lines'PackageNo$ = "9999" ! put everything in package "9999"

r = oHeader'Lines'Write()

if not(r) then msgbox "Write Line Error: "+ oHeader'Lines'LastErrorMsg$

r = oHeader'Lines'MoveNext()

WEND

r = oHeader'Write()

if not(r) then msgbox "Write Header Error: " + oHeader'LastErrorMsg$ else msgbox "Done"

drop object oHeader

Using VBScript the property assignment looks like this:

r = oHeader.oLines.sPackageNo = "9999"

Reading this property gives "0001" so I must be on the right track.

Writing into the property returns error message: "Error setting package number: "WF&A" is not numeric."

"WF&A" is the product line Id of product 1001-HON-H252 I used in the order; not sure how these are related. Will do my best to overcome this but would appreciate any advice.

Thanks,

Alex

Cannot resolve this - please advise what the next step would be.

Thank you Natasha.

Alex

I think you just need to do oHeader.oLines.sPackageNo = "9999" (without the r =). It isn't a method call. It doesn't return a value.

Got it, my bad - thank you so much.

Just to be sure I am getting it correctly - (1) we may NOT edit package quantities directly, using SO_PackageTrackingByItem_BUS / SetValue as we did before, should use shipping data entries / lines quantities. (2) Shipment's oHeader.oLines.sPackageNo is a selector pointing out to the 'current' package. (3) A shipment has to be written after sPackageNo is set up to a desired value, before we can further process the next package.

Thanks,

Alex

Alex,

1)  You can still use SO_PackageTrackingByItem_Bus to edit the packages after the invoice is written, if sPackageNo doesn't give you the control you need.

2) Yes.  Default is "0001".

3) sPackageNo should be set before each invoice line is written.  Each line can have different sPackageNo. You don't have to finish packing package 1 before you start package 2.  You  should be able to change sPackageNo from 1 to 2 and back to 1.

It looks like each incremental qty can be assigned to a different package.  For example, if the qty shipped on a line is 1 and it is changed to 2, the new qty (1) can be put in a different package (whatever sPackageNo is  when the line is written).  (I haven't tried this myself.  I am just looking at the code).

Re 1) - no, this does not work. That is why we have this problem in the first place.

I double checked with my script, but it could be easily replicated in Sage UI - if you try to edit existing package quantities.