Can't access lines of receipt of invoice

Question

I created a receipt of invoice, applied PO to it, changed some info- and in the end I called 
 record.nWrite(); 
 where record is the pvxDynamic representing PO_Receipt_bus. I know that after the write, I have a new receipt in Sage and it's valid 
 
 right after the call to write I want to go through the lines of the invoice I just created. 
 If I call record.oLines I get the error - "You cannot select a purchase order number that has not been applied to this entry." 
 If I call record.oLines after calling setKeyValue for ReceiptType$ and ReceiptNo$ (followed by setKey()), I get the error - "Missing or Invalid Header". 
 
 Does anyone know why does it happen and how to fix it?

David Speck · Answer

Not sure what you mean when you refer to "check in debug mode", if you mean DFDM, you are correct, the lines are not written to the physical file until the header write because they are maintained in a *Memory* table until the header write is successful. 
 Regardless, the ExtensionAmt should be calculated after you set the quantity and/or cost. In the FLOR, i do see a local method called CalculateExtension that you could try to call but I'm not positive that it will be exposed to the lines object handle you are getting from the header object. 
 Another thing you could try is after your header write, try following it up with the nClear method, and then try using SetKeyValue and SetKey. 
 You may also want to try the header's nSetCurrentKey method after the SetKey, you should be able to pass the returned value of the header's sGetKeyPadded() method to it

Sage 100

Can't access lines of receipt of invoice

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING