Hello,

I could use a hand please. I can't seem to control the "Posting Date" on the Sage 300 invoice creation if I follow the process Realisable outlines here. The invoices are created, but the posting date is today's date, rather than what I've mapped to the O/E Shipment "Posting Date." Posting date is correct on the shipment and not on the invoice.

During troubleshooting I uncovered more problems that I would like advice on.

Since I can control Invoice posting date in the UI I decided to try 3 connectors: Order, Shipment, and Invoice. 

The order & Shipment are created ok. The invoice is giving me problems. 

1. The first problem is that I can't find the "PO Number" field to map to in the O/E connector. Is this a version issue? 

Product Update: Product Update 5

Config Version: 4.26

DB Version: 4.20

2. The second, bigger problem is that I can't create an invoice without getting this error: "Error: Object variable or With block variable not set"

This suggests that something is missing in my mappings but I am not sure what is missing.

Based on Errors.txt I think the problem is related to the shipment line number or invoice line number, both of which I am mapping.

Errors says:

Object variable or With block variable not set
Time='03/16/22 07:10:58' App='IManEngine:3.2.100' ADO-version='10.0' Computer='UDC5TS1'
Method: AccpacOEInvoice.CreateDetailEntry
Number: 91 = &H5B = vbObjectError + 2147221595 = ERRMAP_APP_FIRST + 2147216397
Source: IManEngine
Description: Object variable or With block variable not set
Call Stack: AccpacOEInvoice.CreateDetailEntry(lLineNum=0, bFromMultipleShipments=False) ---------
Env: l=0, m=0, iLnType=1, sTaxClass='', sTaxIncBeforePrice='SH00174156', sShipNum='', bKitAssembly=False, bMiscCharge=False, bNewMiscCharge=False, bTaxIncBeforePrice=False
Call Stack: AccpacOEInvoice.CreateInvoice() ------------------------------------------------------
Env: l=0, p=0, lShipNumInc=0, s='5', sShipNum='SH00174156', sDistTax='', sCustomerNumber='', bCalcTax=True, bDistTax=False, bFromMultipleShipments=False
Call Stack: AccpacOEInvoice.AccpacImport_CreateTransactions() ------------------------------------
Call Stack: TransformAccpac.PerformTransform() ---------------------------------------------------
Call Stack: TransformAccpac.ITransformController_Process() ---------------------------------------
Env: sCompany='', l=1, bSupportsDynamicCompanies=True
Call Stack: TransformCoordinator.RunTransform(sTransformId='SGW-Invoice') ------------------------
Env: eTransformType=90, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='SGW-Ship') -----------------
Env: sTransformId='SGW-Invoice', l=0, m=0
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='MAP-010') ------------------
Env: sTransformId='SGW-Ship', l=0, m=1
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='XLS-GetNewInvoices') -------
Env: sTransformId='MAP-010', l=0, m=0
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='XLS-GetNewInvoices', l=0, m=0
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd='"STRTST_OEINV010"'

Mapping is shown.