Understanding field QSOALOC in table ICIQTY

[PatrickvO]

We run SBT Pro Series 3.0 and I would like to understand how field QSOALOC in table ICIQTY is populated by the system.

It seems that data entered in the SO shipments form is placed in this field and then when exiting this shipments form and selecting process (to create AR invoices) the numbers are cleared (as well the LSOALOC in the ICILOC table).

However, we have a bunch of items that keep some value in the QSOALOC field and I don't know how to tie it back to data the SOTRAN table.

Any input is welcome.

Patrick

 

[fitedgar]

qsoaloc keeps track of all items allocated in sales order.
For Example if you entered a SO for item XXX in location whs1 for qty ordered 5, you will see in iciqtyxx location loctid = whs1 and qsoaloc = 5 ( assuming no other so for item XXX). Same goes for ICILOCxx, lsoaloc = 5.
Once this SO is completly or partially shipped, these fields will adjust accordingly.

Hope this helps.
Integrate Bar Code Systems, Inc.
Edgar Conte

 

[PatrickvO]

Hi Edgar,

Thanks for your post, but I don't seem to have the same reaction.

Building on your example, when I enter a SO for item xxx in location whs1 for qty ordered 5, only the LSOALOC field in the ICILOC table will reflect this qty. The QSOALOC field remains 0. Only when entering shipments against the SO, do I see the qty of 5 in the QSOALOC field on the ICIQTY table. Once I process the shipment (thus create an invoice), then the LSOALOC and QSOALOC fields are adjusted accordingly. Did this example last Friday against a typical location on one of our SBT installs.

Not sure if this different behavior is due to customization of our code (some was done in years past) or if it could be related to system/item settings.

We have about 20 locations and I'm sorry to say that I can not see how your explanation applies to the numbers in the QSOALOC field of the various locations.

Patrick

 

[fitedgar]

Qsoaloc applies only to serialized items. If you are not using serialized items, use the lsoaloc in icilocxx for qty of allocated items.

IBS
EMC