Sage 100

Running into an issue with writing a PO Receipt of Invoice thru the Business Object Interface.  The issue comes when I attempt to update or write new lines, everything else works great.  It appears that I am not getting the lines object loaded correctly.  when I check the retVal for the oLines object I am getting "0" returned and I am always getting an error whenever I attempt to perform a 'nGetValue' as I read thru the lines.
 
Below is my code:

'---------- Login to Sage 100 ----------

               

'---------- Set Initial Batch Variables --------

                                                               

'---------- Read thru the records ----------

                               

 '---------- Write the PO Receipt of Invoice Header record -------------

                                                oPOInvoiceEntry.nWrite() '--- I have removed this and added to see if saving before reading the lines made a difference, it doesn't appear to

                           '--------- Read and update lines ----------------------

                                               

objFile.Close

oSS.nCleanUp()

retVal = oSS.DropObject()

------------------------------
Dan Isaacson
Bennett Porter
------------------------------

After you have set the purchase order number and invoice number, try using retVal = oPOInvoiceEntry.nCopyPurchaseOrderLines(nComplete)
The parameter is a Boolean to indicate whether you want to receive/invoice complete.


------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

David,

Thank your for the information.  However, it turns out part of my issues appear to be related to Sage 100 2019.  When I went back to version 2018, I was at least able to have it read the first line.  The issue I am running into now is when it reads the second line of the PO Receipt.  It will read the first line just fine, but then when it gets to the second line I receive an "Error: 0 in Method GETVALUE.  I have my code checking the BoF and EoF and I both of those are returning the correct values (True and False), but not sure why it is erroring out on the reading of the second PO Receipt line?  Any ideas would be appreciated.  Below is a screen shot of the code and the results of the BoF and EoF (of course the BoF is only read prior to the first line).


------------------------------
Dan Isaacson
Bennett Porter
------------------------------

Original Message:
Sent: 10-11-2019 03:01
From: David Speck II
Subject: Sage BOI writing a PO Receipt of Invoice

After you have set the purchase order number and invoice number, try using retVal = oPOInvoiceEntry.nCopyPurchaseOrderLines(nComplete)
The parameter is a Boolean to indicate whether you want to receive/invoice complete.

If the retVal is True/1 then it was successful.
You can then do a oPOInvoiceEntry.oLines.MoveFirst() and check the retVal for True/1 or check if oPOInvoiceEntry.oLines.BoF and oPOInvoiceEntry.oLines.EoF is not True.
You can also check oPOInvoiceEntry.oLines.HeaderHasLines, if True/1, then lines exist.
You can also check oPOInvoiceEntry.oLines.GetRecordCount("Main") which will return the number of records in the "Lines" for the current header if in SET mode which it should be.
Don't use the header write until after you are done updating the lines.
From my brief testing, in the actual task with the command window, using CopyPurchaseOrderLines with a True parameter did set the quantity invoiced to the quantity ordered but did not touch the quantity received, just FYI.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

First, what value are you passing to the CopyPurchaseOrderLines method, i see you have the variable nComplete which i used as an example but you should be setting either the variable to 0 (don't receive complete) or 1 (receive complete) or just pass either a 0 or a 1 to the parameter.
Second, i don't see you initializing the variables used in the GetValue methods to the correct data type.
ProvideX is very picky about numeric and string data types and does not handle the Variant data type which is the default data type for a variable declared in VBScript without a value.
You should make a habit of first assigning either a blank string or a zero to your variables that are passed to any sage 100 methods where a value is returned in the variable you passed in.
In other words, before calling a method like GetValue, either at the beginning of the line as a compound statement, add [i_ItemCode="" : ] or on a separate line above the GetValue for the ItemCode, have [i_ItemCode=""]. 
So either this.


------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 10-11-2019 20:27
From: Dan Isaacson
Subject: Sage BOI writing a PO Receipt of Invoice

David,

Thank your for the information.  However, it turns out part of my issues appear to be related to Sage 100 2019.  When I went back to version 2018, I was at least able to have it read the first line.  The issue I am running into now is when it reads the second line of the PO Receipt.  It will read the first line just fine, but then when it gets to the second line I receive an "Error: 0 in Method GETVALUE.  I have my code checking the BoF and EoF and I both of those are returning the correct values (True and False), but not sure why it is erroring out on the reading of the second PO Receipt line?  Any ideas would be appreciated.  Below is a screen shot of the code and the results of the BoF and EoF (of course the BoF is only read prior to the first line).

------------------------------
Dan Isaacson
Bennett Porter
------------------------------


Original Message:
Sent: 10-11-2019 03:01
From: David Speck II
Subject: Sage BOI writing a PO Receipt of Invoice

After you have set the purchase order number and invoice number, try using retVal = oPOInvoiceEntry.nCopyPurchaseOrderLines(nComplete)
The parameter is a Boolean to indicate whether you want to receive/invoice complete.

If the retVal is True/1 then it was successful.
You can then do a oPOInvoiceEntry.oLines.MoveFirst() and check the retVal for True/1 or check if oPOInvoiceEntry.oLines.BoF and oPOInvoiceEntry.oLines.EoF is not True.
You can also check oPOInvoiceEntry.oLines.HeaderHasLines, if True/1, then lines exist.
You can also check oPOInvoiceEntry.oLines.GetRecordCount("Main") which will return the number of records in the "Lines" for the current header if in SET mode which it should be.
Don't use the header write until after you are done updating the lines.
From my brief testing, in the actual task with the command window, using CopyPurchaseOrderLines with a True parameter did set the quantity invoiced to the quantity ordered but did not touch the quantity received, just FYI.

------------------------------
David Speck II
Tennessee Software Solutions

David,

Thank you for the detailed info.  It appears my issue was assigning the blank or zero value, thank you for that type and will be sure to include that in all my future scripts.

------------------------------
Dan Isaacson
Bennett Porter
------------------------------

Original Message:
Sent: 10-11-2019 20:59
From: David Speck II
Subject: Sage BOI writing a PO Receipt of Invoice

First, what value are you passing to the CopyPurchaseOrderLines method, i see you have the variable nComplete which i used as an example but you should be setting either the variable to 0 (don't receive complete) or 1 (receive complete) or just pass either a 0 or a 1 to the parameter.
Second, i don't see you initializing the variables used in the GetValue methods to the correct data type.
ProvideX is very picky about numeric and string data types and does not handle the Variant data type which is the default data type for a variable declared in VBScript without a value.
You should make a habit of first assigning either a blank string or a zero to your variables that are passed to any sage 100 methods where a value is returned in the variable you passed in.
In other words, before calling a method like GetValue, either at the beginning of the line as a compound statement, add [i_ItemCode="" : ] or on a separate line above the GetValue for the ItemCode, have [i_ItemCode=""].
So either this.

Or this.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 10-11-2019 20:27
From: Dan Isaacson
Subject: Sage BOI writing a PO Receipt of Invoice

David,

Thank your for the information.  However, it turns out part of my issues appear to be related to Sage 100 2019.  When I went back to version 2018, I was at least able to have it read the first line.  The issue I am running into now is when it reads the second line of the PO Receipt.  It will read the first line just fine, but then when it gets to the second line I receive an "Error: 0 in Method GETVALUE.  I have my code checking the BoF and EoF and I both of those are returning the correct values (True and False), but not sure why it is erroring out on the reading of the second PO Receipt line?  Any ideas would be appreciated.  Below is a screen shot of the code and the results of the BoF and EoF (of course the BoF is only read prior to the first line).

------------------------------
Dan Isaacson
Bennett Porter


Original Message:
Sent: 10-11-2019 03:01
From: David Speck II
Subject: Sage BOI writing a PO Receipt of Invoice

After you have set the purchase order number and invoice number, try using retVal = oPOInvoiceEntry.nCopyPurchaseOrderLines(nComplete)
The parameter is a Boolean to indicate whether you want to receive/invoice complete.

If the retVal is True/1 then it was successful.
You can then do a oPOInvoiceEntry.oLines.MoveFirst() and check the retVal for True/1 or check if oPOInvoiceEntry.oLines.BoF and oPOInvoiceEntry.oLines.EoF is not True.
You can also check oPOInvoiceEntry.oLines.HeaderHasLines, if True/1, then lines exist.
You can also check oPOInvoiceEntry.oLines.GetRecordCount("Main") which will return the number of records in the "Lines" for the current header if in SET mode which it should be.
Don't use the header write until after you are done updating the lines.
From my brief testing, in the actual task with the command window, using CopyPurchaseOrderLines with a True parameter did set the quantity invoiced to the quantity ordered but did not touch the quantity received, just FYI.

------------------------------
David Speck II
Tennessee Software Solutions