I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using the valuation change utility. Now the fun begins, i'm trying to get the parts back into SAGE (v2021) without having to manually type the serial numbers for each of the 500+ individual serial parts.
I've written a VI job that seems to work if there is only one line item but fails if there is more than one Tier Distribution line. I've scoured the database and spent over an hour on the phone with SAGE directly who apparently have no working examples of how to import serialized adjustment entries into Transaction Entry screen. I'm not trying to automate the entire process just the data entry portion of the Transaction Entry screen.
Any assistance or working examples would be greatly appreciated. I think i'm close... but that only works in nuclear war ...certainly not VI imports. :-)
Attached is a PDF of all screenshots showing my VI jobs and data file. The .txt file is really a zip file. The Zip file is the macro enabled excel workbook described in the PDF as a work around to brute force values into the transaction entry adjustment screen until a viable solution can be found. I've included this in hopes it might be beneficial to someone else struggling with this as well. The password to the zip file "workaround" all lowercase without quotes
2086.VI_Import_Serial_Items_NotWorking.pdf
PK @XVq�I{�P �] sendkeys(Example).xlsm��9~U2�r�b��+I��P'�$�%UN,H�����_07&-�:�����c�?��L��FH�HK��8��e���lE�x�$n>����7,`$A��>]~���?%������w����;��H���F�ޢ�U�h���}z�~)<.U�G W!��g�+�\��O+c5���F��a�01l�^5��5<�R2��v2�I@�PTG�Īt����4D��U��$��G�#2�n�Z�8��w��=��H �1ֈd�]�nh��Gl�'mvm"�"j��E��ρ����~�o��`��΅�Y"���@��6���a<E�Q�8 S�z�I=J�G�ᯫ�B�}����86��kn*,�NH^̳��c\+��!�H�W��U@}?(��!"���/rv���(K3�>�� �tf�H"5�_�ܿ��I���G��ÆIo�*:FF�H��1n��m�/j�ƣc k�F�f���z��+�QS� /~T$�e|�_IM�|�D0�֩�=ӈ/���T��ͭw�[;��b8b2�U��>��7���"�P�m�� ���0���=���ƻ�]�(�F~L0��.�-�ej%B�t��C*�aE�8^ �Uڗf��$�b� W����������'A����][fF(��+��k}�x��V�D�������Q��N�X�S�;!]��^���56\�G`� �'���D8��!=��{Z��O�މе��'�?� ��d��f�� S����ʮ_�7'��Eg�d�~WE�N�Ÿ$=��=U�_��%5?m�P[�����y�LRÙ&��_ Ul�rՐ�6#�����Q��{[<�g�#�v p��D�6D�E``>�1�����$e�\���??�C!�9j���˴��T� |�F!�q ��ӱ�����=��.j�#A����\-G�w�kP@uJ��:Ā��ߪ�ءR��W�)��'+����AX�7���{��t3��||*�V�w*Na�e^���H/q2J��DC��"�2�T�+��f��9N�H�y.Uiwt~�=��s?� �HQ�!]>D�NC Vҷ7SՕM$k�U��{�LdCzn�����囄 ��-8� �~�|���RDe{"